Recent content by InspectorHound

Hi, I have an unusual problem. My office has a paper form on which certain fields must be filled. This form only exists in paper format; there is no electronic version. It was recommended to me that the best way to fill out this form is to create an Excel spreadsheet that contains the answers...

Thanks! It worked

Thanks, but this does not work.

I can't do that because the second SELECT clause will change depending on what the user does a search on.

I posted it on June 12: [AuthorizationId] in (Select AuthID from (SELECT * FROM qryUserAuth WHERE 1 = 1 AND [traveler last name] Like "*Bojko*" ))

Yes, that works. But I still can't get the where clause to be passed when the Where clause AuthorizationID is in a set of values returned from a query. I have: DoCmd.OpenReport "Expense Report", acViewPreview, , strWhere strWhere = "[A.AuthorizationId] in (" & reportSQL & ")" reportSQL =...

They are both data type 'Short Text' This is a pretty simple command so I don't understand what I am doing wrong. When I hard-code the value passed from the form (from Debug.Print) directly in the report query, it works. The Open Report command is opening the report, but not passing the Where...

I get a sytax error in query expression <expression>. (Error 3075) DoCmd.OpenReport "Expense Report", acViewPreview, , "[AuthorizationId] = " & Me.VoucherID

Something must be wrong with the report. Even when I try to pass a single variable, the where clause of the report does not change and all records are returned: DoCmd.OpenReport "Expense Report", acViewPreview, , "[A.AuthorizationId] = " & Me.VoucherID

Fisrt Query that populates form: SELECT * FROM qryUserAuth WHERE 1 = 1 AND [traveler last name] Like "*Bojko*" Second query to get the id number of people displayed on form: Select AuthID from (SELECT * FROM qryUserAuth WHERE 1 = 1 AND [traveler last name] Like "*Bojko*" ) The where clause...

Yes, the code compiles. The value of strSQL is *~*~*~*~*~*~*~*~* Yes, the code compiles. The value of strSQL is *~*~*~*~*~*~*~*~* SELECT * FROM qryUserAuth WHERE 1 = 1 AND [traveler last name] Like "*Bojko*" ~*~*~*~*~*~*~~* The Filter box is empty I am now getting the message that...

Ok, but now the where clause is not being passed to the report. Here is my code: /******************************************************************** Public Sub cmdReport_Click() reportSQL = "Select AuthorizationID from (" & strSQL & ")" MsgBox reportSQL strWhere =...

Ok. Will try that tomorrow

Ok.. Can I do that in the where clause of the DoCmd Open Report statement

I use a query that selects handful of people (from thousands) based on search criteria entered by the user. I then want the report to use the ten or so IDs displayed on the form to show expense data for these people from another table.