open db and run code automatically

  • Thread starter Thread starter Steven Revell
  • Start date Start date
S

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
 
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
 
Back
Top