By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,574 Members | 3,021 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,574 IT Pros & Developers. It's quick & easy.

setting up a certain date in database to run the queries while db is closed

P: 13
Is there a function that I could greate in a module that would run specific queries at specific days of the month while the computer is shut down for the night? Some queries need to be ran on the first of the month and some on the second day of the month. Is this possible?
Dec 19 '11 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 15k+
P: 31,494
Yes, but you need to be far clearer about what it is you're looking for.

Clearly, Access can't run anything when it's not running, and no computer can run anything when it's shut down. So what exactly are you asking about?
Dec 19 '11 #2

P: 13
I apologize. Sometimes I speak as if I was already in a conversation or ask question informally. I do have the alarm clock already created in my module (I dont have the copy with me it is at work). The alarm clock which triggers other macros to run within excel has not been very effective. It works great but not that great. What is happening is that the alarm is set up as military time. In that sense, if I set up the Alarm Clock to run at 6 AM, I put 6:00 in the form. However, when I leave work for the day the Macro has been fired at 6 PM not at 6 AM. But it shouldnt have functioned like that because it was suppose to perform as military time 18:00 instead of 6:00. And yes you are correct, the DB needs to be running.
Dec 20 '11 #3

Expert Mod 15k+
P: 31,494
It seems like you already have the concept sorted, if a little bit off with the code. Show us the code and we'll see if we can help with getting it to recognise the correct 6 O'Clock for you.

With a running database it is possible for the trigger to be determined depending on almost any aspect of the date or time, so it can certainly be made to recognise the first or second days of the month.
Dec 21 '11 #4

Post your reply

Sign in to post your reply or Sign up for a free account.