Open External File linked to CustomerID

Download Sample Access file: Open External File linked to CustomerID

You can open the external file like MS Word or PDF format from MS Access. This sample file will demonstrate how to open the external PDF file that has a filename matches with the customer ID in MS Access. For instance, I have the PDF file name “3.PDF” located in some folder on my computer for match with the CustomerID = 3 on Customer table. After I click the Customer_ID =3 on the Customer_ID field on form, the Adobe Reader will open file 3.PDF. See full details

This file contains:

2 Tables: 1. table Customer, 2. table Customer type

2 Forms: 1. Customer form, 2. SearchWithOption using VBA

1 Module with two functions: 1. test file if exists and 2. openfile

Related posts