Recent content by ppierce

Thank You to The_Doc_Man that was the fix it is now functioning as expected.

Thank you very much for your input. I have no experience using the Access VBA and have inherited this project from an ex employee. So your assistance is really appreciated. I have set up a watch window and I see the problem is the "Section" variable is not formatted correctly. It needs the...

I have this query, shown below, in my Access code behind below that should return one record. But it is coming back as empty. Can anyone see what my problem is StrSql = "SELECT tblOrders.*, tblFleetVendors.* FROM tblOrders INNER JOIN tblFleetVendors ON tblOrders.VendorId =...

I have a search form used to search for an OrderID. When the user clicks a button on this form I want to open another form that will show the order details. My code is shown below. Case "Req" Me.cmdDone.SetFocus GotoSearchTextbox If IsNull(Me.txtSearchTerm)...

You are correct the devil is in the details. Fixed the issue with the wrong control name and added the (Forms!CallForm2!Location) to the code. All is working now Thank you gentlemen for your time

Hmm not sure what you mean by code that does reference any form element. The onclick button checks the value of 4 form elements. The Call Location text box, the ComboType, Beat textbox and ReceivedDate and time these 4 are evaluated for a null value. If the location, type or beat are null...

Here is the code that sets the value of the DateTime Private Sub ReceivedDateandTime_Click() ReceivedDateandTime.Text = Now End Sub

I have a form with a text box I use to capture a datetime value on a button click. In the code behind I check to make sure a user has entered a date time value using this code: ElseIf Trim(ReceivedDateTime & "") = "" Then MsgBox "Call Received Date/Time Is Required" If the user forgets...

That works, thanks

So this code should work? ExitHandler: Exit Sub ErrorHandler: Select Case Err Case 2450 'strange error of form load code running on quit DoCmd.Hourglass False Resume ExitHandler Case Else DoCmd.Hourglass False Resume ExitHandler End Select...

Publish the database as an accde file and in the options clear the checkbox for show navigation pane. Note I am using MS Access 2010.

Here you go. I removed the error handler code. I have never uploaded anything to the forum so hope the file was included.

Thanks for all of the suggestions, however none of them solved the problem. I was able to locate the cause of the error but not a fix. The error message only shows if I deselect the Display Navigation Pane in the Current Database Options. If I leave that checked the Quit functions runs...

I have and Access 2010 application with 3 forms each form has a button that will close the database. The code for all three buttons is identical and looks like this Private Sub cmdQuit_Click() DoCmd.SetWarnings False Dim SQL As String SQL = "Delete from CallTakerData" DoCmd.RunSQL SQL...

I figured out. I changed the reports record source from the table to a query in the query I set the criteria to this [Forms]![CallForm2]![ID] that only returns the one record and the report only shows 1 record. Thanks for time.