Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS & have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for

Where Did My Snap To Grid GO?

I have Grid X and Grid Y set at 24. Usually I see dots all over my forms.... which allows me to snap controls to the grid. Today I only see large boxes instead?

Did I change some setting?


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
I would like to seek guidance again on my new project, I wanted to create a data entry form that the user can input records using my unbound label boxes, then upon hitting an add button it will go automatically on a subform below or a GRID so that the user can see all the records at a glance.

View Replies !   View Related
Using DCount() In Query Grid
I am a beginner with aggregate functions.
I have two tables, one describing parts, and one describing assemblies that use those parts:

tblParts show all the part descriptions, including fldPartNumber.

tlbWhereUsed shows zero or more fldAssemblyNumber records for each fldPartNumber.

I want a query that shows, for each record of tblParts, the number of assemblies that use that part. I specifically want to do this with an aggregate function:

DCount("*","tlbWhereUsed ","[tlbWhereUsed].[fldPartNumber]=[tblParts].[fldPartNumber]")

but I don't know where to put this function call in the query grid.
(I do not want to do this in VBA, if I don't need to).
Thanks in advance...

View Replies !   View Related
DB Grid In MS Access Form?
Hi, I am beginner in Visual Basic and MS Access. Before, I worked with Delphi and there it was easy to use DBGrid component to view the database content on the form. Is there anything similar in Visual Basic forms? Thanks...

View Replies !   View Related
Flex Grid Control In MS Access
Hi all,

Can I add a flex grid control on a MS ACCESS form.

IF yes, does MS access 2003 has a flex grid control, i cant find one in the toolbox.

MAy I know where can i find the control?


View Replies !   View Related
Adding Two Fields On A Query Grid
trying to add 2 fields

=[field1] + [field2]

works but I want a space between the 2

how do you do that?


View Replies !   View Related
UK Postcodes In The Query Design Grid.
Hi everyone;

I am using Access 2003 with Windows XP Pro. I have a problem with using a query and the dreaded UK Postcodes!

I have a Client table that contains a field “Client Postcode 1”, in which is entered the first part of the UK postcode i.e. AB11, WC1A, E1, EC2V, etc.

In a Candidate table here are many text fields where we enter which postcode a Candidate wants to work in, i.e. TN, CV4, EC, W, etc.

We have a separate Candidate Search form where we select a particular client (Combo box from the Client table) which then displays the Client’s Postcode 1 data i.e. the first part of the UK postcode before the space.

We have a select query that then tries to match the Client Postcode 1 with the postcode that the Candidate wants to work in from the Candidate’s table.

In this query design grid I have successfully created criteria that will match the Client Postcode 1 field to the Candidate’s postcode field – very straightforward. This, for example, will match a Client with a TN39 postcode with a Candidate who wants to work in the TN39 postcode.

In the same query design grid I have also been able to successfully match the Client Postcode 1 field to a Candidate’s Postcode field using just the first 2 letters (using Left). This matches a Candidate who wants to work anywhere in the TN postcode area (TN1, TN2 etc.) with a Client whose postcode starts with TN

However, what is stumping me is where a Client’s Post code has only 1 letter followed by numbers (E1, B2 etc) in the first part of their postcode without returning EX, BL etc. I would like the accumulated wisdom on this forum to point me in the right direction to design criteria to input into the query design grid that will match ONLY the first letter of the postcode IF the second character is a number.

Regards to all - and what an excellent site!

View Replies !   View Related
Date Value Query Grid Problem
I have the following field which is stored as a string: [field3]"2006090111123500"

the first 8 characters represent the date but backwards.

I want to filter between dates.

I have the following in the query grid:

CallDate: DateValue(Right(Left([Field3],8),2) & "/" & Mid(Left([Field3],8),5,2) & "/" & Left([Field3],4))

with criteria: >=#01/10/2006# And <=#31/10/2006#
This seems to work on october data no problem

I had hoped to put all the september data into the same data table and filter but it failed so I created a new table called september data and pointed the query to it but for september:
with criteria: >=#01/09/2006# And <=#30/09/2006#

however the query fails if I take out the calldate expression it works no problem.

In fact it works providing I dont try and filter on date or sort by ascending.

it says data type mismatch in criteria expression. I had hoped that datevalue would turn the string into a date.

Its strange that it works in one query and not in the other with only the data being different.

Can anyone see why this should fail have I done something stupid?

kind regards in advance.


View Replies !   View Related
Grid To Track Data In Common
I have a table with a list of dentists and which carrier's networks they are in. I want to produce a grid that will show a count of which ones each carrier has in common. The table has the following four fields; ID, Last Name, First Name & Carrier (see attached example). How do I set up the query to produce a grid like the one below:

Carrier ACarrier BCarrier CCarrier D
Carrier AN/A324
Carrier B3N/A44
Carrier C24N/A3
Carrier D443N/A

I tried a crosstab, but it is not quite getting me what I need. It shows the names along the rows, but then I have to look by hand to see where the name is in more than one carrier in the column.

View Replies !   View Related
How To Create A Report With Grid Lines?

In my first steps working with Access I feel unable to find out how can I create a report that shows the data (records from a Clients Table - Name, Phone, e-mail fields-) in a "spreadsheet like" format with gridlines. Can anyone help me on this?


View Replies !   View Related
Calendar 10.0 Ill Not Show Dates In Grid
I've coded a scheduling application (adp front end squel backend) that makes use of the activex calendar 10.0 control to allow for point and click filling of textboxes (schedule to and from) I forwarded the application to my brazil office and the clendar fails to display dates in the grid for
some users...I asked local IT support to make sure their regional language settings were all the same and still no dice??? I coded in a registration tester and I didnt get an error? Does anyone have any thoughts??? oh yes funny thing it works fine in Singapore and the UK?

View Replies !   View Related
Remove One Data Grid Control
I create form with master detail relation ship. It shows two data grid control. I want to remove one. I want to use one grid control by which i can add delete data in both tables.


View Replies !   View Related
Formating Date Field In Query Grid

How do I format Date field in query grid to make field into "11/11/2007" if the data originally has time, or in form "11 Nov, 2007" ?

View Replies !   View Related
What Is Best Control To Display Data In Grid Format?
I have a search page and would like to display the search results in a grid/table format. User will be able to select a row to go to a detail screen. What is the best component type to use for this?

View Replies !   View Related

Copyright © 2005-08, All rights reserved