OLE Object and Attachments (1 Viewer)

[khurram7x]

How possibly I'm gonna use OLE Object field to attach files like Word, Excel or PDF documents please??
I've tried to search over the internet but only thing I could find is to attach an image file using OLE Object, but I could not find decent source to demonstrate how to attach other file types.

I am required to use OLE Object because of SQL Server back-end.

Thanks,
K

 

[Ranman256]

I dont know if SQL server can. Normally these would all attach into an Attachment field, and load all the docs you want.

An OLE field may hold only 1, and youd put the table field on the form with a control. (drag the OLE field onto the form)
then when the user is viewing the form, he'd right click on the OLE box, INSERT OBJECT,
pick the file to insert.