vba - Converting plain text in SQL to hyperlink in Access -

I have started my first job before leaving university and in this form my first task is to completely change. Front-end, SQL Back-End Access 2003 database.

There is a series of front end forms for adding or reviewing staff data in the Access database, as part of this, indicates hyperlinks, the picture of the employee and the CV exists on a shared drive. These were saved as hyperlinks within Access DB.

I have converted the data into SQL in Access DB and stored it in the database to test it, as part of the data conversion and now converted the CV locations from hyperlinks to nostrils. I went. I have done this using SSMA.

My problem is that I need to display this text link and work as hyperlinks on the end of the hidden end of the words "photo" and "cv", but am about this It is uncertain how to go about this, as I have never accessed SQL and already.

Any help or suggestion will be appreciated and if I have not been clarified in any area feel free to ask questions and I will try to clean anything for you.

You can do this for example

Caption on "Picture" or Set the label

Follow:

• Enter a command button or text control in your details section.
Add an "onclick" event
• In the onclick process, see the field in the record set in the path of the file
• Use this value to launch the followHyperLink method < / Li>
• For example, you can control the command button control or text controls for "Pictures", for the second "CV", etc.

One is another "employee" mainly with the "staff document" subform You can then list all the documents related to a person without any restriction on the number of available documents (we are talking about multiple relationships between staff tables and staff document tables), but the same principle Will: Some actions on the click or tax employee document, you get the file name from the underlying record set and send it in the application. Phyllo hyperlink method It can also be done through a command button on the record lines or through the command bore control button on the main menu bar, or the main advantage with the commandbar on the shortcut menu is that you can increase the number of labels on your form Can add extra functionality to the control.

For example, the commandbar makes it easy to add some extra commandbar buttons that allow you to match (2) files to anyone (with some Outlook automation code) or (3) file your computer .

Working with commandbirds, a typical "document" menu on our app will look like this:

(Sorry for the French version but ... ) Where the last three commands have been allowed to view / copy / send the linked file to Bourcruntol. Allow to upload files from two pre-scanners or from an existing location.