Recent content by sparlaman

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