Search results

Time to troubleshoot... Is the audit trail code in the subforms being triggered at the appropriate time? If yes, then are the audit trail variables being correctly assigned values? If yes, then are the audit trail form fields being correctly populated by those variables?

In my case, I have included the audit fields on my form (visible = false). The code that writes the audit info puts the values into those form fields. This code is triggered by the Before Update event.

Yes - it does work for query-based forms (as all of mine are). Just include the audit trail fields in the query.

Here is an example that may get you started... tables, queries, forms, reports. hope this helps

How are the three things related - personid, clubid, unumber? What is the table structure of your database? I suspect you might have a table of persons and a table of clubs. And, if people can belong to more than one club, you have a many-to-many relationship between tables persons and clubs -...

Typically, this code would go in the On Click event of a button.

There is an easier way... construct your tables so you aren't storing multiple values in a field. To handle the U numbers will require three tables: the table you've asked about a table of U numbers a table linking records from the first table to records in the U number table Do yourself a...

If the value that is stored in the make field is a string, then the criterion must be enclosed in quotation marks - e.g., "BMW" If the value that is stored in the make field is a number (say, the primary key value from your makes table), then the criterion should be a number and not enclosed in...

Re Refreshing Report Reports are intended to be static snapshots - once generated, they are not updateable. As to whether you can cause a new report to be generated and "replace" the current report... I'm sure some clever coder on this forum can provide the gory details for you. Re Headers Not...

It's probably possible to filter the form - I don't use filters, so I have no idea. Why don't you want to base your form on a query? It is generally best to use a (stored) query (rather than a table) as a form's record source. Among other things, using a query allows you to easily sort the...

If they're both text, then perhaps you need to enclose the Me![search] value in quotes: strSearch = "[id] = '" & Me![search] & "'"

1) To show only records meeting a certain requirement, use a query with a WHERE clause as the recordsource of your form. 2) To have a sub-form show records related to the record shown in the main form, ensure that the Link Child Fields and Link Master Fields properties of your sub-form are set...

Len, Here is an A2K example of the first option - storing the ID of the main contact in the Company table. Again, I'm still not sure that this is the "correct" approach. I've applied referential integrity rules to ensure that you can't delete a contact if that contact has been designated as...

Len - I'm afraid I misunderstood the situation. It appears that you have a one-to-many relationship between Customer Companys and Customer Contacts... disregard my comments re junction table. You will need to decide whether you want to store the "main contact" info in the Company table or the...

Len, You can't make a query of a form; queries are based on tables (or other queries). You should be making a query of the junction table that links customers and contacts. What are the names of this table and its fields?

The Row Source for your combo should be a query based on the lookup table for the many-to-many relationship between customers and contacts. Use a WHERE clause to limit the returned records to only those contacts associated with the selected customer.

You could also do it this way (which, to my feeble mind, seems more intuitive - using DISTINCT instead of GROUP BY): SELECT DISTINCT Jobcard.PLACE FROM Jobcard WHERE Jobcard.PLACE IS NOT NULL ORDER BY Jobcard.PLACE;

run the "Find Unmatched Query Wizard"

Sounds like you want to append (i.e., concatenate) the new text to the existing text in a field, yes? If you want the new text to follow the existing text, then use an expression similar to this: txtMyText = txtMyText & myNewCannedText where txtMyText is the name of the control that contains...

Create a crosstab query based on qry_RPT_Glycol. Use SampleDate as row heading. Use Outlet_ID as column heading. Use First FlowValue as calculated value for row and column intersection. If you want Outlet (instead of Outlet_ID) as the column heading... First, add the field Outlet, from...