Veelgestelde vragen voor zelfhulp.

Bekijk snel de veelgestelde vragen (en antwoorden) in de standaardlijst. Als u niet kunt vinden wat u zoekt, begin dan met het selecteren van uw Ability Office -versie en verfijn deze dan door zoektekst en/of categorie in te voeren.

Kennisbank artikel 82

Creating a database of hyperlinks

Suppose you want to use database to store information that has some associated external file or image or web site.

You can use a database field to store the location of the external file and the use the HYPERLINK function to provide a connection to the file.

Here's how to do it:

  1. Start Database and open (or create a new) database
  2. Select File/New/Table
  3. Select Blank table
  4. Create four fields:
    hpathCharacterClick Format and set Width to 255
    hlinkCalculatedClick Format and set Formula to:
    =HYPERLINK(hpath, htitle)
  5. Save the table

Now, whatever you type into the hpath field can be loaded when in form view. For example, suppose you have an image stored in My Documents called photo1.jpg, then set:
htitle: Photo1
hpath: C:\Documents and Settings\Phil\My Documents\photo1.jpg
Description: Holiday snap

Open the table in Form view (e.g. click on the View Form button) and click on the link "Photo1". The image will be loaded in your default jpg editor (Ability Photopaint would work well).

In the same way, you can link to folders, web sites, word processing files - anything that Windows Explorer can understand can be used in a hyperlink.

For an example database, take a look at HYPERLINKS.ADB (version 4 only).