Automatically connect records to files in Access 2013 WebApp

NathanBurley

Registered User.
Local time
Today, 22:38
Joined
Jul 28, 2015
Messages
19
Hi All!

I have a the beginnings of an Access 2013 Webapp which I'm using to track the laboratory instrumentation we cover at work. My ultimate goal is to use each service engineer's visit records to help create a full service history for each instrument. My issue right now:

Each instrument in the database has an final test document from the factory detailing its technical specs (these are a mix of pdf and word docs). The test Docs are named with the instrument's Serial Number. I'd like to place a hyperlink to this document in the instrument record to allow users to quickly access this information.

I have uploaded all the test documents to SharePoint and created a view from them which turns them into a SharePoint list. I've imported this list into Access as a new table called [Documents] and I know that the 'Name' field of this list is a hyperlink to the document.

What I need though is a way of removing the file extension from that name in order to cross-reference it with the Serial Numbers in the [Instruments] table.

Any help / pointers on how to do this would be amazing!

Thanks,

N
 

Users who are viewing this thread

Back
Top Bottom