Can I create a button to run a series of queries? No pun intended :)

[rebfein]

For all of you who have supplied answers to my posts, I send out my heartfelt gratitude for all the help I've received on this project. Bless you all. Now one more issue...




I've created a home page where I've put all the forms and reports that I've created for this database for those who are going to use it (everything in one place). I'm attaching a screen shot of the form view. I would like to add a Nav button to the first row that says "Queries," then list the four queries in the secondary Nav bar.



My boss liked it, and I'm wondering if:

1. Could I, and how would I, create a 'Run' button that would run each of the queries (when they update the database [a few times a year}) to update/refresh them?

In the home stretch and again a big Thank you everyone,

Rebecca

[June7]

What are these queries to be run - UPDATE, INSERT, DELETE?

Code can run query objects or SQL statements.

[rebfein]

One is a delete query, another is an append query, and two are really sorting queries.

[June7]

"Sorting" queries do not have to be 'run'.

[rebfein]

Ok, what about the other two?

[June7]

I use only VBA, no macros. I prefer CurrentDb.Execute method.

CurrentDb.Execute "SQL statement here"

Example:

CurrentDb.Execute "DELETE FROM tablename WHERE some criteria here"

[rebfein]

June7,Thank you for your response, but that is a bit too much programming for me at the moment. Since I'm a newbie with Access, I don't want to inadvertently create something that may explode as I did in 7th grade chem class.Rebecca

[June7]

Alternatively, can set up saved query objects and run them from code - VBA or macro.

[rebfein]

Please tell me how to do that. :|

[June7]

Use the query designer to build query object.

In VBA the code would be:

DoCmd.OpenQuery "query name here"

There is macro equivalent but I don't use macros.

[rebfein]

I'll try it.

Thank you,

Rebecca

[rebfein]

June7,

Sorry for the delay in getting back to you; got involved in another short project.

I tried your suggestion and it didn't work. What's next?

[June7]

What does "didn't work" mean - error message, wrong results, nothing happens? What exactly did you do? Need something to analyse - provide code or database.

[rebfein]

I would love to provide an answer, but I'm involved in another part of the project at the moment. I'll try to get back to it early next week and get you more information.

Thank you,

Rebecca