Hello,
I have a table that has a calculated field named "Unique Sample Number". Each unique sample number has its own folder on the computer. There is a "Folder" field in the table which is a hyperlink field and when clicked it should open the folder for each individual sample.
I would like to create an automated hyperlink in the "Folder" field that is updated as new samples are added to the database.
I have tried to use a Before Change data macro to load the values needed. However, it is unfortunately not working.
The process I have tried is as follows:
SetField
Name = Folder
Value ="#S:\Technical Library" & [Unique sample number]" & "#"
Any help is appreciated!
I have a table that has a calculated field named "Unique Sample Number". Each unique sample number has its own folder on the computer. There is a "Folder" field in the table which is a hyperlink field and when clicked it should open the folder for each individual sample.
I would like to create an automated hyperlink in the "Folder" field that is updated as new samples are added to the database.
I have tried to use a Before Change data macro to load the values needed. However, it is unfortunately not working.
The process I have tried is as follows:
SetField
Name = Folder
Value ="#S:\Technical Library" & [Unique sample number]" & "#"
Any help is appreciated!