Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2006

    Unanswered: Help with, Modifying Output Directory/ Path in Access

    Hello All,
    I am new to vb and just trying to build a database for work. The db works ok however I am trying to modify the output location since its on a network.

    The current db report output locations is...
    "C:\Documents and Settings\a124567z\Desktop\ContactInfo.rtf"
    with "a124567z" being the user's login or network ID.

    Is there a way I can use vb to make the db report output location to automatically change according to the login id without doing it manually on all the computers?

    For example if user "b444555y"
    tries to export the data, the location shoyuld now be...
    "C:\Documents and Settings\b444555y\Desktop\ContactInfo.rtf".

    I hope I explained myself well.
    Thank you in advance

  2. #2
    Join Date
    Feb 2006
    I see no one has replied yet.

    In case this helps, can you do an API call for the user name and then incorporate it in making the path name? Code for the API call should be easily found.

    This is virtually trivial in VBA - I'm familiar with Excel for VBA. I'm reading this VB section to learn a little, but I've never done any VB so can't help any more.


  3. #3
    Join Date
    Jun 2004
    Arizona, USA
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert

Posting Permissions

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