Run a Macro After A FormOpens

R

Ron A.

Hello,

I am new to macros and need assistance in running a macro after a form opens.
I currently have a msgbox warning that opens when Access is opened. I would
like to have it run after Access opens with the form I have selected in the
database properties.

The reason for this is because our software has been modified to disable the
macro security options. When I use an AutoExec for the message box, you have
to close it twice... once when access opens and then again after you select
to allow macros.
 
S

Steve Schapel

Ron,

You can put the macro on the On Open event property of the form. Change the
name from AutoExec to something else.

What version of Access are you using?
 
R

Ron A.

2007
--
Aloha,
Ron A.


Steve Schapel said:
Ron,

You can put the macro on the On Open event property of the form. Change the
name from AutoExec to something else.

What version of Access are you using?
Click to expand...
 
R

Ron A.

I believe what is happening, is that the form is opening initally and Access
blocks all macros while waiting for user input to accept. Once selection has
been made the form is closed and reopened with macros enabled. Because the
form is opened twice the macro is ran twice. Any suggestions around this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call a macro from commandline with existing autoexec 1
macros with a macro 1
Run macro on startup only if it has not been run previously today 1
Can't Run Macro 2
hiding queries behind a macro 2
Compact & Repair, Open table, close table, then run macro 3
MsgBox - autoexec macro 4
Access Command to run access, open to specific form and specific record 1

Top