OPen a file and save with Access

[bonekrusher]

Good Afternoon,

Does anyone know where I can find a sample db that will let the user do the following:

Selected a file from their computer and upload to a the same folder as the db?

I am building an Investigation database. This function will allow the user to attach file to an investigation. (the files will be stored in a folder and logged on a table)

Any help would be great.

Thanks,

Bones

 

[WayneRyan]

Bones,

Search: "Browse And GHudson"

http://www.access-programmers.co.uk/forums/search.php?searchid=727461

That'll show you how to find the file.

See help on FileCopy for the syntax to copy (or rename) the file to
application.CurrentProject.Path

Wayne

 

[bonekrusher]

Thank you Wayne,

I have this file and will try working with it again (Browseing). The "import" function of the sample imports the Windows.ini file to the table, I just want the user to be able to save the file (tbFile) to a specific location on a server (for example f:\tempfiles).

Thanks,