AutoMatic Filename into Field

All,

How can I create a button that opens a dialog box that can select a file, automatically copy that file into a designated folder, then store the filename into a field in some table (for later reference in a report that can pull up that image).

Help!!

Thanks,

Dan

Check out this

http://www.dbforums.com/showthread....File+Dialog+box

You will need to weed through this and pull out the info you need. It shows you how to use a API call to open a dialog box to allow you to do what you are after

S-

Thanks Sbaxter,

I was able to get that to work for me but how can I copy that selected file (whose filepath & filename now sits in a field in some table) into another folder. It could be that I am missing something in there but I can't seem to find it.

Thanks Again,

Dan

Is VB code for copy
FileCopy PathName, NewPathName
Is VB code for move/rename
Name PathName As NewPathName

To be honest, I have never tried this from within Access, so don't know if it will work. Use it in VB 6.0 all the time

You may have to find a API like we did for the dialogbox
S-

sbaxter,

I went ahead and gave that a try but I recieved the following error:

Run-time 75
Path/File access error

Any ideas??

Scratch that last one I figured it out.

What was wrong?

S-

I put the path but not the file name in the destination portion of the Filecopy command.

Its the little things I look over!!

Thanks.. Dan