List:MySQL ODBC« Previous MessageNext Message »
From:Al McNicoll Date:June 11 2008 2:27pm
Subject:RE: Object Variable not set
View as plain text  
Dear Kev,

That sounds like a straight VBA error - the only way I could see it being
linked to MyODBC would be if MyODBC was returning an unusual value which led
to VBA running a different branch of code - can you post the code which
gives you the error? I imagine it might be something like

The VBA error means that an object variable (ie not just a string / number,
but an ADO connection or a comboBox control or something like that) is set
to Nothing, or that the code which assigns it is missing "Set" before the


Dim myRecordset As ADODB.Recordset
myRecordset.Open("SELECT 1",adStatic) ' This recordset is still "Nothing"


myRecordset = myCon.Execute("SELECT 1") ' This statement is missing the
initial "Set"
should read:
Set myRecordset = myCon.Execute("SELECT 1")

Hope that helps - if it is a VBA error, feel free to email me rather than
posting to the board.

Kind regards,

Al McNicoll
Integritec Limited

-----Original Message-----
From: Kevin Harrison [mailto:Kevin.Harrison@stripped] 
Sent: 11 June 2008 14:33
To: myodbc@stripped
Subject: Object Variable not set



I am using a MyODBC application database with a front end, which was
developed by a previous user at my organisation, who has since left.


It is using drop downs, within a form to set a date parameter for an import


There is one drop down for month and another for year.


When I use this form for all months upto and including April 2008, it is
functioning correctly, when I try to use this form for May 2008 however, I
am getting an error:


'Object variable Not set'.


I have seen this error before in VBA databases, and I am guessing this is
due to this variable not being declared somewhere in the set up code.


However, as I am unfamiliar with MyODBC, I am unsure where I should be
looking to correct this. Can you help at all?


Kind Regards,

Kev Harrison

Senior Commissions Consultant


*: + 44 (0)1707 312835

* kevin.harrison@stripped <mailto:kevin.harrison@stripped> 


T-Mobile (UK) Limited
Company Registered Number: 02382161
Registered Office Address: Hatfield Business Park, Hatfield, Hertfordshire,
AL10 9BW
Registered in England and Wales
This email (including attachments) is confidential. If you are not the
intended recipient, notify the sender immediately, delete this email from
your system and do not disclose or use for any purpose.

Object Variable not setKevin Harrison11 Jun
  • RE: Object Variable not setAl McNicoll11 Jun
  • RE: Object Variable not setJohn Bonnett12 Jun