• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 325
  • Last Modified:

Access Hyperlink Property

Hi,

In my Access form, I use hyperlink to open an Excel file saved on a shared drive. For some reason not all users use the identical file path, though all the paths being used point to the same file. I wonder if I can put in multiple file paths in the Hyperlink property. If path1 fails, then use path2. That way, whoever clicks the link will be able to open the file.

Thanks for any ideas.
0
nnrsc
Asked:
nnrsc
  • 4
  • 2
1 Solution
 
Kelvin SparksCommented:
I would suggest using the UNC or Fully Qualified Filepath in the hyperlink rather than mapped drives. i.e.  //servername/folder/subfolder/..../filename.xls
 
Kelvin
0
 
peter57rCommented:
Kelvin has indicated the correct approach for this issue.

For no points, the direct answer to your Q is No you can't.  If users control their own mappings then you would probably have to create a new table of related hyperlinks and use code to cycle through all possible options.
0
 
nnrscAuthor Commented:
Actaully two paths are involved, say path1 and path2. They are in the format of \\server\...\filename.xls.

This form is part of the front end interface for users to pull from the backend database. Users save the interface on their laptop. The  backend database saves on the shared dirve.The Excel file concerned also resides on the shared drive in the same folder with the backend database.

What I have for now two versions of interface. One with path1 built in the Hyerplink Address property for the form. The other with path2 for the same field. It creates pains for keeping them in sync when updates happen.

User just make use of the form. They don't touch or specify the hyperlinks property. Only that one group of users have path1, another have path2. A complicated issue why it was set up that way. But That is the situation I have to live with.

Any suggestions based on such situation? I am fine with creating a table for the two paths. But honestly don't know what to do from there.

0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Kelvin SparksCommented:
Is the hyperlink in a field or an actual hyperlink embedded on the form?
 
Kelvin
0
 
Kelvin SparksCommented:
You also say the front end if dragged up from the same location to their laptops. How are the tables relinked at that stage if the some have path1 and some have path2?
 
Kelvin
0
 
nnrscAuthor Commented:
It is a hyperlink embedded on the form. I used a label. Users click that label, the underlying hyperlink opens the file.

For now I have two version of interfaces. One with path1 built in, another with path2. For path1 users, if you use the interface with path2 built in, they get an error message of no authorization. This does not sound optimal. I am looking for one interface only. Users click one label, the interface try path1 first. If that user does not have access through path1, then automatically try path2. A user is either with path1 ot path2.
0
 
Kelvin SparksCommented:
I'm guessing that if you move to one interface, the table linking will need to be addressed as the interface starts. It will need to identify the correct path that applies to that user to correctly connect to backend tables - this is often achieved by a startup dialog that prompts for the path (or by some other means that identifies the correct path). This same routine could be extended to edit the path of the hyperlink through VBA, thus starting the front end resolves the hyperlink.
 
Kelvin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now