How can I Save Link/Path to Record After Browsing Folders?

[Kate Cz via AccessMonster.com]

Hello - can anyone help with how to save the path to a document into a
textbox in a record on a form?

I have successfully used the code found at
http://www.mvps.org/access/api/api0001.htm to browse the folders, but am not
able to save the document path (as a hyperlink to be accessed at any time
once saved) into the textbox i have created for the link in each record.

One recommendation in this discussion group was to use the code Me.Text46 =
TestIt() to link (?) the code in my module (ie the code from
http://www.mvps.org/access/api/api0001) to the text box. This places the path
found during browsing into the text box, but once I exit, the link is not
saved. The user should be able to pull up the (word) document from the record.


Thank you very much!

 

[Larry Linson]

Answered in another newsgroup. If you feel compelled to post to multiple
newsgroups, which usually is not necessary, please have the courtesy to
crosspost with all the newsgroups in the list, so that answers will
proliferate to all the newsgroups, and people won't waste time posting
almost identical answers. Please also review
http://www.mvps.org/access/netiquette.htm for other good suggestions on
effective use of newsgroups.

Larry Linson
Microsoft Access MVP

 

[Kate Cz via AccessMonster.com]

Will do. I accidentally posted to the wrong newsgroup and then re-posted to
the right. Is there a way to take back a posting? If not, will be more
careful.

Answered in another newsgroup. If you feel compelled to post to multiple
newsgroups, which usually is not necessary, please have the courtesy to
crosspost with all the newsgroups in the list, so that answers will
proliferate to all the newsgroups, and people won't waste time posting
almost identical answers. Please also review
http://www.mvps.org/access/netiquette.htm for other good suggestions on
effective use of newsgroups.

Larry Linson
Microsoft Access MVP

Hello - can anyone help with how to save the path to a document into a
textbox in a record on a form?

[quoted text clipped - 15 lines]

Thank you very much!