Search results for query: *

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?

This is the code in the main form Private Sub Combo70_NotInList(NewData As String, Response As Integer) DoCmd.OpenForm "frmPhyEntry", acNormal, , , , acDialog, NewData Response = acDataErrAdded End Sub and the previous code is in the pop-up form.

Ken The form opens in response to the NotInList event however the new data does not get added. If I then enter the data on the form myself and close the form, I get a messege to "choose an item from the list" (the new data is, however, in the list now because I entered it on the...

KenReay I am looking to do just what you mention. I would like a form to open when the NotInList event occurs. The form would be based on a table that is also used to populate the original combo box, but the form would allow more data to be input which isn't included in the combo box.

Make sure you have a reference to the DAO object library in your database. While in the Visual Basic Code Editor click Tools then References. In the References dialoge box scroll down to Microsoft DAO 3.6 Object Library and click the box to place a check mark. You may also want to remove the...

Thank you billpower for the welcome and for catching my mistake. You are right, the combo box entry adds to the list when Cancel is chosen. I generaly use a generic function for the message box. In this case I was trying to put it all in the same procedure and ended up with the error you...