Hello,
in an access form, there is a hypertext field called "Hyperlink"
Text displayed = "CCP B 001"
Link to file = "T: \ CERTIFICATION \ AQ \ DAQ \ DAQ_L \ CCP 001.xlsx"
Tooltip = "CPP number 1: cooking temperature"
I want to modify this field with VBA so that it becomes:
Text displayed = "CCP001"
Link to file = C: \ TEMP \ CCP 001.xlsx "
Tooltip = "Temporary CPP number 1: cooking temperature"
How to do this in VBA please ?
Thanks a lot
Alain