I'm not following. Can you please elaborate? Maybe post a screen shot?

Try this Shell Command otherwise there is a more elaborate seminar HERE

Sorry.  Hope this helps.  I have 40 records in my database.  Each one has a .pdf associated with it.  I would like the Button to open that specific .pdf

You would need to use the ShellEx function. It's a little more involved. I cover it in the Seminar that Adam suggested.

I DID use the ShellExec Functions as you covered in the Opening Other Programs Lesson 3.  I even used your sample database and it too opens to C:\Attachments as in the screenshot above.

Attachment is the name of the field

If Right(Attachment, 4) = ".PDF" Then
        Shell """C:\Program Files (x86)\Adobe\Acrobat DC\Acrobat\Acrobat.exe"" """ & Attachment & """", vbNormalFocus
End If

I am getting very confused.  In the example above from Lesson 3, clicking on "Browse Attachments Folder" is NOT meant to open the Attachments, only direct you to the folder for browsing.

Are you saying that the code you included above will open specific files within the Attachment Folder E.g. C:\Attachments\bellevue.pdf)?  If so,  how do I declare ShellExec? AND use the VBA code?

You see that field C:\Attachments... on that picture? If that field name is called Attachment you can use the code I listed to open it. It needs to be the full network address c:\attachments\filename.pdf

Carol
I think you are suffering from information overload.
In Lesson 1 Richard uses Shell to start us out with using other programs.
Then in lesson 3 he switches over to the ShellExec which uses the Windows handler (shell32.dll).
Both do basically the same thing.  They open the file using another program.
I think you're trying to mash the two together.

So... For Shell YOU tell Access what program to use to open the file.  
ShellExec you let Windows decide which program to use based on the file extension.

In Lesson 2 Richard shows how to open each individual file based on extension
using the On Dbl Click.
To use that feature using the ShellExec you would just substitute the correct code to open that particular file.

If you want to select the file and then click a button to open that file refer back to
Beginner Level 7 - Lesson 5 where Richard shows how to select a Customer from a list then open that customer
in a form using the Open Selected Customer button.

Instead of opening a customer you would be passing the file name to the ShellExec.

A little different but same concept.

Carol, you are correct. The BROWSE Attachments Folder is meant for you to BROWSE the folder to select a file.

If you want to OPEN that file to view it, use ShellExec. Exactly HOW to use it is all explained in the videos.

I have FINALLY been successful in opening my two attachments (Instruction Sheet and Video) using the ShellExec Function!!
Using a Subform allows me open both attachments specific to each record.  Using a Command Button however, only allows me to open the SAME Instruction Sheet and the SAME video for EVERY record.

Is there a way to open these attachments specific to the record using a Command Button?  Please see the screen shots that show how I have declared ShellExec.

Yep. Put your buttons in the form footer of your subform. Then all you would need is:

ShellExec LocationFieldName

Then all you have to do is click on the record and then click the button.

Working with subforms starts in my Access Expert 3 class.

Thank you for your video on hyperlinks.

I was successful with email and filelocation.  However, I received an error message for the webBtn.  Please see screen shot.  My computer WAS connected to the internet.

Is this something that is covered in the extended cut for this video?

That's odd. Let's see what's in Web. MsgBox it.

If you MsgBox "http://" & Web what shows?

see screenshots.  I am not sure I did the msgbox correctly.

What's the NAME of the "webpage address" text box?

webpage

There's your answer. :)

errr . . . . . I do understand

sorry  I DON'T understand

If the NAME of the text box is "webpage" then that's the name you have to put in your code.

Application.FollowHyperlink "http://" & WebPage

You don't have any field on your form called Web, but that's what you have in the code. They have to match.

Either change the code to WebPage OR change the name of the box to Web. Get it now?

Thank you soooooo much.  I didn't understand that before.