Run Code or Macro when DB is open

A

Arvin Meyer [MVP]

Use an AutoExec macro or a startup form. If you use a shortcut to start a
specific Access database, you can also use the /x switch to start a macro,
or the /cmd switch to run a command. I am not sure these last 2 options are
still available in Access 2007 since I haven't used them at all in 10 years.
 
A

Arvin Meyer [MVP]

Gary Hull said:
I am using the code by Dev Ashish to make sure my link my backend DB to my
front end DB. should I run this code when I open the front end DB?
If so what is the best approch
Click to expand...

Check if it needs to be refreshed first. If so use an autoexec:

Action: RunCode
Argument: the function's name

or just run it as a startup form in the database.
 
Top