Grouping Categories Like Sub-Datasheet 1

[perrymans]

I would like a selectable treeview, but realize that may be out of reach. So I was thinking instead...

I have a Guidance, with several sub categoriesL

Guidance 1
   Sub 1
   Sub 2
   Sub 3
Guidance 2
   Sub 4
   Sub 5

You know how when you open a table with a link, you get the + and - on the side and can expand the records? I want that same functionality.

The difference is, I need it in a form, and I have to add a checkbox so people can select their applicable Guidance and Sub categories.

Any ideas or existing solutions?

Thanks. Sean.

 

[MajP]

1)How about two continous subforms instead. The top lists categories and whatever Guidance you select, the bottom subform shows it's subs.
2)If you want a treeview, I can provide you a lot of treeview code. I have encapsulated most of the treeview code. Please provide your table names, primary and foriegn keys.

Can you explain the following in more detail
"I have to add a checkbox so people can select their applicable Guidance and Sub categories."

after they select these records, what happens?

 

[perrymans]

After selecting, the applicable test cases will be imported from Tbl_Check to Tbl_Project_{Project#}.

I have to do this because the constantly changing default checks, but the checks used against a particular project at a particular time have to be preserved.

I have an old trouble-ticket database with a treeview down the left, a ListView control on the top right, and a subform on the bottom right.

Perhaps I should do a format similar to that for viewing, but no, never mind, too compicated for just the selection process.

I guess in the absence of a selectable treeview, I the dual continuous forms would work.

I have plenty of treeview code, but I would love a 'Treeview Manager'. A structure where you can define treeviews and their contents based on information stored in a table and editable in a form.

If you have (or know of) that, that would be great.

Maybe I should make a seperate post just for that...

Thanks. Sean.

 

[MajP]

Not really sure what your question is. It sounds like what you are wanting to do can be done in many ways. I personally would use a tree view. In my treeviews I always include a Node click event that opens the selected record in an editable pop up form. I also have a lot of treeviews where the user checks certain records and then do some processing on the selected records.

You can also do this purely with dataheets and subdatasheets. Put an actual boolean field in the tables and use it to select or unselect records. Normally the process is something like
1) Clear out the "Selected" field using an update query
2) Open the datasheet view
3) Populate the "Selected" field based on information from some linked table
4) Close the form and do some query process with the records "Selected"
Or again use some

Or you can do this with 2 continous linked subforms and a similar idea as the subdatasheets.

Or use a multiselect list box to select and select the applicable records

There is no Treeview Manager that I know of. But there are only two ways to load a tree; either recursively or using multple related recordsets. Once you have done both types reusing the code is pretty simple. Basically change the names of your queries and the primary key field.

So decide your user interface and then post some specific questions. Include.
1. applicable tables and field
2. Any code
3. detailed description of how this interface should work.

 

[perrymans]

Here is a picture (low quality) of what I was hoping for in a treeview, selectable checkboxes.

http://media.techtarget.com/digitalguide/images/Misc/password_crack_4.jpg

I am not using for the same, bu you shoudl get the idea.

Thanks. Sean.

 

[MajP]

Yes that is a picture with a selectable treeview. And as I have said, yes you can do this with a treeview. Not sure what else you would like us to say. You have said that you have treeview code, but you do not know how to code a treeview. You have said you want other possibilities. So do you have a question or questions? What do you want to do? What do you need help on? What have your tried? What level of coding are you capable of? As you seem aware of, a treeview requires a good knowledge of vb code. Other solutions using native Acess controls exist, but may not provide the same level of functionality.

 

[perrymans]

MajP, although your last post was hardly helpful, it did make me wonder why you said 'yes you can do this with a treeview' (I didn't see this said earlier).

So I went to a treeview control (6.0) and look a the propeties. Sure enough, there is a new property in 6.0 that allows for checkboxes.

I did not realize this was added and now part of the default mscom.ctl control.

I should be good now.

Thanks. Sean.