Search results

I guess you can't have a post of less than 10 characters. Your suggestion yielded the same error, I attempted to use the "FindFirst" method of the recordset object instead and IT WORKED OMGGGGG. The working line is: rstCalibrationGroup.OpenRecordset.FindFirst "txtCalibGroup = '" &...

Text. This is now more than 10 characters.

Thank you very much. Here's the highlighted line. rstCalibrationGroup.OpenRecordset "Select * from tblCalibrationGroup WHERE [txtCalibGroup] = '" & Me!cboFilter & "' "

Open database project (Microsoft Access file type). Open form frmCalibGroupOrganizer in design mode. Hit Ctrl+G to open code view. Click the "stop" button in the top toolbar. Close code and design view. Open form click button same Error window with error and "OK" button, no "Debug..." button...

This is definitely going to sound stupid. When I open my form in design mode and then hit Ctrl+G to pull up the debug window, under the Debug pulldown I can't compile the code and when I try to step into it I get the "Windows error sound" and nothing happens. I read the 3421 error when I open...

Me!cboFilter is the combo box who's rowsource is based off the txtCalibGroup in the table tblCalibrationGroup, which is a Text variable. I would assume that the text variable in a table is a String? I am certain this line Me!LstSearch.RowSource = "SELECT txtLabNum FROM...

Code for a "Search button", lookups the record if not found adds the record to the table. I don't recognize where the 3421 Data type conversion error comes from. Private Sub Search_Click() On Error GoTo Error_Search_Click: Dim db As DAO.Database Dim rstCalibrationGroup As DAO.Recordset...