?
Solved

Batch File running Access Macro/function

Posted on 2006-05-01
2
Medium Priority
?
3,099 Views
Last Modified: 2008-02-01
Hi all--

I have a batch file I'd like to schedule that runs a macro in an access application.  The macro in turn calls a function which exports some task information from the local instance of outlook.  My .bat is pretty simple:

"C:\Program Files\Microsoft Office\Office11\msaccess" "C:\SP\SPlans.mdb" /x TaskImpy


It seems to work just fine...appropriate records are written to the access table.  However, the cmd window remains open.  Am I missing something?  I'd like to figure out how to close the access app via the batch file as well, but I can seem to get to that step...


0
Comment
Question by:rz1224
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 16581189
Hi rz1224,
You put a Quit action as the last step in the macro.

Pete
0
 

Author Comment

by:rz1224
ID: 16581286
Pete--

DOh!  Thanks for  your help.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question