Software

Ask something
Discussion Locked

Need some help with access database

0 helpful
5 replies

by xsred70

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
can anyone tell me how to add a word document to an individual record within a database...have worked out how to add a word document but it applies it to all records, not just one???? HELP PLEASE.

5 replies

by leobloom

Add a field with a data type of OLE Object. After you will be able to select insert object on a any particular record

by sankulpune

Hello xsred70,

It seems you are attaching the document directly to a control on a form. Don't.

Create a field, as suggested by LeoBloom, of type 'OLE Object' but in the table. Create a query based on this table and base your report on this query.

Creating reports based on queries (and not directly on tables) is always simple, robust and hence the most preferable method in Access. It simplifies the design and maintenance of the form.

Hope this helps.

SanganakSakha,
Beyond Just Solutions.

This discussion is closed to new replies.