Max Wanadoo
max.wanadoo at gmail.com
Tue Sep 1 07:55:09 CDT 2009
>I still can't believe I was trying to stick a text value into an integer field, Don't fret, Tina. This is a common mistake amongst newbies - ducks and runs. max On 9/1/09, Tina Norris Fields <tinanfields at torchlake.com> wrote: > Drew, thanks very much for your help and your full explanation. I still > can't believe I was trying to stick a text value into an integer field, > but I'm glad you caught that. Your additional explanations are making > it possible for me to actually use the TreeView control. Thanks again > and again and again and . . . . . > T > > Drew Wutka wrote: >> No problem. I just sent you the fix off list. Correcting this >> particular error showed two more issues which I fixed too. >> >> Ironically, the issue wasn't technically a treeview issue. However it >> did relate to how I personally use treeviews (so my example used this >> method). The nodes of a treeview have to have a unique key. So if you >> have ten thousand nodes, each node 'key' must have unique to the other >> 9,999 nodes. With a table, you would use an Autonumber, however, with a >> treeview branching out, I will use a 'natural' key of sorts, which makes >> the node key more meaningful (and useful in later code). >> >> For example, let's take names: >> >> 1 Bob >> 2 Dave >> 3 Tina >> 4 Drew >> >> The numbers being the ID (autonumber field) from a table. If we were to >> make a set of 'root' or top level nodes with these names, I would use >> the following as the key for that node(without the quotes): 'ID:1' >> (which would be for the 'Bob' node, 'ID:3' for the Tina node, etc. >> >> Now if I want to include children nodes to the top level nodes, let's >> have a table of pets: >> >> 1 Dog(s) >> 2 Cat(s) >> 3 Fish >> 4 Birds >> 5 Other >> >> This data would be recorded in a PersonID PetID table, like this: >> >> 1 1 >> 1 3 >> 4 2 >> 4 3 >> >> So I would set the children nodes, to use the following Key (without the >> quotes) 'ID:1:1' or 'ID:4:3' >> >> So the data above would look like this in a treeview (and I will put the >> node keys in parenthesis) >> >> Bob (ID:1) >> --Dog(s)(ID:1:1) >> --Fish(ID:1:3:) >> Dave (ID:2) >> Tina (ID:3) >> Drew (ID:4) >> --Cat(s) (ID:4:2) >> --Fish (ID:4:3) >> >> The advantage of using 'natural' keys like this in a node, is that you >> can interact with a node in a few ways (clicking, dragging, etc.) and >> when you do so, you will have a node object, WITH a Key. So by making >> the key relevant to what the node actually represents (while maintaining >> it's uniqueness) we can actually infer at least two critical pieces of >> information by Split()ing the Key property into an Array(). One, in >> this case, we know that if the Ubound of the split is 2, it's a top >> level node, and thus a Person, if it's 3, then it's a 'pet' node. In >> VB, where I typically use Treeviews, it's very easy to have dynamic >> popup menus, so this ability of determining what type of node is being >> 'right clicked' allows me to popup different 'defined' menus. The other >> piece of information is the key value to retrieve data (or set data) in >> the original tables. >> >> I didn't put all this in the offlist email, but I figured I'd explain it >> a bit in case anyone is playing around with Treeviews. >> >> Drew >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tina Norris >> Fields >> Sent: Monday, August 31, 2009 3:36 PM >> To: Access Developers discussion and problem solving >> Subject: Re: [AccessD] Drew - Help on TreeView Please >> >> Thanks, I've sent it to you off-list via YouSendIt. I really appreciate >> >> your help. >> T >> >> Drew Wutka wrote: >> >>> Sure, send it too me. I'll look at it when I get the chance. >>> >>> Drew >>> >>> -----Original Message----- >>> From: accessd-bounces at databaseadvisors.com >>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tina Norris >>> Fields >>> Sent: Monday, August 31, 2009 8:32 AM >>> To: Access Developers discussion and problem solving >>> Subject: [AccessD] Drew - Help on TreeView Please >>> >>> Hi Drew, >>> >>> After running into a number of frustrations working on the TreeView, I >>> >> >> >>> set it aside for a few months. Now, I've come back to working on it. >>> >>> Thanks very much for the example database you made. It works >>> >> perfectly, >> >>> so I used your code as a basis to build a practice database. >>> >>> I am running into a runtime error >>> "Run-time error '-2147217904(80040e10)': >>> No value given for one or more required parameters." >>> >> 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. >> >> >> > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >