Search results

Thanks , I'm new to this & just starting to learn, but I'm sure you knew that. My goal is to become as good as the Great boblarson.

Oh, so something like this? Build the new SQL statement incorporating the string strSQL = "SELECT * FROM [Vendor Hotline Log] " & _ "WHERE " & strCriteria & ";" ' Open the report DoCmd.OpenReport "Date Range", acViewPreview ' Apply the new SQL statement to the query...

That makes sense. thanks. I ran it now but for some reason it is using the date range selected but not the status selected. It gives all data. It doesn't make sense because in my immediate window it shows that the status was selected. Immediate window SELECT * FROM [Vendor Hotline Log] WHERE...

That worked but my query now only has the dates I selected & the status I selected. It's like it only works once & you have to select the fields in the query again. Why would it do that?

The dates are stored in vendor table

Here is my new coding & what is in the immediate window. It's not giving me any date even though it should be. Date Range criteria Debug.Print strSQL strCriteria = strCriteria & " AND StartDate = #" & Me.StartDate & "#" & " AND EndDate = #" & Me.endDate & "#" Immediate Window SELECT *...

You are a comedian! You're right it would be hard to see:D

That's seems to only give me able to choose a start date but I need to choose both a start date & end date

I have this coding for a user form that allows them to select a date range & a status, Open or Closed. This is the coding I have but I think there is something missing. Private Sub OK_Click() ' Declare variables Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim varItem As Variant...

I have this coding. The form the user has let's them select a date range & a status of Open or Closed. I think the codings right but no matter what date or user selects it brings up everything for whichever status was chosen. Once the code is run I look into the query & there is only 1...

How can that help?

Query resets blank after it is run from a form This used to work properly but am now having issues & can't figure out what changed. I have a query that gets generated when a date range is selected & a status is selected. When the report is created it only uses the search criteria of the Status...

What would the coding look like?

What if I wanted to open in report format. How much would I need to add?

I got it now. Thank you for your hel:D

It's still giving me the same syntax error just with the changes made it the code Syntax error (missing operator) in query expression "*[*Vendor Hotline Log*]*.Status = "Closed" OR *[*Vendor Hotline Log*]*.Status = "Open"

Hi, I am getting a syntax error on a form that I am trying to make multi-select work. There is a date rage the user can choose but also if something is open or closed or both. The error is Syntax Error (missing operator) in query expression 'Vendor Hotline Log.Status = "Closed" OR Vendor...

Re: HELP new syntax error I am now getting a new error & I know it's something simple I'm just not seeing & it's driving me crazy. The error is missing operator in query expression 'Vendor Hotline Log.Status = "Closed"'. I think it might be in my query in the Status field I have this in...

It is almost there, I didn't need to use the brackets. When I click on the OK cmd button it still gives me the compile error 3131 Syntax error in FROM Clause & highlights the qdf.SQL = strSQL line but when I mouse over the StrSQL is is showing that I have selected both Closed & open status or if...

Where does that go?