Search results

I've looked up a lot of error handling code and used the same error handling code in other areas of my project but this one ignores the "On Error" and still gives me the runtime error. Why? This code handles simple Calendar control and i'm using it with a subform control. As a workaround I'm...

Hello, I'm trying to export a query of my database structure to an excel file: I have a Query based on form control and a form with a combobox and Command button to execute export. I'm having problems opening the SQL statement or query in the OpenRecordset command. I get two different...

'Delete command button removes selected laboratory number and calibration group from the tblCalibrationGroup 'Currently broken Private Sub Command12_Click() For i = 0 To LstSearch.ListCount - 1 If LstSearch.Selected(i) Then Dim strSQL As String strSQL = "...

Almost done with my database application and getting into creating Reports to print off. The guide I'm trying to follow as a report is as attached (Output Report). I've made a query with all of the information that I need from my linked tables (relationship map as shown in attached files) With...

I have a Date/Time text box on a form that goes back to a Date/Time field in a Table. I want this text Box to only display a Long time format, and it works until I click into the text box and it changes to a Full Date/Time format. I have the Format and Input Mask set to Long Time in both...

I have an issue where my rstCalibrationInformation.NoMatch is not working. I would like to have a combo box where a user can pick a txtCalibGroup (PK) and a listbox will show a query related to the PK. That works fine, however I would like if the user entered a PK that doesn't match any of the...

I have searched for this for a while and I think I've come up with maybe an idea of how to do it. I have a form for a Sample where one field takes in an auto-number userID for which ever person received the sample. The auto-number userID comes from a linked table name tblUsers that along with...

Compile Error Expected: list seperator or ) On the first line. DLookup("usrID","tblUsers", "[txtFName] = '" &Me.txtFName& "' "_ & "AND [txtMInitial] = '" & Me.txtMInitial & "' " _ & "AND [txtLName] = '" & Me.txtLName & "' ") Can anyone point this out for me?

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