Tuesday, July 29, 2014

How To Linking to an Object in a Database in Access 2003

You can create hyperlinks that target forms, tables, and reports within the current database. You can also link to objects in other databases by specifying the database's file name and selecting the form, table, or report you want to target. You will have immediate access to those objects by clicking the hyperlink you insert.

Link to a Database Object in the Database

graphics/1_icon.jpg
Within a Hyperlink field or while editing a form or report in Design view, click the Insert Hyperlink button on the Design toolbar.
graphics/2_icon.jpg
Click Object In This Database on the Link To bar.
graphics/3_icon.jpg
Enter the hyperlink text.
graphics/4_icon.jpg
Select the database object.
graphics/5_icon.jpg
Click OK.
graphics/10inf03.jpg

Link to an Object in Another Database

graphics/1_icon.jpg
Within a Hyperlink field or while editing a form or report in Design view, click the Insert Hyperlink button on the Design toolbar.
graphics/2_icon.jpg
Click Existing File Or Web Page on the Link To bar.
graphics/3_icon.jpg
Enter the hyperlink text.
graphics/4_icon.jpg
Enter the database file name or click Browse to locate and select a database file name.
graphics/5_icon.jpg
Click Bookmark.
graphics/6_icon.jpg
Select the database object.
graphics/7_icon.jpg
Click OK.
graphics/8_icon.jpg
Click OK.
graphics/10inf04.jpg