1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Access 2000 output report

Discussion in 'Business Applications' started by Darren C, Sep 10, 2003.

Thread Status:
Not open for further replies.
  1. Darren C

    Darren C Thread Starter

    Joined:
    Aug 22, 2003
    Messages:
    4
    Please Help

    I am trying to send the snapshot report to a folder, by running a macro. using the "Output To" argument.

    When I send this report, the file name is always the same
    (ECI Query) which is the report name.

    Is there a way I can get access to name the report ECI 701, ECI 702, etc. as it puts the file into the folder.

    As the current situation I have 20 reports all called "ECI Query", so I have to open each one to find which one I want.

    Cheers
    Darren
    :confused:
     
  2. downwitchyobadself

    downwitchyobadself

    Joined:
    Oct 13, 2000
    Messages:
    941
    What are you basing the 701, 702, etc. on? There's one of two possible solutions: either that name comes from some element in the data itself--in which case you could concatenate it into the output name--or you should consider another system, such as the date/time at which the output is done.

    Also, it would be helpful if you posted the exact arguments you're using in OutputTo, and where they come from, if relevant.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/163658

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice