I'd like to create a central library for our company files on Access, which would open them as Windows Explorer does. I've tried hyperlinking, which opens pdf, doc files etc ok, but if I link to a MS template file (dotx etc), it opens up the original file, and not a new file.
Is there any script or suchlike I can use, so that clicking on them would open up a new instance, in the same way that double-clicking in Explorer does?
However, I'd like the filepath to vary by record, so that every record can open their respective files. I've tried something similar below, but it's not working - possibly because there's spaces in the filepath. Has anyone got ideas?