Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    2

    Unanswered: Setting up an access macro - Urgent

    Hello experts,
    Can you please help!
    I have set up an access database macro that will export user's database from his desk top to a text file.
    I have followed the help menu in setting up this macro.

    Here is what I did!
    went to access db, opened an existing database, Macros > New
    action > TransferText
    transfer Type > Export Delimited
    Specification Name > Left Blank
    Table Name > MyNewDBTable --Name where data is being exported to
    File Name > C:\Table.txt
    Has Field Names > Yes
    HTML Table Name > Left blank
    Code Page > Left Blank

    Saved this macro.

    Then I went to control panel > administrative Tools > Services > Task Scheduler to ensure it is started.
    Went to Accessories > System Tools > Add Scheduled Tasks > Added a task to run this macro ever day at 12:00 am.

    Finally, went to command line and started the macro with this:

    START C:\"Program Files"\"Microsoft Office"\Office\Msaccess.exe C:\calendar.mdb /excl /x Table

    So far, any time I look at the task I scheduled, it indicates the last time task was run. Status of the task just keeps saying "Running"
    I go to C:\Table.txt but I don't see any data in it.
    Can someone please tell me if there is something wrong with the steps I indicated above?
    The only thing I am not sure if I am doing right is the command line commands that I had to run to start the task.
    I don't know if everything looks ok.
    I didn't get any errors but nothing seems to be working.
    Thanks in advance for your assistance.
    Last edited by simflex; 09-25-03 at 12:09.

  2. #2
    Join Date
    Sep 2003
    Posts
    19

    Re: Setting up an access macro - Urgent

    1st - when you manually run the macro from your db, does it work?
    2nd - The easiest was to schedule this would be to
    1 - create a form in access
    2- have the on open event of the form launch the macro & then close the form
    3 - in tools >> startup set the form to open when the db opens
    4 - set the windows scheduler to run your db (no switches needed)

    Originally posted by simflex
    Hello experts,
    Can you please help!
    I have set up an access database macro that will export user's database from his desk top to a text file.
    I have followed the help menu in setting up this macro.

    Here is what I did!
    went to access db, opened an existing database, Macros > New
    action > TransferText
    transfer Type > Export Delimited
    Specification Name > Left Blank
    Table Name > MyNewDBTable --Name where data is being exported to
    File Name > C:\Table.txt
    Has Field Names > Yes
    HTML Table Name > Left blank
    Code Page > Left Blank

    Saved this macro.

    Then I went to control panel > administrative Tools > Services > Task Scheduler to ensure it is started.
    Went to Accessories > System Tools > Add Scheduled Tasks > Added a task to run this macro ever day at 12:00 am.

    Finally, went to command line and started the macro with this:

    START C:\"Program Files"\"Microsoft Office"\Office\Msaccess.exe C:\calendar.mdb /excl /x Table

    So far, any time I look at the task I scheduled, it indicates the last time task was run. Status of the task just keeps saying "Running"
    I go to C:\Table.txt but I don't see any data in it.
    Can someone please tell me if there is something wrong with the steps I indicated above?
    The only thing I am not sure if I am doing right is the command line commands that I had to run to start the task.
    I don't know if everything looks ok.
    I didn't get any errors but nothing seems to be working.
    Thanks in advance for your assistance.

  3. #3
    Join Date
    Oct 2003
    Posts
    16

    another option

    If you change the name of your macro to AUTOEXEC it will automatically execute whenever that MDB is opened.

Posting Permissions

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