Create Hyperlinks

[Guest]

am building an Access database that will hyperlink to monthly reports for
about 200 projects. The monthly reports are in an excel format and stored on
a common drive on the network and I have about 3 months worth of reports that
I need to link the db to. so that’s about 600 hyperlinks that I have to
initially create and then 200 each month.

I have the tables, queries, and reports built and trying to find an
efficient way to insert the hyperlinks instead of clicking on each record and
pointing to the right file. All of the excel reports have a common naming
convention that starts with the project # and ends with the report’s month.

I am relativly new to access and dont know much about VBA code but pretty
sure there is a way and probably a simple one that will make this happen


Thank you in advance for you help

 

[Guest]

Hi

A simply way to do this would be to create a concenated field based on the
autonumber and month. Include this in the hyperlink and ensure the excel
files are numbered in the same way. This way you will not have to insert the
hyperlink address for each record.

BUT

For record already created I would think its just a matter of sitting down
and whizzing some data input. Once you are up to date you will be able to
use the concencated field.

Sory no more time as off out now but good luck. If you have problems with
this repost and someone else will take you throught it.

 

[Guest]

Ya I do need someone to walk me thru it. I am not sure how to go about it.