NathanBurley
Registered User.
- Local time
- Today, 17:44
- 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
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
