Autoexec Problem

[Scientific]

Hello all,

I'm trying to get a macro to autorun after a user logs into the database but
I noticed that the Startup properties (Display Form/Page) is set to open a
form. I tried setting (Display Form/Page) to none, then set the first macro
action to "RunMacro" and the "Macro Name" to the name of the macro I want to
run after the user logs in. So far, no dice.

Anyone is welcome to jump in with your two cents about this one. What am I
missing here.

-S

 

[John W. Vinson]

Hello all,

I'm trying to get a macro to autorun after a user logs into the database but
I noticed that the Startup properties (Display Form/Page) is set to open a
form. I tried setting (Display Form/Page) to none, then set the first macro
action to "RunMacro" and the "Macro Name" to the name of the macro I want to
run after the user logs in. So far, no dice.

Anyone is welcome to jump in with your two cents about this one. What am I
missing here.

-S

Either just name your macro Autoexec (if there is a macro of that name in your
database it will be executed upon open), or set the startup form's Load event
to the name of your macro.

 

[Scientific]

John,

You are an Access genius. I renamed the macro to autoexec and everything
works perfectly. I bow to you sir Thank you so much John!

-S