[AccessD] Drew - TreeView help again, please

Hmmm, is Microsoft ActiveX Data Objects 2.5 available?

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tina Norris
Fields
Sent: Friday, April 24, 2009 8:40 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Drew - TreeView help again, please

Hi Drew,

I have these references checked, in this order
:
Visual Basic For Applications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.1 Library
Microsoft Windows Common Controls 6.0 (SP4)
Microsoft Visual Basic for Applications Extensibility 5.3
Microsoft ADO Ext. 2.8 for DDL and Security

Am I missing something here?  Thanks,
T


Drew Wutka wrote:
> Do you have the ADO reference selected?
>
> Drew
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tina Norris
> Fields
> Sent: Thursday, April 23, 2009 10:44 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Drew - TreeView help again, please
>
> Hi Drew,
>
> First of all, thank you very much for getting me started using the 
> TreeView control.  I can see that this will be very useful - but, I am

> still struggling to get my brain around it.
>
> I have very carefully worked through your code and made the name 
> adjustments I have to make to match up to my existing tables and 
> fields.  There are still a couple of places where I scratch my head
and 
> say "huh?" but for the most part I am finally understanding what you 
> have shared with me.  Thanks.
>
> Now, I have run into a runtime error that I don't understand and I
don't
>
> know how to handle.  When I select a volunteer from my combo 
> (cboVolunteers), I get this error message:
> ---------------------------------------
> Run-time error '-2147217904(80040e10)':
> No value given for one or more required parameters.
> ----------------------------------------
>
> When I click the Debug button, the line of code that is highlighted
is:
>
------------------------------------------------------------------------
> -------
> rs.Open strSQL, CurrentProject.Connection, adOpenKeyset,
adLockReadOnly
>
------------------------------------------------------------------------
> -------
>
> I have no idea at this point what is wrong.  Can you help me figure it
> out?
>
> Thanks,
> Tina
>   
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
The information contained in this transmission is intended only for the person or entity 
to which it is addressed and may contain II-VI Proprietary and/or II-VI Business 
Sensitive material. If you are not the intended recipient, please contact the sender 
immediately and destroy the material in its entirety, whether electronic or hard copy. 
You are notified that any review, retransmission, copying, disclosure, dissemination, 
or other use of, or taking of any action in reliance upon this information by persons 
or entities other than the intended recipient is prohibited.