Method to insert file path into database

[Moss100]

I would like to be able to click a button and have access open a window where i can browse to a file, select the file and store the file path in my database, in a field called 'filepath'

Can anyone tell me whether i can do this through a macro. If not can it be done by code?

Any help would be greatly appreciated.

Many thanks Mark.

 

[PHV]

With code you may play with the Application.FileDialog object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dhookom]

I generally include the code from

http://www.mvps.org/access/api/api0001.htm

in almost all of my MDB files.



Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]