Adding OLE objects to Access Table automatically

[Gary Stephens]

I have an application which has a form based on a filtered table which contains an OLEobject field. I know that I can take and drag and drop an object, like Word, or WinFax, into that field. I would like to automate the process of filling that table with a series of files contained in a given folder. But I can't find anything on how to do that.

And can I simply load them into the table automatically, regardless of extension (e.g. "doc", "fxr", "pcx", etc.) or do I need to give some information to Access (other than obviously the file extension) as to what OLE type I'm adding?

TIA,

Gary

 

[MHM]

Sorry, there is no way in Access of transferring OLE-Objects direct into fields of tables..
You need to open a form and put them in there in a OLE-object-field. There are some - but not many - commands for OLE-actions. But you can insert or copy any OLE-object automatically. Look up help for constants "acOLE..."

P.S.: Normally you really do not need to specify the object-class (Word/Excel/PDF/GIF...).

Mic

 

[Gary Stephens]

Mic,
Thanks for your reply. I was afraid that might be the case. That's really too bad. It really limits the usefulness of being able to put OLE info in a table.

Gary