Search results

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

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

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 have not done any work in Access for about 8 years and have been tasked with creating a simple form with a button to print the data on the form to a report. I have a print button on my form with this code behind. Public Sub PrintReport() Dim strWhere As String If Me.Dirty Then 'Save...