Search results

My database tracks employee training. I have tblClasses, tblEmployees, and tblRegistrations. I have a registration form with EmpName and subformClasses, which allows me to register one employee for several classes at a time. My registration form has an OK button. I need a message to appear...

Scenario: I am using the code below to verify that particular fields in my form are completed. This works fine but I want more. I have 2.5 questions about this. ;) If IsNull(Field1) Or IsNull(Field2) Or IsNull(Field3) Or IsNull(Field4) Then MsgBox "All required fields not completed."...

Scenario: I am trying to create a multi-select list box that will add records to one of my tables. I used the code created by Roger Carlson (suggested to me by one of the helpful folk here). I changed the field and table names to fit my database. Problem: I am getting an error (see below)...

Does anyone out there have any vba code that will allow me to count (verify) the number of records returned by a query? Thanks, Shel

:o HI All. I posted this on the Forms page but I thought maybe it is better suited over here. Anyway... I hope I'm not being a pest. :o Scenario: The code below allows me to enter a date range in an unbound form which then opens another form based on the date range. If I enter only one of...

Scenario: The code below allows me to enter a date range in an unbound form which then opens another form based on the date range. If I enter only one of the dates (the beginning or the end) and not the other. I have a message box display asking for the other date to be entered. Problem: The...

Is there a way to do the following? The scenario: The “Animals” database contains the “AnimalsInfo” table. tblAnimalInfo contains the “AnimalType” field. User1 is always entering data for Cats. User2 is always entering data for Dogs. User3 is always entering data for Fish. The question: What...