MS Access 03 links, hyperlinks and headaches!

[campbell.robin]

Hello!

I'm having trouble with links and hyperlinks in MS Access 2003 - any
help would be great!

Question 1!

The "insert hyperlink" icon opens a browser window, allows the user to
browse to the desired file and paste the hyperlink on the form (which
obviously remains for on all the records). I am trying to create a
database of files and want to have records with individual links (i.e.
record one has a hyperlink to word1.doc, record two has a hyperlink to
word2.doc).

Can anyone be clever and explain how you can get the functionality of
the insert hyperlink function but recording the value in a table's
field (so you can have individual links for each record)???? (Perhaps
you have made a macro to run off a button...)

Question 2!
This database will be copied to different machines. Using the "insert
hyperlink" function avoids problems of updating hyperlinks by using the
"hyperlink base" in the "file/database properties" tab. If I move the
database to another machine, will the hyperlinks opening files still
work if the program locations are different to the machine which the
hyperlinks were created on???

Thanks!

 

[Guest]

Hi,
instead of a hyperlink use a normal text type field.
Then on a form use this to call the standart save/open diealog window:
http://www.mvps.org/access/api/api0001.htm
This will then retrieve the full path to a file.
Save the path in that field you created and then you can use the
followhyperlink method at runtime to execute it if you want:

Application.FollowHyperlink Me.YourPathControl

Where YourPathControl would hold the full retrieved path. You can use this
on the on click event of the control or a button...
The path will not be the same if you move this unless the files are on a
server/shared folder. You can then specify the absolute path and it should
work from anywhere if access to this shared folder is given.
HTH
Good luck