I would like to store list of file names and paths in a text/hyperlink field in an MS-Access database.
I have created a form with VBA code to maintain the records in the table.

One way to get the filename would be to display a FileOpen dialog box to the user and get the complete file name with path.

This is possible in MS-Excel using the function:
filename = Application.GetOpenFileName ()

Is there any way I can do the same in MS-Access?

Download the database compactor posted here:
http://www3.sympatico.ca/qaissuper/Index.html

That has the function to open a FileOpen dialog box and return the string path and is posted in mdb format so you can see how it works.

Ian

Go here

ftp://www.athree.com/pub/candace/access_downloads_html.htm

and download the Windows Common Dialogs.

Buy the book "Access 2000 Developers Handbook". The accompanying CD contains a class that can be used by anyone with Access. I just used it and it works very well. The Common Dialog Box Control is problematic. It does not come with Access except for the developer version. Besides the books is very well regarded and is about 1,500 pages.

Hi Guys,

Thanxalot for your helpful replies.

I have used the Microsoft Common Dialog ActiveX control to solve my problem.

Thanx again.
NansK