Object Variable not set

"Kevin Harrison" <[email protected]>
Newsgroups gmane.comp.db.mysql.odbc
Message-ID <EEBF4CC0D2169E4EAAFB19F9037C0BD5817AE3@HATMSG031.TMOUSERSUK.AD.T-MOBILE.CO.UK>
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.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.