access 2003 training - hyperlinks
The UK's Number 1 for Microsoft Office Training
Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » access 2003 training - Hyperlinks

Recommend training98.1 %
recommend us
More live stats...

The UK's most regular
instructor-led training courses.

Training information:

See also:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

See also:
Hints and tips
Forum topics

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

access 2003 training - Hyperlinks

resolvedResolved · Low Priority · Version Standard

replyReply Fri 21 Sep 2007, 17:02Delegate Edward said...

Edward has attended:
Access Advanced course

Hyperlinks

Is it possible to program access hyperlink fields in a design mode so that cells in the table do not need to be edited individual?
How can I avoid having to insert a hyperlinks for emails each time ("mailto :" done automatically)?

For upcoming training course dates see: Pricing & availability

replyReply Mon 8 Oct 2007, 11:42Trainer Carlos said...

RE: Hyperlinks

Hi Edward

The simple answer is NO you cannot add "mailto:" in the table design mode.

To automatically add the "mailto:" to an email address would require VBA coding.

One way would be that the address was entered through a form.

Then VBA code would be added to the form so as to add the above text to any email address entered by the user.

Regards

Carlos

 

Access articles

· Getting To Grips With Templates In Access 2007
· Take an Access Course to Learn About Relational Databases
· Getting to grips with Access 2007's Opening Screen and User Interface
· How To Create An Index Report In Access
· Getting To The Nitty-gritty Via Microsoft Access

Access tip:

Create An Inaccessible Field On A Form

There is sometimes a need to make a field in a form look like a normal field but be completely inaccessible to the user. To do this:

In the Field's Properties
Set the ENABLED property to No
Set the LOCKED property to Yes

The field will not grey out, but the user will not be able to do anything with it.

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. infomst
All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy