Access links, hyperlinks and headaches!

[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!

[Anthony England]

"Robin" <ca************@gmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...

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!

The hyperlinks are a pain in the neck and simply not worth it. You should
just store the path to the document in a palin text field. The simplest
case is when all documents are in the same folder, so you only need to store
the document name and the full path can be worked out by adding, say
G:\PublicStuff\WordDocs\ to the file name Doc1.doc.
That way if you can easily change the folder if you decide to move them.
And better then a mapped drive such as G:\ might be the unc path such as
\\Server1\Company\Public\WordDocs\

Then code in your form opens the correct file - loads of examples of this
have been posted and I suppose it depends on whether they will all be Word
or whether you might also have some Excel stuff.