make table query - run when DB is open

[amigos]

hi there,
I have procedure that runs make-table query, so my table is always updated.

I got two questions:
- how can I run this procedure always when I open Access DB?
- how can I swith off (using VBA) option:
Tools/Options/Edit.Find/Confirm:Action Queries so when I run this procedure I dont see alert?

Thanks

Amigos

 

[Tanis]

In your AutoExec macro set an action OpenQuery. To turn off the warnings just set SetWarnings to False before the query is called and set SetWarnings to True after the query has been run.

 

[amigos]

Thanks Tanis,

it works fine

is there any way to do that (AutoExec thing) by code?


Amigos