Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access advanced courses - hyperlinks access

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

access advanced courses - Hyperlinks in Access

ResolvedVersion Standard

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)?

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 tip:

Duplicating an Entry

To duplicate the entry press CTRL+' (apostrophe)this will copy the contents of the previous entry in the same field.
(Table view, line above) note this also works in Excel.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.