Build and Display Query in Access Queries group 1

[cdgeer]

I would like to use VB code to build a query and have it show up in the Queries group of a MS Access database. Just like a Make-Table query would make a table and put it in Tables group.
Anyone know how to do this?

 

[traingamer]

Look at QueryDefs. See Microsoft's help file:

http://office.microsoft.com/client/...TT=1&queryid=8d6ee776c8b8403b888b4f7b8981cca6

or any number of places.

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

 

[cdgeer]

Cool! Thanks traingamer!