How to Open a Adobe Acrobat Reader DC file in MS Access

[daisyoso]

Hi all,

I have this 1 folder where I put all my pdf files. All these pdf files I named them as MCD-HSS-0001, MCD-ALZ-0002 and so on. All I want to do is to open the soft copy when I click the "CLICK HERE" in the Soft Copy Column. Hope somebody could help me. As of this time, I link all my PDF files one by one which is quite time consuming.

Direction No	Subject	Soft Copy
MCD-HSS-0001	Backcharge	Click Here
MCD-ALZ-0002	Backcharge	Click Here
MCD-RHI-0003	Bakcharge	Click Here

<tbody>
</tbody>

Thank you so much for the help.

 

[Micron]

Not enough info. Is this an Access form? If so, what type? Is click here a button? A label?
If it's a button on a continuous form, you could try the Application.FollowHyperlink method if the row data includes a control with the folder path for the desired file. The button click even would work for the particular record it resides in. Not so for other types of forms.

 

[daisyoso]

Hi Micron.
Thank you for the reply. Its in an access form.

 

[Micron]

3 - 4 questions asked, 1 answered. Your odds are not that great IMHO