Events Available upon opening a database

[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

 

[Rick Brandt]

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.

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.

 

[ray]

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

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

 

[Rick Brandt]

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

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.

 

[Tim Ferguson]

However, I'm trying to stay
away from base Access functionality like AutoExec.

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