running make table queries

[randomGuy]

Using code how do I run a make table query?

 

[K9Boxer]

MS Access 97:

An easy way to generate code is to create a Macro with the function you would like to accomplish. Then select the "SAVE AS/EXPORT" option under FILE. Select "SAVE AS VISUAL BASIC MODULE".
After that you may elect to include "ADD ERROR HANDLING TO GENERATED FUNCTION" and/or "INCLUDE MACRO COMMENTS".

The code now exists under MODULES as CONVERTED MACRO-macroname. From here you can copy/paste the code where you need it.

Hope this helps you in the future.

 

[randomGuy]

Uhh...problem is I cant find that action, that's why I asked for code...

 

[RemyS]

Create the Query you want in design view - Test it to make sure it does what you want.

Then switch to SQL view and copy the code.

in your module use the command;
DoCmd.RunSQL "paste the SQL here;"
and hey presto you have your query in code.

Good luck Still new to DB's and enjoying learning day by day

 

[K9Boxer]

OR:

Create the MAKE TABLE Query you want in design view - Test it to make sure it does what you want.

In you code, place:
DoCmd.OpenQuery "Make Table Query"

Still new to DB's and enjoying learning day by day - me, too!!!