Events Available upon opening a database

  • Thread starter Thread starter ray
  • Start date Start date
R

ray

Hello All,

Aside from the startup function, what events exist when a
database is opened. I'd like check for the existance of
some linked data and add some links when the database is
opened. A sequence fo events would help tremedously.

Please advise.


Ray
 
ray said:
Hello All,

Aside from the startup function, what events exist when a
database is opened. I'd like check for the existance of
some linked data and add some links when the database is
opened. A sequence fo events would help tremedously.
Click to expand...

You can create a macro named "AutoExec" and it will automatically run when you open
the file or you can use Open and Load event code in whatever form you designate to
open in Startup. That's pretty much it. Of course either of those can spawn as many
functions, macros, and routines that you care to run.
 
Thanks for the reply Rick. However, I'm trying to stay
away from base Access functionality like AutoExec. I'd
like to right some flexible code that does the same thing.

Thanks,
Ray
-----Original Message-----


You can create a macro named "AutoExec" and it will
Click to expand...
automatically run when you open
the file or you can use Open and Load event code in whatever form you designate to
open in Startup. That's pretty much it. Of course
Click to expand...
either of those can spawn as many
 
ray said:
Thanks for the reply Rick. However, I'm trying to stay
away from base Access functionality like AutoExec. I'd
like to right some flexible code that does the same thing.

Thanks,
Ray
Click to expand...

You can write any kind of code you want, but you need an event to get it started
running. I've listed the only events I know of that automatically run solely because
you opened an Access file.
 
However, I'm trying to stay
away from base Access functionality like AutoExec.
Click to expand...

There are things I don't like about Access, but I wouldn't go so far as to
call it base... And it's a bit odd to use Access without wanting to use
Access functionality. What about VB or Excel then?

The only method that has not been suggested so far is starting the
application with the /x "MyMacro" switch -- check help for "command line".

HTH


Tim F
 
Back
Top