Is there a relatively easy way to shedule a macro to run at a certain time each day?
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
Macro on a timer (Access 2000)
Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Macro on a timer (Access 2000)
- This topic has 11 replies, 2 voices, and was last updated 19 years, 6 months ago.
Viewing 0 reply threadsAuthorReplies-
WSHansV
AskWoody LoungerOctober 28, 2005 at 1:18 pm #981682You could create a scheduled task in Windows (through the Scheduled Tasks control panel) that executes a command line like this:
“C:Program FilesMicrosoft OfficeOfficeMSAccess.exe” “C:AccessMyDatabase.mdb” /x “MyMacro”
You can set the time and frequency for the scheduled task. The macro could quit Access after performing its actions. This method does not require that the database remain open all the time.
Alternatively, you could create a form with an On Timer event that periodically checks the time, and executes the macro at the appropriate time. You’d have to build in a check to prevent the macro from being run more than once. This method requires that the database remains open all the time, and that the form remains open in the database.
-
WStcarrie
AskWoody LoungerOctober 28, 2005 at 3:27 pm #981719Hans –
You’re helping me with this question about Access and I have another email in my box from you for Outlook.
thank you – thank youI did well with the first part of this but after I got to MSAcess.exe, it moved on and I don’t see where I can type in the second part .
I’m afraid to hit FINISH which make me think that I should probably find out how I cancel a job in the event that I botch up or it’s no longer needed.I used explorer to open up MSAcess.exe to see what that was and it looks like the normal screen that I get when I want to open or create a new database. Do I select it there? Hey-Hey I may be on to something!
If I schedule multiple jobs are they listed somewhere so I can track everything that I have scheduled?
-
WSHansV
AskWoody LoungerOctober 28, 2005 at 3:44 pm #981726You can see already scheduled tasks in the same control panel, and you can edit and delete them there.
You’re on the right track. Tick the check box to see advanced options before clicking Finish. Or click Finish, then right-click the new task in the Scheduled Tasks window and click Properties. You can then change the target of the task to the line I posted.
-
WStcarrie
AskWoody Lounger -
WStcarrie
AskWoody LoungerOctober 31, 2005 at 5:41 pm #982200Hans,
Is that whole command going on the Run line or is it suppose to be broken up between Run and Start with? I’m probably messing up the slashes, quotes, spaces and I’m not really sure what the ‘x’ is but I’ve tried every combination that I can think of. I’m sorry to ask for more assistance but the status for everything is Could not start.Test database saved as:
C drive
Access folder
database: MyDatabase
macro names: MyMacro“C:Program FilesMicrosoft OfficeOfficeMSAccess.exe” “C:AccessMyDatabase.mdb” /x “MyMacro”
-
WSHansV
AskWoody LoungerOctober 31, 2005 at 6:34 pm #982221It should all be in the Run box. The Start In box is not important, you can leave it empty.
I assume that you have substituted the correct path and filename of the database, and the correct name of the macro. The line I posted was just an example.
The /x tells Access to run the macro named after /x when the database is opened.
Have you ticked “Run only if logged in” in the Task tab of the properties of the scheduled task?
-
WStcarrie
AskWoody LoungerOctober 31, 2005 at 6:48 pm #982226I had given my original test database a different name and placed it in a different drive and folder but when it wouldn’t run after numerous tries, I decided to set everything up exactly as you had it in your example so I could copy and past your command on the Run line.
I don’t have this option on my screen: “Run only if logged in”
-
WSHansV
AskWoody Lounger -
WStcarrie
AskWoody Lounger -
WSHansV
AskWoody LoungerOctober 31, 2005 at 7:35 pm #982235 -
WStcarrie
AskWoody Lounger
-
-
-
-
Viewing 0 reply threads -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Xfinity home internet
by
MrJimPhelps
1 hour, 45 minutes ago -
Convert PowerPoint presentation to Impress
by
RetiredGeek
3 hours, 45 minutes ago -
Debian 12.11 released
by
Alex5723
12 hours, 11 minutes ago -
Microsoft: Troubleshoot problems updating Windows
by
Alex5723
15 hours, 53 minutes ago -
Woman Files for Divorce After ChatGPT “Reads” Husband’s Coffee Cup
by
Alex5723
2 hours, 15 minutes ago -
Moving fwd, Win 11 Pro,, which is best? Lenovo refurb
by
Deo
12 hours, 21 minutes ago -
DBOS Advanced Network Analysis
by
Kathy Stevens
1 day, 8 hours ago -
Microsoft Edge Launching Automatically?
by
healeyinpa
23 hours, 13 minutes ago -
Google Chrome to block admin-level browser launches for better security
by
Alex5723
1 day, 11 hours ago -
iPhone SE2 Stolen Device Protection
by
Rick Corbett
1 day, 3 hours ago -
Some advice for managing my wireless internet gateway
by
LHiggins
11 hours, 17 minutes ago -
NO POWER IN KEYBOARD OR MOUSE
by
HE48AEEXX77WEN4Edbtm
4 hours, 8 minutes ago -
A CVE-MITRE-CISA-CNA Extravaganza
by
Nibbled To Death By Ducks
1 day, 20 hours ago -
Sometimes I wonder about these bots
by
Susan Bradley
1 day, 17 hours ago -
Does windows update component store “self heal”?
by
Mike Cross
1 day, 7 hours ago -
Windows 11 Insider Preview build 27858 released to Canary
by
joep517
2 days, 10 hours ago -
Pwn2Own Berlin 2025: Day One Results
by
Alex5723
18 hours, 52 minutes ago -
Windows 10 might repeatedly display the BitLocker recovery screen at startup
by
Susan Bradley
7 hours, 30 minutes ago -
Windows 11 Insider Preview Build 22631.5409 (23H2) released to Release Preview
by
joep517
2 days, 13 hours ago -
Windows 10 Build 19045.5912 (22H2) to Release Preview Channel
by
joep517
2 days, 13 hours ago -
Kevin Beaumont on Microsoft Recall
by
Susan Bradley
2 days, 2 hours ago -
The Surface Laptop Studio 2 is no longer being manufactured
by
Alex5723
2 days, 21 hours ago -
0Patch, where to begin
by
cassel23
2 days, 15 hours ago -
CFPB Quietly Kills Rule to Shield Americans From Data Brokers
by
Alex5723
3 days, 11 hours ago -
89 million Steam account details just got leaked,
by
Alex5723
2 days, 23 hours ago -
KB5058405: Linux – Windows dual boot SBAT bug, resolved with May 2025 update
by
Alex5723
3 days, 19 hours ago -
A Validation (were one needed) of Prudent Patching
by
Nibbled To Death By Ducks
3 days, 10 hours ago -
Master Patch Listing for May 13, 2025
by
Susan Bradley
13 hours, 6 minutes ago -
Installer program can’t read my registry
by
Peobody
5 hours ago -
How to keep Outlook (new) in off position for Windows 11
by
EspressoWillie
3 days, 8 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.