Open up a PDF document - Big Button Form in Microsoft Access, Part 6


	Back to Big Button Form 6 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Open up a PDF document

Robert Carpenter

2 years ago

I want to start by saying I enjoyed this Big Button Series! I am writing a database to be able to open a pdf version of a service manual. Basically, once I select the type, year, make, and model of the vehicle, I want to be able to open the Service Manual, full screen, of that specific vehicle that I searched for by using a button. How do I do this in my database?

	Alex Hedley @Reply 2 years ago
Access Open Programs Seminar

Robert Melcher @Reply

2 years ago

I think that the last page would be a button for that vehicles manual. That button would be VBA code to open that specific PDF. Following the flow, click the make, then model, then year, then manual would be the last page. That button opens up that specific manual something like this:
Private Sub btnOpenPDF_Click()
    Dim strFilePath As String
    strFilePath = "C:\Path\To\Your\PDF\File.pdf" ' Change this to the path of your PDF file
    Application.FollowHyperlink strFilePath
End Sub
I hope this helps.

	Robert Carpenter OP @Reply 2 years ago
Thank you Alex and Robert! I ended up using the Application.FollowHyperlink code using a command button and got it working this morning. I may go back and put this full code in the form. I appreciate the help!

	Alex Hedley @Reply 2 years ago
Follow Hyperlink

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Big Button Form 6.

Next Unseen

New Feature: Comment Live View