add a "browse" button on a form...

  • Thread starter Thread starter Ohad
  • Start date Start date
O

Ohad

Hey,

Do you know how to add a "Browse" button on a form
so that the file I chooose will be added to a table as a
link?

Thanks a lot,
Ohad.
 
If you use a Hyperlink type field in your table, you can just right-click it
in your form to select the file, or use the Insert menu to insert a
hyperlink.

If you want a command button as well, put this into its Click event
procedure:
Me.[NameOfYourHyperlinkFieldHere].SetFocus
RunCommand acCmdInsertHyperlink

If you are not familiar with hyperlink fields, see:
Introduction to Hyperlink fields
at:
http://allenbrowne.com/casu-09.html
 
Thanks a lot! :-)
Ohad.
-----Original Message-----
If you use a Hyperlink type field in your table, you can just right-click it
in your form to select the file, or use the Insert menu to insert a
hyperlink.

If you want a command button as well, put this into its Click event
procedure:
Me.[NameOfYourHyperlinkFieldHere].SetFocus
RunCommand acCmdInsertHyperlink

If you are not familiar with hyperlink fields, see:
Introduction to Hyperlink fields
at:
http://allenbrowne.com/casu-09.html

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

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

Ohad said:
Do you know how to add a "Browse" button on a form
so that the file I chooose will be added to a table as a
link?

Thanks a lot,
Ohad.
Click to expand...


.
Click to expand...
 
Back
Top