Reference Standard OLE types

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ade - 19 Jul 2007 13:20 GMT

I want to set a reference to 'Standard OLE types' (Access 97) but when I go
in to the Set Reference dialog there is no listing for 'Standard OLE Types',
does it come under a different name or will I need to download and install
the reference.

Reply to this Message

Stephen Lebans - 19 Jul 2007 14:02 GMT

On my system, OLE Automation:
C:\Windows\system32\stdole2.tlb

Signature

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

>I want to set a reference to 'Standard OLE types' (Access 97) but when I go
> in to the Set Reference dialog there is no listing for 'Standard OLE
> Types',
> does it come under a different name or will I need to download and
> install
> the reference.

Reply to this Message

Ade - 19 Jul 2007 14:56 GMT

Thanks for your help and the useful info on your website.

> On my system, OLE Automation:
> C:\Windows\system32\stdole2.tlb
[quoted text clipped - 5 lines]
> > install
> > the reference.

Reply to this Message

Ade - 19 Jul 2007 15:02 GMT

Stephen, although Access now accepts 'SavePicture' after referencing as you
suggested, I am getting an error message - 'Compile error, Expected: = '
My line of code is - SavePicture(obj,"C\SL11-52")

Reply to this Message

Ade - 19 Jul 2007 15:54 GMT

Please Ignore I put brackets where there should be none.

> Stephen, although Access now accepts 'SavePicture' after referencing as you
> suggested, I am getting an error message - 'Compile error, Expected: = '
> My line of code is - SavePicture(obj,"C\SL11-52")

Reply to this Message

Douglas J. Steele - 19 Jul 2007 15:59 GMT

Sounds as though SavePicture was defined as a function.

To use a function without worrying about what it returns, use either

Call SavePicture(obj,"C\SL11-52")

or

SavePicture obj, "C\SL11-52"

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Stephen, although Access now accepts 'SavePicture' after referencing as
> you
> suggested, I am getting an error message - 'Compile error, Expected: = '
> My line of code is - SavePicture(obj,"C\SL11-52")

Reply to this Message