Help on Query Codes

[claudz_08]

Hi there i'm anewbie in visual basic codes so i need ur help guys. what i want to do is use append and update query on certain tables. What are the VBA codes for this? I know how to do this in design view but i need it in codes because what i'm going to do is an automation that will compare two tables. With a single hit of a button the code will do the query alone. Got me?

So please i need help on what codes should i use what are their syntax..i have absolutely no idea.

Thanksss.

 

[Paul_B]

after you've created the tables in design view this is the vba:
DoCmd.OpenQuery "your_query_name"


or the faster way is to run everything in vba:
DoCmd.RunSQL ("your_sql_code_goes_here")


Paul.

 

[Rich]

after you've created the tables in design view this is the vba:
DoCmd.OpenQuery "your_query_name"


or the faster way is to run everything in vba:
DoCmd.RunSQL ("your_sql_code_goes_here")


Paul.

DoCmd.RunSQL is not the faster way