Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    May 2001
    Location
    MIA (takittodahous), Florida, USA
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Scheduled Output (Access2002 or 2000)

    Good Morning!

    I would like to generate a delimited file from a query automatically at a scheduled time. The file would need to append the data from two like formatted queries.

    Are there schedule functions in Access? Can you recommend any script scheduling programs? Any and all help MUCH appreciated.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Scheduled Output (Access2002 or 2000)

    Access doesn't have specific scheduling built in, but you can use the Timer event of a form for this. The database and the form would have to be open all the time. If that isn't convenient, you'll have to use an external scheduler that opens the database.

  3. #3
    Star Lounger
    Join Date
    May 2001
    Location
    MIA (takittodahous), Florida, USA
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Scheduled Output (Access2002 or 2000)

    Thanks Hans!

    Any advice on appending the data to an existing .txt file?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Scheduled Output (Access2002 or 2000)

    I don't think that the regular export options from Access (DoCmd.OutputTo and DoCmd.TransferText) allow appending to an existing file, so you'd have to export to a new file, then append that to an existing file outside Access; you could use a good old batch file for that.

  5. #5
    Star Lounger
    Join Date
    May 2001
    Location
    MIA (takittodahous), Florida, USA
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Scheduled Output (Access2002 or 2000)

    Thanks Loads, Hans - you've been of great assistance

Posting Permissions

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