Search results

thanks I'll give it a shot and see what happens. :)

Elaborate? Thanks for you response. DLookup isn't a function that I'm very familiar with. Could you please elaborate on the syntax and where to apply the code? Thanks, Shel

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."...

might this work? What I do for a similar situations to yours (if I'm understanding correctly) is add a yes/no field to the table that is running the combo box and then in my query I pull only the records with a no value so if one of the combo options needs to be removed it isn't totally removed...

Fixed Someone on another newsgroup answered me. So I thought I'd post the solution here. I did not have a reference set to the DAO object library. So in the VB editor I did the following: Click Tools --> References Put a check in for "Microsoft DAO 3.5 Object Library" thanks

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)...

FYI Solution I used This worked exactly as I wanted and it is VERY simple. nRecords = DCount("*", "Query1") If nRecords = 0 Then MsgBox "zero records.", vbInformation, "System Error" End If Thanks ALL!

Thanks! Thanks for the quick reply. I'll give that a whirl!

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

Yay! :D That worked fabulously. I must have been working on this problem for too long yesterday. Thanks VERY MUCH!

: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...

Fix created new problem OK, That worked, but created an new problem. Now when I enter criteria into any other field on my form the message box appears and the search does not run. I have been postin pieces of my code, this time i'll give all of it. Thanks Bunches :) ****Code***** Private...

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

Thanks! :D Thanks for all of your suggestions. With your help and some stubborness on my part, I have figured out all of the pieces. I have created a form where the user selects his username from a combo box and types his/her password into an unbound textbox. Then the user clicks OK which runs...

Re: Pat Hartman's Response Ok, let's say I have the table with the entry for each person along with his default animal type, any clues on what the code would be to store the values in a hidden form? Pat Hartman Moderator Join Date: Feb 2002 Location: Stratford,Ct USA Posts: 16,191...

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