• Adding an object to an input form (97)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Adding an object to an input form (97)

    Author
    Topic
    #438714

    I am creating a database for our HR department. They would like to attach a fax or pdf file to a record for an employee. When they enter the information into the table. Is this possible and how would I go about doing this?

    Thanks,

    Viewing 0 reply threads
    Author
    Replies
    • #1046754

      You have two options.

      1) OLE field
      – Add an OLE Object field to the table.
      – Add a Bound Object Frame to the data entry form, bound to the OLE Object field.
      – The user can select Insert | Object… or right-click the control and select Insert Object… to add a file.
      – The user can specify whether the object should be linked to the original file or not.

      2) Hyperlink field
      – Add a Hyperlink field to the table.
      – Add a text box bound to the Hyperlink field to the data entry form.
      – The user can select Insert | Hyperlink or right-click the text box and select Hyperlink | Edit Hyperlink.
      – The file will be opened in the application associated with it (fax viewer, Adobe Reader, …)

    Viewing 0 reply threads
    Reply To: Adding an object to an input form (97)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: