Insert Hyperlink Button

[Russ via AccessMonster.com]

Has anyone found a way to have a button on a form allowing a simple way to
insert a hyperlink in a field?
I am looking to have a form of all documents for an asset i.e. receipt,
manual, purchase order.
These documents will be all types of formats, i.e PDF, word documents, excel
documents and scanned documents.
I have a form called Add an attachment
With the following fields;
Description
Filename or URL (need simple button to add hyperlink)
Notes

Thanks in advance for any help…

 

[Allen Browne]

In the Click event procedure of your command button, SetFocus to the
hyperlink field, and then RunCommand acCmdInsertHyperlink.

 

[rmgalasinski via AccessMonster.com]

Thanks Allen,
That looks great!
How can I stop the error if I cancel or close the Inserthyperlink?
Again, thanks for the help!

In the Click event procedure of your command button, SetFocus to the
hyperlink field, and then RunCommand acCmdInsertHyperlink.

Has anyone found a way to have a button on a form allowing a simple way to
insert a hyperlink in a field?

[quoted text clipped - 8 lines]

Filename or URL (need simple button to add hyperlink)
Notes

 

[Allen Browne]

Use error-handling to trap and ignore the error -- probably 2501.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Thanks Allen,
That looks great!
How can I stop the error if I cancel or close the Inserthyperlink?
Again, thanks for the help!

In the Click event procedure of your command button, SetFocus to the
hyperlink field, and then RunCommand acCmdInsertHyperlink.

Has anyone found a way to have a button on a form allowing a simple way
to
insert a hyperlink in a field?

[quoted text clipped - 8 lines]

Filename or URL (need simple button to add hyperlink)
Notes