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.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Direction No[/TD]
[TD]Subject[/TD]
[TD]Soft Copy[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MCD-HSS-0001[/TD]
[TD]Backcharge[/TD]
[TD]Click Here[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MCD-ALZ-0002[/TD]
[TD]Backcharge[/TD]
[TD]Click Here[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MCD-RHI-0003[/TD]
[TD]Bakcharge[/TD]
[TD]Click Here[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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