Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Location
    pompano beach, FL
    Posts
    8

    Red face Unanswered: How can I automate Macros and Queries??

    I need to have a macro and four queries automated by including them in a .bat file. Can anyone help me with this? Any help would be greatly appreciated. Thanks.

  2. #2
    Join Date
    Jun 2002
    Location
    Mpls/St.Paul area
    Posts
    303
    Would it work to have your bat file open access and open the database also? When the database opens, you can select a macro to run which could run the queries.

    Try this: Open database from batch file like the following.

    c:
    cd\Program Files\Microsoft Office\Office\
    msaccess.exe \\myFolder\mySubFolder\myDB.mdb /x MyMacro
    John
    This is the day the Lord has made, I will rejoice and be glad in it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •