Invoke Make-Table Query using VB

[ryan_quirk]

I am using the VB editor that comes with Access 2000. How do I run a make-query. I know how to do it using SQL commands for example creating an ActiveConnection and setting CommandText to the SQL Statement.... I want to be able to run the queries I have already created. I thought they were visible by typing in ADODB.... Maybe I do not have the correct References set. Please help.

 

[Joe4]

Where are you trying to call/invoke this make table query from? From Access, from a button, from something else?

 

[ryan_quirk]

I am in a Procedure in a Module.

 

[Joe4]

I assume you are talking about within an Access module. All you need to do is call your make table query to run it, i.e.

DoCmd.OpenQuery "MyMakeTableQueryName"

 

[ryan_quirk]

Thank you.