How do I list applicable hyperlinks within Access 2007?

  • Thread starter Thread starter McCloudK
  • Start date Start date
M

McCloudK

I would like to place hyperlinks to Word & Excel documents into some of the
tasks listed in a Access 2007 project database.
 
I would like to place hyperlinks to Word & Excel documents into some of the
tasks listed in a Access 2007 project database.  
Click to expand...

Are you thinking of listing them in a separate column dedicated to
holding a single hyperlink? If so, the answer is easy. Simply store
the path and filename delimited by pound signs. Then in the Click (or
DblClick) event of the text box in a form, issue one command:

Me.txtTextBox1.Hyperlink.Follow

The doc or spreadsheet will open when you click or dblclick.
Theres also a more complicated method to put the hyperlink in a
Label. It is more elegant, but more complicated. (I've never done
it.)

Pete Aleman
Vancouver WA
 

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

Similar Threads

Access 2010 Disable Microsoft Access Security Notic 3
Where is Insert Hyperlink on 2007 1
Hyperlink field that does not link to the file 3
Closing Access on Open application 4
Open specific hyperlink (accept) automatically in email with outlook 0
multivalued hyperlink 1
Type mismatch error - Setting Hyperlink Base property 2
Sometimes Text data may be better than Hyperlinks 1

Back
Top