Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to insert files into Access? ie; word documents etc.

Status
Not open for further replies.

needadvice

Programmer
Apr 7, 2002
145
US
I have an application in which the user needs to foward a record that includes attachments. This is new to me.
How is this done? I was able to create a form and insert a word document but I don't think this is good enough because it won't hold much information.
Any ideas on other ways to do this.
I'd appreciate any suggestions.
Thanks
 
If you want to store information you need to put it ultimately into a base table. Declare a field and give it the datatype "Object". You can now manipulate the contents (add, delete, edit) either by creating a new object within the Access mdb or by using a .doc elsewhere.

Create a form and drop an object control onto it. When you select it it will see the object is a .doc and fire up Word to let you do the editing. At the end choose "Close and retuen to Access" or whatever it is, and you've got your attached document.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top