Pass-Through Queries

  • Thread starter Thread starter Bre-x
  • Start date Start date
B

Bre-x

Hi,

Can you modify the sql statement of a pass-through query using VBA?

Thanks

Bre-x
 
Bre-x said:
Hi,

Can you modify the sql statement of a pass-through query using VBA?
Click to expand...

CurrentDB.QueryDefs("NameOfQuery").SQL = "New SQL"
 
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 values to a function 2
Web Toolbar 2
Update table script 6
ms access as a backend 1
change the value of a combo box 2
LCase? Title Case? 3
Field Size: Integer to Double 5
Trim function 9

Back
Top