Using Auto Ex to Run Queries

[austenr]

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

[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!

:)

[7 of 9]

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?

[JKing]

Try this:
[code=vb]
Docmd.SetWarnin gs False
[/code]

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.