Attaching Files Using A Form

[RyanB]

Hi all,

I'm new here and currently creating a database.

In one of my forms I want for users to be able to attach a file to the database, well save there local file to a network drive.

So I want there to be a field with the path, a browse button to select the location and a attach button, also if possible I would like a value from a field in the form to be the file name.

Is this do-able? any help?

Cheers,

Ryan.

 

[Oldsoftboss]

Hi RyanB. Welcome to the forum. You might like to try the search facility, there is a mountain of info, and yes, what you are asking is very "do-able"

The main thing you need to do is ensure the references in the VB window are set to DAO 3.6

The following link contains an attachment that demonstrates all you need to know. The 3rd button down is what you are after.

http://www.access-programmers.co.uk/forums/showthread.php?t=62253

Dave