open db and run code automatically

[Steven Revell]

Hi all,

how do i automatically open a database in access 97 and
execute a sub routine stored in a module?

e.g. in a short cut open the c:\test1.mdb -m update

Thanks in advance for any help,

Steven

 

[Howard Brody]

Any macro named AutoExec will run when the database opens.

Put the subroutine you want to run in a public function (I
usually name it StartUp() or Main()) and then use the
RunCode action in your AutoExec macro to run it.

Hope this helps!

Howard Brody