Search results

Sounds like you may have multiple serial numbers per customer? If so, you should have a table for customers and a separate table for serial numbers -- linked by a one-to-many relationship. Then, when you create your data entry forms, you'll have a main form based on a query of the customer...

If you aren't already, you should be storing the specs for each vendor in a table. (I don't know your DB's structure, so I can't tell you which table!) Ensure that the query upon which your report is based includes this specs field. Then, set up your conditional formating to compare the sample...

Hmm... typically, changes made to records in a sub-form would not be tracked in the table upon which the main form is based. Rather, they would be tracked in the table upon which the sub-form is based. Are you sure this is what you want to do?

In general, you should have a single report which uses a single query as its record source; the criteria (to limit the results displayed on the report) should be fed to the query when the report is launched. For example: Your query contains Field1, Field2, and Field 3 Your report is based on...

Do a search on "audit trail" ghudson has provided a great sample: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=44231&highlight=audit+trail

The basic answer: Use columns. The longer answer: Here's how I used columns to handle a similar situation... Use "Page Setup" to set report up in "Landscape" format. While you're there, set "Number of Columns" to 5 and Set "Column Layout" to "Down, then Across". Go back to the design view and...

If your goal is a combo box that lists "things we sell", the following might help... If "products" and "services" are stored in separate tables, then you should be able to create a union query that pulls in the necessary values from each (say, the ID and description fields). Then, you would...

I have a 7-column report that lists the events associated with each of the 7 days of the week. This works fine, when there is an event on each of the 7 days; but... when there are events on only (say) 4 days of the week, then only the first 4 columns are used. Ideally, each of the 7 columns...