Link to Outside Folders

[Scott Dufour]

Can Access link names within a table to outside existing folder.? For
example, an employee has information entered into the Access database and
also have information scanned into (PDF) a folder with that same employee
name. Is is possible to link the two together? So I can look up the
information for that employee in the folder and if it is possible, can it be
done to multiple employees?

 

[Lord Kelvan]

yeah create a hyperlink field in the employee table which has the path
of that folder

ie

c:/foldername

and when you click the hyperlink it will open that folder in windows
explorer are all employees folders in the same place and in the smae
format ie

if this is your table
employeefirstname employeelastname
john smith
jane bob

the foldername will look like

john smith
jane bob

and both in the directory

x:\employeefolders\

as an example

if so then you can create the field then do a mass update for that
field using a query if not then you haev to do it one by one

Regards
Kelvan

 

[Scott Dufour]

This helps tremendously. Thankyou