Recent content by daklem

Thank you Golom and Jerby, Just what I needed

Golom, Thanx, I will try that and let you know how it works.

randy 700 I just need to know if there are any nulls, not which field is null

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.

I figured it out. I forgot the "End If" before the "Next i" Thanks

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

Thanks earthandfire and missingling for your responses. The unbound text box worked just fine.

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?

Doesn't work right. This is what I have right now: Private Sub cboPhySelector_NotInList(NewData As String, Response As Integer) strTitle = "Physicians" strMsg = "Would you like to add " & NewData & " to the " & strTitle & "?" Response =...

Thanks Ken, Sounds like that might work. I am not at my database right now but I will try your suggestion and get back to you.

Thanks Ken, Let me be a little more specific. There are 3 tables: tblPatients PatientID (auto) (PK) PtLastName PtFirstName tblPhysicians PhysicianID (auto) (PK) PhyLastName PhyFirstName tblPtPhyDetail DetailID (auto) (PK) PatientID (FK) PhysicianID (FK) Both the Patient and Physician...

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

Cailo, Are you opening the form from the database window or from another form? If its from another form, create a command button and in the OnClick event procedure for that button put: DoCmd.OpenForm frmName, , acNewRec Where frmName is the name of your form. If you want to open the...

Let me clarify things a little. I have two tables: tblPatients PatientID (PK) (auto number) FirstName LastName PhysicianID (FK) tblPhysicians PhysicianID (PK) (auto number) PhyFirstName PhyLastName There is a main form with based on tblPatients and a subform on the main form based on...

Hi, I'm a little unfamiliar with the debugging tools. Would you be able to walk me through the process?