Run Code or Macro when DB is open

  • Thread starter Thread starter Gary Hull
  • Start date Start date
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.
 
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.
Click to expand...

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