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.