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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

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

access 2003 training - Hyperlinks

ResolvedVersion Standard

Fri 21 Sep 2007, 17:02 Delegate 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)?

Mon 8 Oct 2007, 11:42 Trainer 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 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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

access 2003 training - Hyperlinks

Hyperlinks

RE: Hyperlinks

Access articles

Access tip:

Closing form after a certain time period