Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » access advanced courses - Hyperlinks in Access

	98.1 % recommend us
	More live stats...

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

Training information:

access advanced courses - Hyperlinks in Access

Resolved · Low Priority · Version Standard

Reply Fri 21 Sep 2007, 17:02Delegate Philip said...

Philip has attended:
Excel Advanced course
Access Advanced course
Project Intro Intermediate course

Hyperlinks in Access

Is it possible to program Access hyperlink fields in table design mode so that cells in tables do not need to be edited individually? How can I avoid having to insert a hyperlink for e-mails each time ("mailto:" done automatically)?

For upcoming training course dates see: Pricing & availability

Reply Mon 8 Oct 2007, 11:57Trainer Carlos said...

RE: Hyperlinks in Access

Hi Philip

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

· Want to Become the Office Hero? MS Project Training Could be the Answer
· Access Corruption Avoidance Tip #3: Stay Connected
· Quick Access Database Courses: A 10 Step Lesson in Encrypting and Decrypting an Access Database
· So You Still Haven't Learned How To Use Access Yet?
· 3 Useful Things You'll Learn in Microsoft Access Training Courses

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.

View all Access hints and tips