Recent content by Triscuit

CboOriginator is a global variable for the Main Form and is set to the control from the On_Mouse Down of that control. For example for the Main form Date of Calibration: Private Sub dateCalibration_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single) Set cboOriginator =...

Here's the image. Upon clicking in the Calendar it gives the '91' error, Object Variable Not set. However on this error it should go to the error handler and the Case 91 should operate from there.

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

I still get the same 3141 error when run. On the line: Set rst = CurrentDb.OpenRecordset(strTQName)

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

Thank you PBaldy. Deleting all of the spaces between the text quotes gave a syntax error but with some guess and check the form '" & Me.LstSearch.Column(0, i) & "' works. Gonna give your multiselect loop a whirl next.

'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 guess it was just acting a bit wonky. Closed and opened it a few times and it worked. Thanks for the reply Steve.

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

Much better idea, thanks.

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

Thank you nathansav! Left the control source as the userID for the Sample. Row source was changed to my query to include the userID then concatenated name. Followed your column settings and works awesomely.

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

Found the error needed spaces around the &Me.txtFName& goes to & Me.txtFName &