Using FLAG

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
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
 
Back
Top