N
NTC
have searched thru the hyperlink Q&As but not quite found this clearly
explained. In A2003 have table with one column is hyperlink property. via
Form user has populated records using the edit hyperlink method to put in
(actual path not just displayed)i.e.:
Z:/folder1/folder2/image1.jpg
now the systems people are rearranging servers and the new path is going to
be:
X:/folderX/folder2/image1.jpg
repeat for thousands of records where the Z:/folder1 is replaced by X:/folderX
so that is the task; for a one time mass change of a field/column's values
I would normally go in and do a one time update query. Is this feasible with
the hyperlink class property? Is so would appreciate a brief example.
If not, then I suppose one could implement a gradual change 'on the fly' via
vb code in the user's form that is triggered as they use the application. If
this is the only way to carry on would appreciate a brief example on this
approach.
thanks for advice - - I only deal with hyperlink once in a blue moon and so
each time I revisit it there is a bit of mystery about it still for me even
after reviewing the hyperlink class info in help....gracias.
explained. In A2003 have table with one column is hyperlink property. via
Form user has populated records using the edit hyperlink method to put in
(actual path not just displayed)i.e.:
Z:/folder1/folder2/image1.jpg
now the systems people are rearranging servers and the new path is going to
be:
X:/folderX/folder2/image1.jpg
repeat for thousands of records where the Z:/folder1 is replaced by X:/folderX
so that is the task; for a one time mass change of a field/column's values
I would normally go in and do a one time update query. Is this feasible with
the hyperlink class property? Is so would appreciate a brief example.
If not, then I suppose one could implement a gradual change 'on the fly' via
vb code in the user's form that is triggered as they use the application. If
this is the only way to carry on would appreciate a brief example on this
approach.
thanks for advice - - I only deal with hyperlink once in a blue moon and so
each time I revisit it there is a bit of mystery about it still for me even
after reviewing the hyperlink class info in help....gracias.