Lesson 2	Using hyperlinks on your forms
Objective	Create hyperlinks on forms in order to open other forms, applications, or access the Web.

Using Hyperlinks on your Forms

Hyperlinks are a common feature on the Web. Clicking a hyperlink takes you to another area within a Web site or to an entirely different website. You may be asking yourself, “What good is a hyperlink going to do me when I am not on the Web?” The answer is easy. You can use hyperlinks in your databases to:

Open other forms, reports, or queries
Open other applications such as Word and Excel
Jump to a Web site

All of this can be performed without programming. You just have to get comfortable with the Edit Hyperlinks dialog.

View the series of images below to see how a command button is used to create a hyperlink.

1) Here is the command button, called cmdOpenClientForm, with its property sheet open. Notice the space for Hyperlink Address and Hyperlink SubAddress entries in the Format tab of the property sheet. The Builder button next to the Hyperlink address is clicked.

This is the default view pof the Insert Hyperlink dialog. It is set up to specify a hyperlink to a web page. However, in this demonstration we will bge opening an object in the database. — 2) This is the default view of the Insert Hyperlink dialog. It is set up to specify a hyperlink to a web page. However, in this demonstration we will be opening an object in the database.

3) You click the selection "Object in This Database" to get a tree-style view of the objects in your database.

4) The Clients form is selected under Forms.

5) After you click OK, the Insert Hyperlink dialog is closed and the Hyperlink SubAddress property is updated.

6) Now, when the form is opened, the command button acts just like a hyperlink. When the command button is clicked, the Client form is opened.

Only the Hyperlink SubAddress property is filled

As you can see, when the hyperlink connects to a form in the same database, only the Hyperlink SubAddress property is filled in. If the form is located in another database or you are specifying a website, then the Address property would also be filled in. For instance, if you wanted to take a look at my Web site, then the Address property would be set to https://www.ooportal.com.
You can use hyperlinks with command buttons, images, and Label controls. In the next lesson, you will learn how to create a hyperlink to open a Web site.

Using Hyperlinks On AccessForms - Exercise

Click the Exercise link below to practice creating a hyperlink to open a Web site.
Using Hyperlinks On AccessForms - Exercise