Good morning, everyone.
I have a form which I use to store some selected files (any type) in a table. In the form there is a button which allow me to open "Explorer" and select the file, the code i use in the "Click" event is the following:
Me.LinkName.SetFocus
RunCommand acCmdInsertHyperlink
For information LinkName is the field (Type Hyperlink) of the table I use to store the linked files.
The scope is to avoid user select document in local disk (no visible to other users which use the interface) so my idea it was to automatically move the linked file to a specific network folder (we can call L:\Local).
Any suggestion/idea how to do? Please consider that the linked file i got on the Click event (after i select the file) is something like this:
"..\..\..\..\..\..\Local\Discipline Table.xlsx#..\..\..\..\..\..\Local\Discipline%20Table.xlsx#" (refer to the "Discipline Table.xlsx" file located in the path C:\Local\.
Thank you in advance,
Cheers
I have a form which I use to store some selected files (any type) in a table. In the form there is a button which allow me to open "Explorer" and select the file, the code i use in the "Click" event is the following:
Me.LinkName.SetFocus
RunCommand acCmdInsertHyperlink
For information LinkName is the field (Type Hyperlink) of the table I use to store the linked files.
The scope is to avoid user select document in local disk (no visible to other users which use the interface) so my idea it was to automatically move the linked file to a specific network folder (we can call L:\Local).
Any suggestion/idea how to do? Please consider that the linked file i got on the Click event (after i select the file) is something like this:
"..\..\..\..\..\..\Local\Discipline Table.xlsx#..\..\..\..\..\..\Local\Discipline%20Table.xlsx#" (refer to the "Discipline Table.xlsx" file located in the path C:\Local\.
Thank you in advance,
Cheers