changing value in query using macro

  • Thread starter Thread starter Tang
  • Start date Start date
T

Tang

Dear all,

How to change the criteria value in a query using macro or vba?

regards
 
Tang,

You can't really do this with a macro. You can do it in a VBA procedure
by opening a QueryDef object and setting its SQL property of the desired
string.
 
You must log in or register to reply here.

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

Passing a value from a macro to a Query Criteria 1
changing Parameter in macro 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Compact & Repair, Open table, close table, then run macro 3
Prompting for Criteria already defined in Report/Query. 1
A Report, based on query, called from macro is prompting for param 1
How to Use Field Twice in Query 1
Run Macro If Cell have "x" value 0

Back
Top