Macro for running several queries one after another

[SebastianColombia]

Hello to you all!!: Thanks for taking some time to read this.

I've created a user form with a button and I want a macro to run my queries in a particular order (one after another), I don't want the macro to open them, but to run them.

I'm using this code, but it opens the queries instead.

Private Sub Comando0_Click()


DoCmd.OpenQuery ("my_qry")


End Sub



I also made a video about what I'm trying to achieve. Please help me

https://www.youtube.com/watch?v=OPNI...ature=youtu.be

[JoeM]

I can't watch your video from my present location.

Are your queries SELECT queries or ACTION queries (Add, Update, Delete)?
If you use that OpenQuery command on Action query, it will run them without opening them.
If they are Select queries, what is the point in opening them? Select queries just return data to the screen. They do not change anything (and they do not need to be opened to be "refreshed" or anything like that).

[SebastianColombia]

Thanks for answering JoeM.

All of them are SELECT queries. I need to refresh them in order to create several tables that I'm going to export.

I have a question: When you say that they don't need to be opened in order to refresh them, then, how could I refresh them automatically??

Thanks for your help!

[JoeM]

All of them are SELECT queries. I need to refresh them in order to create several tables that I'm going to export.

You actually don't. Opening a SELECT query does not refresh anything. All it does is return the data to the screen.
Select queries are "real-time" whenever they are called, and they don't need to be called directly.
So, if you running a report or form based on a query, exporting the query, or using the query in other action queries, the data will be current as of the time you execute the command. There is no need to open the underlying Select query first.

Try it for yourself, you will see!

[SebastianColombia]

Thanks a lot for your help!!! As you can see I'm new with Access!!! Thanks a lot sir!!!

[JoeM]

You are welcome. Glad to help!