Use Embedded OLE Oject via recordset

R

rogge

I want to open a *.dot file that has been embedded in a field for editing in
word. So how does one reference the file in a method similar to the
....documents.add method (this method looks for a file on the computer and not
in a table)...

Set rds = CurrentDb.OpenRecordset("tblAppTemplates")
' go to appropiate record
Set docWord = GetObject(rds!Fields("oleTemplate")) ' this line does not
function properly


Constraints
1) the embedded document can not change
2) the table can not be made un-updateable
3) the *.dot file must be in the database (i want to distribute one file,
not two)

Additional information
1)*.dot will be 'manually' stored in the table, this table will not
interface with a form

thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top