Create a picture or command button that works as a hyperlink

1. Open a form, a report, or a data access page in Design view.
2. On a form or report, click the Image tool in the toolbox. On a data access page, click the Image Hyperlink tool .
3. Click where you want to create the picture.
4. In the Insert Picture dialog box, locate the picture that you want to use, and then click OK.

   Access adds an image control to the form or report.

   Note  If you are creating an Image Hyperlink on a data access page, skip to step 6.

5. On the form or report, make sure that the image control is selected, and then click Properties on the toolbar to open the property sheet for the control.
6. In the HyperlinkAddress property, click the Build button to open the Insert Hyperlink dialog box.
7. In the Insert Hyperlink dialog box, click Existing file or Web page under Link to.
8. Click ScreenTip, and type the text that you want to appear when the user rests the pointer on the hyperlink. If you leave the ScreenTip text box blank, Access will display the hyperlink address and/or subaddress as the ScreenTip.

9. In the Address box, type a path or a URL.

10. Click Current Folder, Browsed Pages, or Recent Files, and then click an item from the list. If you click Current Folder and don't see the object you want, select a different folder from the Look in box.

Note  To go to a specific location in an HTML file or to an object in the current Microsoft Access database (.mdb) or Microsoft Access project (.adp), click Bookmark. Click the bookmark or object you want in the list, and then click OK.

To test the link on a form or report, right-click the picture, point to Hyperlink on the shortcut menu, and click Open.

To test the link on a page, switch to Page view and click the picture.

1. Open a form, a report, or a data access page in Design view.
2. On a form or report, click the Image tool in the toolbox. On a page, click the Image Hyperlink tool .
3. Click where you want to create the picture.
4. In the Insert Picture dialog box, locate the picture that you want to use, and then click OK.

   Access adds an image control to the form or report.

   Note  If you are creating an Image Hyperlink on a data access page, skip to step 6.

5. On the form or report, make sure that the image control is selected, and then click Properties on the toolbar to open the property sheet for the control.
6. In the HyperlinkAddress property, click the Build button to open the Insert Hyperlink dialog box.
7. In the Insert Hyperlink dialog box, click Create new page under Link to.
8. Click ScreenTip, and type the text you want to appear when the user rests the pointer on the hyperlink. If you leave the ScreenTip text box blank, Access will display the hyperlink address and/or subaddress as the ScreenTip.
9. In the Name of new document box, type a name for the new data access page.

   Tip

   You can create a different type of document, for example, a Word file (.doc) or an Excel spreadsheet (.xls), by typing the three-letter file extension for the type of file that you want to create. However, you can't create a Microsoft Access database (.mdb) or a Microsoft Access project (.adp).

10. Access creates the new document in the current folder. To specify a different location, click Change.
11. Select an option under When to edit. You can edit the new document immediately or wait until later.

To test the link on a form or report, right-click the picture, point to Hyperlink on the shortcut menu, and then click Open.

To test the link on a data access page, switch to Page view and click the picture.

1. Open a data access page in Design view.
2. Click the Image Hyperlink tool in the toolbox, and then click where you want to create the picture.
3. In the Insert Picture dialog box, locate the picture that you want to use, and then click OK.
4. In the Insert Hyperlink dialog box, click Page in this database under Link to.
5. Click ScreenTip, and type the text you want to appear when the user rests the pointer on the hyperlink. If you leave the ScreenTip text box blank, Access will display the hyperlink address as the ScreenTip.
6. From the list, select the page that you want to link to.
7. To create a filter for the page, type an expression in the form of a WHERE clause in the Filter criteria for the data access page box. For example, to open the second page, which displays the records for the employee ID that is shown on the first page, type EmployeeID=[EmployeeID].

Access adds the hyperlink to the data access page. To test the link, switch to Page view and click the hyperlink. Access opens the target page in your Web browser.

1. Open a form or a report in Design view.
2. Click the Image tool in the toolbox, and then click where you want to create the picture.
3. In the Insert Picture dialog box, locate the picture you want to use, and then click OK.

   Access adds an image control to the form or report.

4. Make sure that the image control is selected, and then click Properties on the toolbar to open the property sheet for the control.
5. In the HyperlinkAddress property, click the Build button to open the Insert Hyperlink dialog box.
6. In the Insert Hyperlink dialog box, click Object in this database under Link to.
7. Click ScreenTip, and type the text you want to appear when the user rests the pointer on the hyperlink. If you leave the ScreenTip text box blank, Access will display the object name as the ScreenTip.
8. From the list, select the database object that you want to link to.

To test the link, right-click the picture, point to Hyperlink on the shortcut menu, and then click Open.

Note  To link to an object in another database, select the desired database file and then click Bookmark to list the objects within that database.

1. Open a form, a report, or a data access page in Design view.
2. On a form or report, click the Image tool in the toolbox. On a data access page, click the Image Hyperlink tool .
3. Click where you want to create the picture.
4. In the Insert Picture dialog box, locate the picture that you want to use, and then click OK.

   Access adds an image control to the form or report.

   Note  If you are creating an Image Hyperlink on a data access page, skip to step 6.

5. On the form or report, make sure the image control is selected, and then click Properties on the toolbar to open the property sheet for the control.
6. In the HyperlinkAddress property, click the Build button to open the Insert Hyperlink dialog box.
7. In the Insert Hyperlink dialog box, click E-mail address under Link to.
8. Click ScreenTip, and type the text you want to appear when the user rests the pointer on the hyperlink. If you leave the ScreenTip text box blank, Access will display the e-mail address as the ScreenTip.
9. In the E-mail address box, type an e-mail address. You can also select an address from the Recently used e-mail addresses list.
10. In the Subject box, type the information that you want to appear in the Subject field of the e-mail message.

    Note  Some Web browsers and e-mail programs might not recognize the subject line.

To test the link in a form or report, right-click the picture, point to Hyperlink on the shortcut menu, and then click Open.

To test the link on a data access page, switch to Page view and click the picture. Access opens your mail program and creates a new message, with the address and subject filled in.

1. Open a form in Design view.
2. If the Control Wizards tool in the toolbox is selected, click it to turn off the Control Wizard.
3. In the toolbox, click the Command Button tool .
4. On the form, click where you want to place the command button.
5. Make sure the command button is selected, and then click Properties on the toolbar to open the property sheet for the command button.
6. In the HyperlinkAddress property, click the Build button .
7. In the Insert Hyperlink dialog box, click Existing File or Web Page under Link to.
8. In the Text to display box, type the display text for the hyperlink. Access automatically displays the value of the command button's Caption property in the box.
9. Click ScreenTip, and type the text you want to appear when the user rests the mouse pointer on the hyperlink. If you leave the ScreenTip text box blank, Access displays the hyperlink address (and subaddress) as the ScreenTip.

10. In the Address box, type a path or a URL.

11. Click Current Folder, Browsed Pages, or Recent Files, and then click an item from the list. If you click Current Folder and don't see the object you want, select a different folder from the Look in box.

Note  To go to a specific location in an HTML file or to an object in the current Microsoft Access database (.mdb) or Microsoft Access project (.adp), click Bookmark. Click the bookmark or object you want in the list, and then click OK.

To test the link, right-click the command button, point to Hyperlink on the shortcut menu, and then click Open.

1. Open a form in Design view.
2. If the Control Wizards tool in the toolbox is selected, click it to turn off the Control Wizard.
3. In the toolbox, click the Command Button tool .
4. On the form, click where you want to place the command button.
5. Make sure the command button is selected, and then click Properties on the toolbar to open the property sheet for the command button.
6. In the HyperlinkAddress property, click the Build button .
7. In the Insert Hyperlink dialog box, click Create New Page under Link to.
8. In the Text to display box, type the display text for the hyperlink. Access automatically displays the value of the command button's Caption property in the box.
9. Click ScreenTip, and type the text you want to appear when the user rests the mouse pointer on the hyperlink. If you leave the ScreenTip text box blank, Access displays the hyperlink address as the ScreenTip.
10. In the Name of new document box, type a name for the page.

    Tip

    You can create a different type of document, for example, a Word file (.doc) or an Excel spreadsheet (.xls), by typing the three-letter file extension for the type of file you want to create. However, you can't create a Microsoft Access database (.mdb) or a Microsoft Access project (.adp).

11. Access creates the new page in the current folder. To specify a different location, click Change.
12. Click an option under When to edit. You can edit the new page immediately or wait until later.

To test the link, right-click the command button, point to Hyperlink on the shortcut menu, and then click Open.

1. Open a form in Design view.
2. If the Control Wizards tool in the toolbox is selected, click it to turn off the Control Wizard.
3. In the toolbox, click the Command Button tool .
4. On the form, click where you want to place the command button.
5. Make sure the command button is selected, and then click Properties on the toolbar to open the property sheet for the command button.
6. In the HyperlinkAddress property, click the Build button .
7. In the Insert Hyperlink dialog box, click Object in This Database under Link to.
8. In the Text to display box, type the display text for the hyperlink. Access automatically displays the value of the command button's Caption property in the box.
9. Click ScreenTip, and type the text you want to appear when the user rests the mouse pointer on the hyperlink. If you leave the ScreenTip text box blank, Access displays the hyperlink subaddress as the ScreenTip.
10. Click the database object you want to go to from the list.

To test the link, right-click the command button, point to Hyperlink on the shortcut menu, and then click Open.

Note  To link to an object in another database, select the desired database file and then click Bookmark to list the objects within that database.

1. Open a form in Design view.
2. If the Control Wizards tool in the toolbox is selected, click it to turn off the Control Wizard.
3. In the toolbox, click the Command Button tool .
4. On the form, click where you want to place the command button.
5. Make sure the command button is selected, and then click Properties on the toolbar to open the property sheet for the command button.
6. In the HyperlinkAddress property, click the Build button .
7. In the Insert Hyperlink dialog box, click E-mail Address under Link to.
8. In the Text to display box, type the display text for the hyperlink. Access automatically displays the value of the command button's Caption property in the box.
9. Click ScreenTip and type the text you want to appear when the user rests the mouse pointer on the hyperlink. If you leave the ScreenTip text box blank, Access displays the e-mail address as the ScreenTip.
10. In the E-mail address box, type an e-mail address, or click an address in the Recently used e-mail addresses list.
11. In the Subject box, type the information you want to appear in the Subject field of the e-mail message.

    Note  Some Web browsers and e-mail programs might not recognize the subject line.

To test the link, right-click the command button, point to Hyperlink on the shortcut menu, and click Open. When you click the hyperlink, Access opens your mail program and creates a new message, with the address and subject filled in.