Help Hyperlinking in VBA

[Huey462]

I have a database that is going to be used by different shops, and because we do not all have access to the same drives, they need to be able to define the locations of their files.

The file path and names are saved in two fields in the “Export Information” table
“RDO Template” is the first and “Custodian Log” is the second

I’ve searched the internet and found several examples using the “Application.FollowHyperlink. . . .” code, and I think this will work perfectly for what I need. The problem is…I don’t know how to get the value from the table to VBA.

Again, thanks in advance.
-Huey

 

[Huey462]

After some mucking around (and a bit of Divine intervention I'm sure) I figured the following out, and it works.

My question now is, how can I change this to have the path and file name in two seperate fields?

' Defines variables
    Dim QLink As String
    QLink = DLookup("[Custodian Log]", "[Export Information]")
' Opens the file using the user-defined location and file name
    Application.FollowHyperlink QLink