I have designed a database that allows you to manage all the words
for songs. So the user opens the database they can either add a song
to the list by entering the SongCode, SongName and they browse to
where they placed PDF file which has the song words
Then they can go and search for a song by entering in the SongCode
and then it opens up the query displaying the name of the song and
the hyperlink to open up the PDF File.
What I am after is their away that when the user types in the
SongCode and presses enter it automatically opens up the PDF
Document instead of showing that record a clicking the hyperlink.
And if they type in the wrong SongCode it comes up with an error
message saying "you have typed in the wrong code.
Matthew
for songs. So the user opens the database they can either add a song
to the list by entering the SongCode, SongName and they browse to
where they placed PDF file which has the song words
Then they can go and search for a song by entering in the SongCode
and then it opens up the query displaying the name of the song and
the hyperlink to open up the PDF File.
What I am after is their away that when the user types in the
SongCode and presses enter it automatically opens up the PDF
Document instead of showing that record a clicking the hyperlink.
And if they type in the wrong SongCode it comes up with an error
message saying "you have typed in the wrong code.
Matthew