update query creating a hyperlink to a jpg file

G

Guest

I am creating an access database to store a summary of a written plan. That
written plan is then scanned into a network drive and I am attempting to
create a hyperlink in the access database to open the JPG file of the written
plan that is stored on that network drive. I have a query creating a unique
identification number for each plan and I am naming each JPG file that same
unique name ending with .JPG. I have an update Query creating the hyperlink
using the following in the Update to field of the query I am using -
"G:\PDCA\Scanned PDCAs\" & [PDCA id] & ".jpg"
Just for clarification the (“g:\pdca\scanned pdcas\â€) refers to the
location on the network that all of the scanned images are stored.
([PDCA id]) refers to the unique identification # for each plan
And the (.JPG) refers to the type of file.

The hyperlink is being created, but it is not “activeâ€, I am able to right
click on it and update the hyperlink by pointing to the file in that drive.
Any ideas would be appreciated.

Thanks
 
M

[MVP] S.Clark

I don't subscribe to the Hyperlink concept, but don't mind using the Shell
command to open files for other applications.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top