Recent content by MarkW

Thanks for all the help everyone. I've solved my problem by inserting the Where string into the query's filter instead of the criteria field as follows: DoCmd.OpenQuery stDocName DoCmd.ApplyFilter stDocName, WhereStr DoCmd.OutputTo acOutputQuery, stDocName, acFormatXLS, , True Thanks again all!

The goal here is to export the query to Excel once filtered. This doesn't work so well in report format.

You're right Pat... the criteria string is misinterpreted by the query. I was able to build the SQL string successly for a simple query in VBA, however... The existing query I'm trying to apply this to has a very long SQL (20 columns from my table, with sums and group by statements). It's...

Hmmm... I'm more confused now. The only code I have on the form is the code that opens the query (DoCmd.OpenQuery) attached to the event procedure of a command button. Maybe I'm doing this wrong. I'm trying to have the button on my form open the query, while the query contains a function in...

Hello... I've read through several related topics here, but can't find a way to make this work. I have a multi-select (Branch List) list box on my form (Main Menu) in which I need to create a string based on the selected branches and use as the criteria for my query. I have the following code...