Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Hyperlinks (Access 97 SR2)

    I have a form in which I enter Quotation Details, Each detail has a number It contains about 700 records.
    and for each entry I have quotation in Office 97 Word I would like to hyperlink each record to open the document for viewing
    I have no idea how to go about this.

    Can anyone help please

    Thanks in Advance
    <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>
    If you are a fool at forty, you will always be a fool

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hyperlinks (Access 97 SR2)

    You will need to make a bookmark for each quotation in the Word document.

    Next, add a hyperlink field to the table that acts as record source of the form.

    When you right click the hyperlink field (in the table, or in a query or on the form), you can edit the hyperlink. In the upper box, enter or browse for the name of the Word document. In the second box (you can't browse here), enter the name of the appropriate bookmark.

    Wouldn't it be easier to put the quotations into the database?

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Hyperlinks (Access 97 SR2)

    Hi HansV

    I like the sound of your last sentence, but have tried to do this by copy and past into a memo or tex box, but includes all the formating as characters.

    Or am I doing it all wrong?

    Look forward to your reply
    If you are a fool at forty, you will always be a fool

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hyperlinks (Access 97 SR2)

    When you paste text from Word into a text or memo field, all formatting (bold, italic, fonts etc.) should be lost, but paragraph/line breaks should convert OK. If you want to keep the formatting, you might use an OLE field and insert the text as Word object into it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •