I have a hyperlink field in my form.
I want my users to
identify an excel spreadsheet in a specific folder and then
"paste" a link to that spreadsheet into my access form.
I want this to be a simply cut and paste.
Question: How can I CUT a hyperlink that hold my folder path AND my file name.
The end result should be something like;
Note that I am already able to "cut" the folder path ...... but I am finding that I need to KEY in the actual file name. I.e. I need to key in the "bankrec.xls" .... How do I avoid keying in the filename