Search results

I am getting a new error know Private Sub cmdOK_Click() Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Dim varSelected As Variant Set cn = New ADODB.Connection Set rs = New ADODB.Recordset With cn .Provider = "Microsoft.Jet.OLEDB.4.0" .Properties("Data Source") = "C:\Documents...

I am getting the following error "Run-Time Error '3201': You cannot add or change a record because a related record is required in table 'tblPatientDemo' " I placed the following code in a command button Private Sub cmdOK_Click() Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Dim...

OK I did a search but was more confused How do I get the values that are selected in the list box using a for statement? Please can you include comments so I know what's going on in the code?

created a main form called "frmPatientDemographics" that contains txtFirstName (Text Box) txtLastName (Text Box) txtDOB (Text Box) txtCountry (Text Box) cboGender (Combo Box) it's record source is a table called "tblPatientDemo" that are populated based on the information place in...

I have created two table in my database listed below tblEmployee EmployeeID{Primary Key, Auto Number} FirstName LastName PositionTitle tblWorkHistory EmployeeID {Foreign Primary Key} Organization {Primary Key} Position StartDate EndDate I am creating a one to many relationship with the...