Unbound OLE object

G

Guest

Using the Action acOLECreateEmbed property with an Excel worksheet to an Unbound OLE object on a Form. VB executes fine (.class, .OLETypeAllowed, .SourceDoc statements working without errors). Then it halts at the OLE1.Action acOLECreateEmbed statement

Run-time error 2793... can't perform the operation specified in the Action property..

I hit debug and hover the cursor over the Action statement and read
"OLE1.Action = ...can't retrieve the value of this...

I have played around with what seems intuitive on the Property sheet, but couldn't get any further
 
G

Guest

No worries now. I examined the code a little closer and found I had missed the "ac" in "acOLEEmbedded". Also, the Action property was only recognized after I wrote "me.OLE1.Action"; I needed to have the "me." in front

Things are looking much better now.
 

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

Similar Threads

unbound OLE PDF Object in Access Report doesn't update 1
Importing PDF as Embedded OLE Object into Access Database 0
".wav" OLE object class name 1
Access 2003 Error 2749 3
Embed Word document in Access 0
Insert OLE object 1
Embeded Word document in Access 1
PDF files as OLE Unbound Object in Report 1

Top