By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,677 Members | 1,648 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,677 IT Pros & Developers. It's quick & easy.

Memo/Text/Hyperlink... field storing a shortcut to an office file

P: 66
Hello everyone! I do not know if it is possible to do something like this in Access but let me try to ask: Is there any way to insert in an Access field a shortcut to an office file, being all the files (both the Access database and the other office files) placed in the same network??
I envision a form in which, for a particular record, some information is shown. Nevertheless, for additional info, the user must open some other Office file, say a Word or Excel one. Obviously, you could also direct the user to the particular office file by telling him/her where this office file is placed (and then surf over the network and locate it). But a shorcut would be here of much help. My point here is that I do not know if this kind of shortcuts can be placed in Access. maybe they would be similar to the shortcuts that you are able to create if you right-click in an office file and then choose "create direct shortcut" (spanish translation).

Best regards
Sep 9 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 378
The simplest way to do this, is to go into your table design and add a Hyperlink type field.

Then on the form itself, add a text box and bind it to your new hyperlink field.
Now when you right click in this field in Form view, you'll see Hyperlink options enabling you to set the link.
Sep 10 '08 #2

P: 66
Thank you very much Megalog. I will proceed as suggested.
Sep 16 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.