Run function at start-up...macro?

  • Thread starter Thread starter Vsn
  • Start date Start date
V

Vsn

Hi all,

I can not find the best solution for the following:

I have a function CheckConnection() which should check if the backend data
is still there/connected. I want this function to run as very first action
when the database opens. I thought to put it in the macro autoexec (feels
like old DOS times) and using Openfunction, this keeps asking for a table
etc. I would just like to find a method to run a user-defined function
direct as Access starts. I am not familiar with macros since I never use
them because I feel more covetable with VBA.

Any suggestions will be appreciated a lot.

Thx,
Ludovic
 
Use RunCode in the AutoExec macro.

Alternatively use the Open event of an *unbound* form to run this code, and
then load the form you really want. Nominate it as your startup form: Tools
| Startup.
 
Allen, once again thanks for your excellent help, easy to do once you get
the right advice.

Ludovic
 
Back
Top