Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Execute a "function" at a particular time

Status
Not open for further replies.
JesseH

JesseH

MIS
Aug 9, 2001
63
0
0
US
I need to execute a function only if it is a particular hour of the day, i.e., I need to excute a function only between the hours of 14 and 15 (2 to 3 pm).

Does anybody have any ideas. I have messed around with the time varible but I can not make it work.
 
Sort by date Sort by votes
Does this need to be run every day? If so, try taking a copy of the database, set up a form which runs this function from it and set the operating system scheduler to run it at 14:00.
Be sure that it quits afterwards though.

John
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Access prompts "open or save" when I preview an excel file 1
Replies
1
Views
67
combo
combo
IrishJim
  • Locked
  • Question
How do I capture the "digital signature", for display in my Form header?
Replies
0
Views
61
IrishJim
IrishJim
Aurillius
  • Locked
  • Question
Convert Date/Time cell to a date and time in VBA
Replies
2
Views
176
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
181
Andrzejek
Andrzejek
aldi07
  • Locked
  • Question
update a front-end database with a new release using vba
Replies
5
Views
99
aldi07
aldi07

Part and Inventory Search

Sponsor

Back
Top