How do I list applicable hyperlinks within Access 2007?

M

McCloudK

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

alemanp

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
Open specific hyperlink (accept) automatically in email with outlook 0
Where is Insert Hyperlink on 2007 1
Closing Access on Open application 4
Hyperlinks in FE Database and SQL Backend do not work HELP 2
Hyperlinks don't work anymore - two problems 5
Hyperlinks in Access 1
default hyperlink path 4

Top