[AccessD] Drew - TreeView help again, please

Drew Wutka DWUTKA at Marlow.com
Thu Apr 23 11:41:17 CDT 2009


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.





More information about the AccessD mailing list