Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

tables

ResolvedVersion 2003

Tables

Can you insert links (hyper) in records that will automatiaclly open the relevant file, e.g, last years accounts pdf.

RE: Tables

Hi Chris

The short asnswer is yes. To do this:

1. In the table's design view create the field and in the Data Type column select Hyperlink

2. Save the table

3. In the relevant data value area (either in the table or the form type in the ull pathe to the document (eg. Z:\Accounts\Accounts 2007.pdf)

4. The writing will appear in blue and underlined (hyperlinked). This also works from the net and e.mail

Hope this helps

Carlos

Access tip:

Remove spaces in a table

If you have a table that has too many space marks littered around, you can create a update query and use the trim function to get rid of any excess space marks

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.