I hope I can explain this one well enough for the experts to understand.
I have a form which has a field named txtNCMR which is a number field.
When the user clicks on that field I want them to be directed to an Excel file in a specific location and have that Excel file open.
The location of the Excel file(s) is C:\Users\Steve\Desktop\CompanyNameNCMRFiles
This path is held in a setup table named tblSetup in a field named "PreviousNCMRfiles".
So for example if the txtNCMR value on the form is 12345 then I want the user to be directed to C:\Users\Steve\Desktop\CompanyNameNCMRFiles\12345.xls and have that file open for them.
If the file 12345.xls doesn't exist then I'd like them to get a message indicating that there is no such file on record.
Is this possible?