Search results for query: *

Hi all, Is there a way to loop through the fields in a DAO recordset without refering to the field names. I would like to be able to determine the number of fields in the recordset and loop through all the fields checking for nulls on the fly. Thank you for your help.

Hi, I have the following code in an on click event to check if all the fields in a query have data. A message box displays which fields are missing data. I continue to get a "Next withot For" error when this code runs. Any suggestions? Private Sub cmdQueryTest_Click() Dim db As...

Hi all. Is there a way to open a form without any of the fields on the form having focus, or will the first field in the tab order always have focus?

I have a subform which shows demographics for a physician associated with a patient on the main form. There is a combo box to select a physician's name which then fills in the physician's demographics if the physician already exists. If a new name is entered in the combo box, the NotInList...