Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2005
    Posts
    313

    Unanswered: Get Path (Directory)

    Hi,

    In MS Access,

    DoCmd.OutputTo acOutputReport, "Appr", acFormatRTF, "P:\Appr.rtf", False

    I want output the file in the current directory,
    the above code is specific the path,
    how can I edit the current path, so whereever the the database is either drive, they still can work.

    The concept is like that
    DoCmd.OutputTo acOutputReport, "Appr", acFormatRTF, currentdirectory:\"Appr.rtg", False

    Please let me know, thanks.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Application.Currentproject.Path
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    Or if you are using Access 97, then you will have to extract it from the full path and filename that is returned by Application.Name.

Posting Permissions

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