Results 1 to 2 of 2
  1. #1
    Mahendra1000 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2013
    Posts
    101

    Opening a File

    Hello,

    I have created a form in MS Access. I have added a button name "HELP" to that form. Now I wanted to connect a file which is located on the server to the HELP button.

    If a user clicks on the HELP button then the file needs to be opened.

    I have set the hyperlink address of the file with the HELP Button . when I click on the HELP button nothing is opening in form view.



    Can anyone guide me how to do this.

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    There are a few ways to do this. With a control button you can turn it into a hyperlink by adjusting the HyperlinkAddress property. If the address does not ever change you could just type it into the property sheet.

    You can adjust the HyperlinkAddress using VBA
    Me.ControlName.HyperlinkAddress = "C:\Test\FileName.pdf"

    You can also leave the HyperlinkAddress property blank and use the following in a click event.
    Application.FollowHyperlink "C:\Test\FileName.pdf"

    There is another aproach that I am not remmbering right now that shells out the command to oprn the file by launching the application of the file type first.

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

Similar Threads

  1. Opening an existing xls file.
    By Jrw76 in forum Programming
    Replies: 1
    Last Post: 01-15-2014, 02:01 PM
  2. Trouble opening Access file
    By nicknameoscar in forum Access
    Replies: 5
    Last Post: 08-08-2011, 12:32 PM
  3. opening an excell file from out of access
    By FSCHAMP in forum Access
    Replies: 1
    Last Post: 01-05-2011, 10:17 AM
  4. problem opening .mdb file
    By honeybee in forum Access
    Replies: 7
    Last Post: 06-25-2010, 11:33 AM
  5. Value List with opening a file.
    By seaper in forum Forms
    Replies: 0
    Last Post: 10-21-2009, 01:32 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
  •  
Other Forums: Microsoft Office Forums