Trying to link to a file

[wrbuchanan2]

I have an access database that I am creating cataloging some class rosters that are in .pdf format. I have created a table that show the basic file location of the rosters. Each roster has a unique activity code. I tried to create a query that a form can use to take the basic file location and concact the activity code from a user input so it will create the link directly to the file. I am unable to make the field in the query or in the form into a link? Any help on how I can do that? I have been playing around a bit and found I can create a form from a table that has the full file address including the activity code that I can link and open the file. I really want it so the user can specify which activity code and be able to get the link for that specific. I don't want to really add a link to every activity code in a table. An example, I teach a class called "apples". The rosters for apples are in c:\apples. I want to enter the activity code for a specific apples class and concact the information to show as a link in a form such as file://c:\apples\activitycode.pdf

[June7]

A hyperlink can be saved into a Hyperlink field in table.
Textbox has Hyperlink property.

Also review
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx
http://allenbrowne.com/casu-09.html
http://allenbrowne.com/func-GoHyperlink.html

Post your attempted code for analysis.

[wrbuchanan2]

I hadn't written this as code...was just using a basic form and query. I am fairly new at access and just doing some things to gain experience and understanding. I have worked with visual basic before in classes, but haven't wrote any in access yet.

[June7]

Explore and test the options given and when you encounter specific issue, post question.