Search results

Here it is Private Sub OK_Click() ' Declare variables Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim varItem As Variant Dim strCriteria As String Dim strSQL As String ' Get the database and stored query Set db = CurrentDb() Set qdf = db.QueryDefs("Copy of Date...

It's still giving me the same error & highlights the same line

It's giving me a Run Time error 3131, Syntax Error in FROM clause & it highlights the qdf.SQL = strSQL line

Now I'm getting a new error. The expression On Click you entered as the event property setting produced the following error: Method or data member not found

Hi, I am having trouble in setting up this form. There is a table that contains all vendor calls we have gotten. On the form for data entry I have a button that when clicked another form appears so that the user can select a date range and can have select one or more selections for the "Status"...