Dialog Box

[matt001]

Database Form Help

I am doing a Database or 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

 

[Parker]

I am doing a Database or 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

If your songs are stored in .pdf format why don't you just make an adobe index with hyperlinks to the songs?

If you are storing documents in .pdf form how are you getting them? do you get them in that format or are you converting them yourself?

If I've got youre drift right I think this is one occasion when I wouln't use Access (and that is rare) Unless there is more that you're not telling?
PDF indexes can be searched so you would have exactly the same facility as you are trying to design in Access and your users only need to add the song title to the list. In fact, I'm not sure, but I think I saw an index builder for just this idea that works in an HTTP enviroment. but anyway it can all be done through your browser if you want.

 

[Mile-O]

With your original question, though, Matt - this thread has an attachment for you to look at.