Results 1 to 3 of 3

Access 2010 and form hyperlink

  1. #1
    grapin is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    5

    Question Access 2010 and form hyperlink

    I am using Access 2010. The table (PCRR) contains a field with the datatype of "hyperlink."

    Now, on the form that is based on the PCRR table, I need to allow the user to browse a particular directory and pull back the filename that they want and place the full pathname/filename in the hyperlink field.

    How do I go about setting the default location of the hyperlink to a direct pathname (not using mapped drives and/or search drives).? Again, the user will click on the hyperlink field on the form and the "edit hyperlink" will open to the direct pathname/folders.

    The final step is that the user will execule a report and export out to a pdf the report, which will contain the hyperlink in it. This pdf report can then be sent to other people for the information, plus be able to open the hyperlink to the selected file above.

    Can anyone help me with how I go about doing this?

    Thanks in advance for your help! I have been researching this all day.

  2. #2
    June7's Avatar
    June7 is online now Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    29,850
    Google: access vba add hyperlink default

    Review this http://bytes.com/topic/access/answer...default-folder
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  3. #3
    grapin is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    5

    Access 2010 and form hyperlink

    Quote Originally Posted by June7 View Post
    Google: access vba add hyperlink default

    Review this http://bytes.com/topic/access/answer...default-folder
    Thank you so much! This link really helped!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 02-18-2012, 05:20 AM
  2. Replies: 1
    Last Post: 01-05-2012, 12:34 PM
  3. Replies: 9
    Last Post: 08-07-2011, 10:21 AM
  4. Replies: 2
    Last Post: 05-11-2011, 08:06 AM
  5. Replies: 5
    Last Post: 03-11-2011, 08:29 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums