Browse and Attach Documents

  • Thread starter Thread starter Randy Krebs via AccessMonster.com
  • Start date Start date
R

Randy Krebs via AccessMonster.com

I have a data entry form. I need to add a browse button where the user can
browse the network for their attachment and then attach the file name to the
form. Like the yahoo attach file types where you click browse and the name
and path auto populate the text field. That's the first step.

2nd Step: Then when the User is in the edit screen they can click on the file
name and have the document come up in its native application.

Does anyone know how I can code this??

Thanks,
Randy
 
Randy,

First step is to get the file name. Refer to the subroutine at this
url:http://www.mvps.org/access/api/api0001.htm

Second, You need to create a label control on your form that you use to
pull up this hyperlink.
The label control has a "hyperlink Address" property, which you can populate
with the value returned by the function on the site referenced above. After
you get the file name, set the value in the HyperlinkAddress property of the
label to the file name. You might also want to change the name of the
caption, but maybe not.

HTH
Dale
 
Back
Top