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.
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.
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.
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.
ASKER
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.
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.
Is the hyperlink in a field or an actual hyperlink embedded on the form?
Kelvin
Kelvin
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
Kelvin
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Kelvin