RE: Object Variable not set

I would suspect it is nothing to do with MySQL or MyODBC. It is most likely an error in your VBA code. You have an object reference variable which does not point to an object and you tried to use one of its methods or properties.

John Bonnett 

-----Original Message-----
From: Kevin Harrison [mailto:[email protected]] 
Sent: Wednesday, 11 June 2008 11:03 PM
To: [email protected]
Subject: Object Variable not set

Hi,

 

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 procedure.

 

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

!"§§§Mobile=

*: + 44 (0)1707 312835

* [email protected] <mailto:[email protected]> 

 


T-Mobile (UK) Limited
Company Registered Number: 02382161
Registered Office Address: Hatfield Business Park, Hatfield, Hertfordshire, AL10 9BW Registered in England and Wales
 
NOTICE AND DISCLAIMER
 
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.

-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]