On Click Open Local File - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

On Click Open Local File

David Forney

8 days ago

Sometime back I found a video that showed how to open a word file in a new window with a button on a form. The VBA takes the file name from a text field on the form. I made it work perfectly however somehow, I must have deleted the code and I cannot find the video I used. the following is code I tried
:
Private Sub passengerlistbtn_Click()
FollowHyperlink "passengers"
End Sub

Do I need to do some sort of Dim code?

Dave

	David Forney OP @Reply 8 days ago

	Kevin Robertson @Reply 8 days ago
Follow Hyperlink

	David Forney OP @Reply 7 days ago
Thank you! I still got an error saying it could not find the directory. So I moved the access file to the same directory as the files I wanted to open, and it worked fine. Don’t know if it’s possible to specify a directory for the files I want to open without the accdb file in the same directory.

	Sam Domino @Reply 7 days ago
David If the file is not in the same directory as Access, you'll need to give the "FollowHyperlink" function the full path name. For example, if the file is in your downloads folder.... FollowHyperlink "C:\Downloads\passengers.doc".

	Richard Rost @Reply 7 days ago
And if the files are in a folder under the database folder, you can use: `MyDir = CurrentProject.Path & "\FolderName\" & FieldContainingFilename`

Next Unseen

New Feature: Comment Live View