change query using macro in access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I send several reports to several different people on a daily basis. I would
like to set up a macro to change the criteria in the queries that I have set
up. I know that I can set up the criteria to ask me for the information, but
I am looking to automate some of the process. Any help would be much
appreciated.

Thanks.
 
Not sure it's possible using a macro. It's fairly straight-forward using
VBA, though.

Assuming you've got a stored query named qryMyQuery, and you know that your
SQL should be what's in variable strSQL, you can change the query using:

CurrentDb().QueryDefs("qryMyQuery").SQL = strSQL
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro Operations Cause Access '03 to Crash. 4
How to Use Field Twice in Query 1
Prompting for Criteria already defined in Report/Query. 1
Access macro: How to output 3 queries to 3 tabs in 1 Excel workboo 8
DateSerial in Macro Condition 4
Record Macros in Access 2003? 1
Passing a value from a macro to a Query Criteria 1
Macro to change a query 2

Back
Top