MS Access 03 links, hyperlinks and headaches!

  • Thread starter Thread starter campbell.robin
  • Start date Start date
C

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

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

Back
Top