Using FLAG

[Guest]

Thanks in advance.

My access database named as "Mydb.mdb" runs every morning 9 AM.
Windows scheduler is set to open Mydb at 9 AM.

On opening switchboard, it executes
Private Sub Form_Open(Cancel As Integer)

Docmd.RunMacro Mymacro ' My macro is to APPEND DATA everyday

End Sub

Help, please)
Mymacro should run only once a day at 9 AM even though other users open Mydb
several times.

 

[Duane Hookom]

You can specify a Macro name in the command line that opens the MDB using
the scheduler. This would allow you to remove the macro from the open event
of the switchboard.

 

[Guest]

Thanks Duane.
Great help.
Command Line: ......Mydb.Mymacro
Is this OK?

 

[Marshall Barton]

You might be able to make something like that work, but I
think Duane was referring to using the /X MyMacro command
line switch.

C:\pathtoccess\maccess.exe C:\path\Mydb.mdb /X MyMacro