Search results

Hi Jon - thanks for your response. The #Errors are now converting to 0s, and I changed my new query syntax to find those IDs that have converted to 0s. Works like a charm! :> Thanks again.

Hello - am hoping someone can help with the below query. I have a database with two linked tables. Both of them contain a 10-digit ID number. One table (Table 1) has this ID stored as text; the second (Table 2) as a double. I need to find records in Table 2 that are not in Table 1. I first...

Hi Brett - thanks for your quick reply. Such a simple solution, and it works for my database's purposes! :> Thanks again!

Hello - I have created a form for users to validate data. This form contains 20 text controls. 7 of these controls are designed to monitor validation status = values can be "N/A", "In Progress", "Pass All", or "Fail All". The names of these 7 controls begin with the characters "fld". I...

Hello - I have copied into my database some VBA code which automatically designates an existing field as a Primary Key, which works. However, if this code is referenced after the Primary Key is created, then I get the Primary Key Already Exists error. I want to add lines to the code that...