Building Access Database Help

I am doing a Database for a Church So they can keep a list of their music, instead of using overheads now they want to use a Computer.

What I have done it created a Microsoft Access Database with a table that has the following colums:

SongID (Text)
SongName (Text)
SongWord (Hyperlink)

Each song has its own SongID such as ABC123 and its song has a file named the SongID that has the words in it such as ABC123.pdf

Because they people who will be using it aren't that good on computers what I would like is something that when they add a new song, they type in the SongID, SongName, and instead of typing in the Path to the Document such as D:\ChurchMusic\Songs\ABC123.pdf manually, I would like a File Dialog or something like it where they can search for the file and once they have found it and clcik on it, it automatically puts the path to the document into SongWord Colum

Can anybody help me out

Install the Office Object library and use Office's FileSearch in VBA code. You can list the available file names in a list box from which selection can be made. There is also a limited file dialog support (Windows 2000/Office 2000) and you can copy the sample procedures from the MS Knowledge base. A list box with FileSearch is a more versatile option.

I created an application to save scannable pdfs to a file, each with a unique file name

Use the common dialog control to allow the user to browse for a file on a hard disk, to upload

This file will allow you to save the file...

To search for a file....use the pdf.ocx if you search for it on your hard drive, you can use the VBA
API to insert a Active X Control. You can then create a search engine to find the correct sheet of music u are looking for.

Hope this gives you a few ideas....

I would look for VB controls in a nutshell book, this will tell u how to use the common dialog control. There is also VB code out thereto display a particular file in the control.
mark