Data Management

Use hyperlinks to open an Access database object without programming

You can add a control to your Access database without starting from scratch -- or without knowledge of programming. Here's an easy way to use a hyperlink instead of a command button.

Rather than add a command button to your form to open another object in your database, you can use a hyperlink. Using images, labels and command buttons as hyperlinks is an easy way to add a control that allows users to open and display an object without programming.

To create a hyperlink that opens the Product Categories List table from an unbound form in your database, follow these steps:

  1. Open a blank form in Design view.
  2. Place a Label control on the form.
  3. Type Click to display the Product Categories List to change the label's caption, then press Enter.
  4. Right-click Label and select Properties.
  5. Click in the Hyperlink SubAddress property in the Label property sheet.
  6. Click the Build button.
  7. Click the Object In This Database button.
  8. Click Tables.
  9. Click the Products Categories List, then click OK.

Note that instead of a label, you could also use a command button or image; just change its SubAddress property to the object's address.

Unlike command buttons, hyperlinks only allow you to open an object and move to a location within it. Any programming is limited to the control's on-click event.

Miss an Access tip?

Check out the Microsoft Access archive, and catch up on other Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

3 comments
Vitor Carvalho
Vitor Carvalho

Can you (or anyone) tell me if it's possible to address a specific record in a table (doing that from an hyperlink, of course)?

chuckoliver.hrc
chuckoliver.hrc

Because of the functionality limitations imposed on hyperlinks, I prefer to use command buttons to open objects within a database. There are, however, instances were I'll use hyperlinks to open another database. Specifically, I use a secondary database to retain data input changes from the primary database for audit purposes. Using this methodolgy also mitigates database size limitations.

hutchkl
hutchkl

I thought this was a great tip especially when I find myself writing numerous macros to handle this instead.