Search results

  1. X

    Referencing CDbl Value in Stored Query from a new query

    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...
  2. X

    Buttong Enabling contingent on several foem field values without using IF statements

    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...
    • xtcal
    • Thread
    • Replies: 1
    • Forum: Forms
  3. X

    Using VBA to detect whether Primary Key exists

    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...
Back
Top Bottom