Multiple queries on MS Access

[ofilha]

Hi,
I have had the same problem. I can only do one query at a time. If i try more than one after the semicolon, i get an error message just like the one described earlier.

I am using the query tool to create my queries. Your solution appears like VB code. Can we use VB code inside the queries? Or are you saying that i need to create a program to run my queries.

My question is probably rather newbie, but i don't have much experience with MS Access.
Thanks.

[Allan Murphy]

It is VBA code Visual Basic for Access.

No, you cannot run VB code inside a query.

If you are just creating queries and then running them after each other then you can create a module or use code for when you click on a button to run your queries.

Module code
Sub run_queries()
docmd.openquery "query 1 name"
docmd.openquery "qury 2 name"
end sub

Button
sub update_results()
docmd.openquery "query 1 name"
docmd.openquery "qury 2 name"

end sub

I am using the query tool to create my queries. Your solution appears like VB code. Can we use VB code inside the queries? Or are you saying that i need to create a program to run my queries.

My question is probably rather newbie, but i don't have much experience with MS Access.

[Allan Murphy]

Please ignore the last two paragraphs in the previous post.

Copy and paste error.

[ofilha]

Thanks much Allan,
I will give it a try and will keep you posted.