Browing for a file

[Iainkerr01]

I am creating an Email system from within Access 2000. I=On the form, I wnat to create a "Browse" button to look for the file to be added as an attachment. Once the file has been found, I want to return the path and filename to a field on the form. Any ideas please?

 

[dhookom]

There is API code for a function at

http://www.mvps.org/access/api/index.html.

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]

 

[Iainkerr01]

Thank you. That works very well. Only forther question I have is how to alter the initial directory that is opened.

 

[dhookom]

There is a function on the page that allows the programmer to use an initial folder.

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]

 

[JoeAtWork]

Put the folder path in the InitialDir parameter of ahtCommonFileOpenSave.