IN THE SPOTLIGHT: MDE to MDB Conversion Service
(also supports: ACCDE to ACCDB, ADE to ADP, etc)
IN THE SPOTLIGHT: vbWatchdog
VBA error handling just got easier...
" vbWatchdog is off the chart. It solves a long standing problem of how to consolidate error handling into one global location and avoid repetitious code within applications. "
- Joe Anderson,
Microsoft Access MVP
Meet Shady, the vbWatchdog mascot watching over your VBA code →
(courtesy of Crystal Long, Microsoft Access MVP)
IN THE SPOTLIGHT: vbMAPI
An Outlook / MAPI code library for VBA, .NET and C# projects
Get emails out to your customers reliably, and without hassle, every single time.
Use vbMAPI alongside Microsoft Outlook to add professional emailing capabilities to your projects.
Provided by Allen Browne, email@example.com
Access 97 introduced this field type for storing links to files on:
A hyperlink entry contains three parts separated by pound signs (#). The template is:
display text # file name # any reference within the file
Use the Insert menu to add a hyperlink entry, and Access takes care of the three parts. Only the "display text" part of the field is shown, and clicking on the field executes the link.
So how can you view its full contents or edit the field?
Some examples may help show how this works:
|Hyperlink Contents||Displays||When Clicked|
|My photo#c:\pix\photo.bmp#||My photo||Loads picture into MS Paint.|
|SS data#ss.xls#Sheet 1!G9||SS data||Loads spreadsheet into Excel, selecting cell G9.|
|Do labels#\\jane\pub\label.doc#||Do labels||Loads the network document into WinWord.|
|Edit Clients##Clients||Edit Clients||Opens Clients form in current database (no file specified).|
|Sales info##Query Sales||Sales info||Runs the Sales query in the current database.*|
|IBM#http://www.ibm.com#||IBM||Loads your web browser and opens the URL.|
|#www.canon.com#||www.canon.com||Loads your web browser, assuming prefix of "http://".|
|Home||Index of tips||Top|
This is a cached tutorial, reproduced with permission.
Have your say - comment on this article.
What did you think of 'Introduction to Hyperlink fields'?
No comments yet.
Why not be the first to comment on this article?!
Have your say...