Loading Documents(PDF, Word etc.) in forms

M

MesG

I would like to create a feature, where a user can easily click on a button
and browse a file he/she would like to attach a file that is associated with
a unique record. How would I go about doing that? Hyperlinking is not an
option, I'm trying to make it user friendly and let the user click on a
button that says "browse files to attache" etc.
 
D

Daniel

Hyperlinks can work fine for this application.

Use a standard open/save api to allow the user to select a file (for this
look at http://www.mvps.org/access/api/api0001.htm ) then store the full path
and filename in your table. Then you can simply use the
Application.FollowHyperlink "FullPathandFileName" to enable your user to open
the files when they double-click on them.
 
Top