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,
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Adding an object to an input form (97)
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, …)
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.
Notifications