Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    settings for CreateTextFile (Acc2k, Win2KPro)

    Is there a way to set this to output files to the directory of the Access mdb?

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: settings for CreateTextFile (Acc2k, Win2KPro)

    Hi Steve

    In code you can use CurrentProjectPath. So if exporting a snapshot report it would look similar to below:



    DoCmd.OutputTo acReport, stDocName, "SnapshotFormat(*.snp)", CurrentProject.Path & "" & "StevesAnnualReport" & ".snp", True


    HTH
    Jerry

Posting Permissions

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