Run time error 2766

[KerryL]

I've been receiving this error message out of my SQL code but I don't understand what it means.

Run-time error 2766:
The object doesn't contain the Automation object 'none'.


Can someone explain this one to me?

Thank you

 

[tlbroadbent]

Please post your SQL code. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[KerryL]

When I receive the error and go to debug mode, it points me to the Case Else statement in the Case Select code below. It's in an event procedure for a cmdSend on Click button.


Select Case .Fields("FYI_RFI&quot
'Send message
Case True 'FYI status = bcc to supvr and OCG supvr
DoCmd.SendObject acSendNoObject, , acFormatRTF, _
To:=strTo, _
Bcc:=strCC & ";" & DLookup("OCGEmail", "tblGenlInfo&quot, _
Subject:="Procurement Card Findings", _
MessageText:=DLookup("FYIText", "tblGenlInfo&quot & strMsg, _
EditMessage:=False

Case Else 'RFI status = cc to supvr & bcc to OCG supvr
DoCmd.SendObject acSendNoObject, , acFormatRTF, _
To:=strTo, _
Cc:=strCC, _
Bcc:=DLookup("OCGEmail", "tblGenlInfo&quot, _
Subject:="Procurement Card Findings", _
MessageText:=DLookup("RFIText", "tblGenlInfo&quot & strMsg, _
EditMessage:=False

End Select

 

[GingerR]

maybe it doesnt like the '=' signs? i've never used sendobject like this so i dont know, but here's an MS article that might help:

http://support.microsoft.com/suppor...object&rnk=2&src=DHCS_MSPSS_tech_SRCH&SPR=ACC

 

[tlbroadbent]

Ginger,

I wondered about the To:=, CC:=, etc. so I tried it and had no problems. I've not seen that format documented but it works. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.