G
Guest
Without opening the database and running the macro manually, how would I set
a task to open the database and run the macro automatically?
a task to open the database and run the macro automatically?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jeff O via AccessMonster.com
Rob, We do this quite a bit for database task that we have on a seperate
server that does nothing but log into our database and perform different
tasks. we simply build do the following:
1. Build the macro
2. Build a batch file and cal FULL path to database and pass the macro name
using the "X" arg.:
e.g
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" d:\stars\stars.mdb
/wrkgrp "d:\stars\security.mdw" /user batch /x check_consistency_email
It works GREAT!
/Jeff
server that does nothing but log into our database and perform different
tasks. we simply build do the following:
1. Build the macro
2. Build a batch file and cal FULL path to database and pass the macro name
using the "X" arg.:
e.g
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" d:\stars\stars.mdb
/wrkgrp "d:\stars\security.mdw" /user batch /x check_consistency_email
It works GREAT!
/Jeff
G
Guest
So a standard batch file will work? If this works, it'll be awesome...
G
Guest
Hey Jeff,
That works great!!! Thanks....
Now, How can I tell that batch file to close MS Access?
That works great!!! Thanks....
Now, How can I tell that batch file to close MS Access?
J
Jeff O via AccessMonster.com
Rob, Glad you found it works for you. To close MS access AFTER your macro
has completed it's work, simply put a "quit" as the last thing the macro does.
Change the "options" for the quit to (saveall) for saveing ALL without
prompting.
/Jeff
has completed it's work, simply put a "quit" as the last thing the macro does.
Change the "options" for the quit to (saveall) for saveing ALL without
prompting.
/Jeff
Hey Jeff,
That works great!!! Thanks....
Now, How can I tell that batch file to close MS Access?
[quoted text clipped - 13 lines]Rob, We do this quite a bit for database task that we have on a seperate
server that does nothing but log into our database and perform different
G
Guest
Thanks a lot Jeff..... Awesome help....
When Q&A was big, I was pretty good at it but access is another story.....
THX
When Q&A was big, I was pretty good at it but access is another story.....
THX
Jeff O via AccessMonster.com said:Rob, Glad you found it works for you. To close MS access AFTER your macro
has completed it's work, simply put a "quit" as the last thing the macro does.
Change the "options" for the quit to (saveall) for saveing ALL without
prompting.
/Jeff
Hey Jeff,
That works great!!! Thanks....
Now, How can I tell that batch file to close MS Access?
[quoted text clipped - 13 lines]Rob, We do this quite a bit for database task that we have on a seperate
server that does nothing but log into our database and perform differentWithout opening the database and running the macro manually, how would I set
a task to open the database and run the macro automatically?
J
Jeff O via AccessMonster.com
You very welcome Rob...Anytime...
/Jeff
/Jeff
Thanks a lot Jeff..... Awesome help....
When Q&A was big, I was pretty good at it but access is another story.....
THX
[quoted text clipped - 14 lines]Rob, Glad you found it works for you. To close MS access AFTER your macro
has completed it's work, simply put a "quit" as the last thing the macro does.