By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,615 Members | 1,961 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,615 IT Pros & Developers. It's quick & easy.

Using Auto Ex to Run Queries

P: 2
Hi,

I am new to the board so please bear with me. What I want to do is to set up queries in a database I have (there are 4 make table queries) and then after they are finished, run a report I have created and then email it to individuals. Is this possible and if so how do you go about doing that? If I had to split it up one section at a time that would be fine also. Your response is more than appreciated. Thanks
Oct 27 '06 #1
Share this Question
Share on Google+
3 Replies


PEB
Expert 100+
P: 1,418
PEB
You nearly know the answer!

It's just the autoexec Macro!

Create a macro name it Autoexec and set up there what you want!

So when you enter in the database this macro will be executed!

:)
Oct 27 '06 #2

7 of 9
P: 23
You nearly know the answer!

It's just the autoexec Macro!

Create a macro name it Autoexec and set up there what you want!

So when you enter in the database this macro will be executed!

:)
how do you prvent the window from comming up that askes the user to OK the make table query when using and autoexec?
Jul 9 '07 #3

JKing
Expert 100+
P: 1,206
Try this:
Expand|Select|Wrap|Line Numbers
  1. Docmd.SetWarnings False
  2.  
Be sure to turn the warnings back on once you've run your action query. Changing this setting supresses warning messages for the entire database and this could result in unwanted changes if you fail to turn the warnings back on after completing your desired actions.
Jul 9 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.