Hi all,

I've spent (wasted) a long time googling this subject to no avail, so I hope that someone can provide me with an answer. I want to execute some VBA code whenever my MS Access 2000 database is launched.

To be more specific, I don't want to put this code in the form-open event of the form that loads at startup. I want this routine to actually be called by Access (sort of like a database-open event). The problem is, I can't find the syntax for it anywhere.

Thanks in advance

You can use an AutoExec macro to run VBA Function procedures at startup.

1. Create a new macro.
2. Name it "AutoExec"
3. Set the AutoExec macro's RunCode action to the name of any public Function procedure you have defined in a VBA standard module (the RunCode action can't call Sub procedures).
4. Close your database and re-open it. The Function procedure code will run at startup.

HTH,

Bob

Exactly what I was looking for. Thanks much!:)