imported_unknown
Active Member
- Joined
- Jan 13, 2002
- Messages
- 424
G'day ppl,
Does n e 1 know the correct procedure so as 2 get the TimerEvent 2 trigger every 30 mins or so.
I know I can use the Autosave, but it is limited and doesn't give me the result I need as I have 2 save 2 multiple locations.
I am aware of the OnTime Code to run a sub code at a given time of day, but that isn't enuf, I need it 2 repeat every 30 mins.
Sumthin like this:
Sub()
DoCmd.OnTimer 30000
Application.Run "SaveMyWorkBook"
End Sub.
N E suggestion or comments most welcomed.
TIA
Mark.
Does n e 1 know the correct procedure so as 2 get the TimerEvent 2 trigger every 30 mins or so.
I know I can use the Autosave, but it is limited and doesn't give me the result I need as I have 2 save 2 multiple locations.
I am aware of the OnTime Code to run a sub code at a given time of day, but that isn't enuf, I need it 2 repeat every 30 mins.
Sumthin like this:
Sub()
DoCmd.OnTimer 30000
Application.Run "SaveMyWorkBook"
End Sub.
N E suggestion or comments most welcomed.
TIA
Mark.