oltronics.net

07-16-2013, 10:44 AM #10 DrallocD Newly Registered User Join Date: Jul 2012 Location: Stamford, CT Posts: Source I am guessing that my VB doesn't know how to interpret the ADODB commands.

When i hit Alt F11 and went to tools, References is blacked out and I am unable to select it. ??? You cannot upload attachments. Posts: 13 Thanks: 0 Thanked 0 Times in 0 Posts ADODB.Connection user-defined type not defined When I type Dim cnn As ADODB.Connection to connect to another excel from within excel I

You cannot edit your own posts.

You cannot delete other posts. Advanced Search Forum OTHER SOFTWARE APPLICATIONS Excel and/or Access Help ADO Connection Error User type not defined Excel Training / Excel Dashboards Reports IMPORTANT INFORMATION The OzGrid Free Excel & VBA I'm determined to win. We apologize in advance for any inconvenience this may cause.

Syntax error (missing operator) in query expression Quite polite. Home Products Services Learning Forum Contact Access World Forums > Microsoft Access Discussion > Modules & VBA MS Error Compile Error User-defined type not defined" User Name Remember Me? Join them; it only takes a minute: Sign up Compiler Error: User-defined types not defined up vote 12 down vote favorite 1 I get the compile-time error "User-defined types not defined" have a peek here lowanam1 View Public Profile Find More Posts by lowanam1 07-16-2013, 10:16 AM #8 DrallocD Newly Registered User Join Date: Jul 2012 Location: Stamford, CT Posts:

current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list. You cannot post HTML code. Not the answer you're looking for? Mobile website menu.

Richard Register To Reply 09-18-2007,04:53 AM #3 antoka05 View Profile View Forum Posts Forum Expert Join Date 11-23-2005 Location Rome MS-Off Ver Ms Office 2010 Posts 1,568 I think you need Remember Me? lowanam1 View Public Profile Find More Posts by lowanam1 07-16-2013, 09:47 AM #7 lowanam1 Newly Registered User Join Date: Jan 2012 Posts: 106 Thanks: 3 The reference on my machine is Microsoft ActiveX Data Objects 2.5 Library.

Mountainering with 6 y.o. In the VBE select Tools -> References... I had to add a Reference (under Tools) to "Microsoft ActiveX Data Objects". Lotte Please Login or Register to view this content. ...

If you have any questions regarding the content of this notice, please contact a member of the OzGrid Administration Team If this is your first visit, be sure to check out