Treeview help--I just don't get it

Hi! I have the following SQL:
SELECT [Animal Records].ID AS RecordsID, [Animal Records].Date, [Animal
Records].KI, [Animal Records].[Animal Name]
FROM StaffTraining RIGHT JOIN [Animal Records] ON (StaffTraining.Animal =
[Animal Records].[Animal Name]) AND (StaffTraining.Keeper = [Animal
Records].KI)
WHERE ((([Animal Records].NT)=25) AND ((StaffTraining.Keeper) Is Null) AND
((StaffTraining.Animal) Is Null));

It returns records like so:
RecordsID Date KI Animal Name
76218 10/24/2008 JS Fern
76219 10/24/2008 JS Rowdy
76220 10/24/2008 JS Tahoma
76221 10/23/2008 TB Colby
76222 10/24/2008 TB Colby

I would like a treeview that shows:
*JS
--Fern
--Rowdy
--Tahoma
*TB
--Colby

But I just don't understand the treeview control at all. I understand you
have to right some code that you put in the OnLoad event of the form the
treeview control is on.
Could I get some help with the code?

Thanks!

I am not aware of a 'treeview control'... Using a Form one would do a Main
Form
for the KI and a subform for the Animal Name....

Using a Report; you could set this up using Sorting/Grouping.


"Clddleopard" wrote:

Hi! I have the following SQL:
SELECT [Animal Records].ID AS RecordsID, [Animal Records].Date, [Animal
Records].KI, [Animal Records].[Animal Name]
FROM StaffTraining RIGHT JOIN [Animal Records] ON (StaffTraining.Animal =
[Animal Records].[Animal Name]) AND (StaffTraining.Keeper = [Animal
Records].KI)
WHERE ((([Animal Records].NT)=25) AND ((StaffTraining.Keeper) Is Null) AND
((StaffTraining.Animal) Is Null));

It returns records like so:
RecordsID Date KI Animal Name
76218 10/24/2008 JS Fern
76219 10/24/2008 JS Rowdy
76220 10/24/2008 JS Tahoma
76221 10/23/2008 TB Colby
76222 10/24/2008 TB Colby

I would like a treeview that shows:
*JS
--Fern
--Rowdy
--Tahoma
*TB
--Colby

But I just don't understand the treeview control at all. I understand you
have to right some code that you put in the OnLoad event of the form the
treeview control is on.
Could I get some help with the code?

Thanks!

Treeview is advance coding. Have you looked at Form and subforms? If your
really interested in treeview and understand issues with using this control
you can look at,

http://support.microsoft.com/kb/209891
http://www.granite.ab.ca/access/familiesui.htm
http://msdn.microsoft.com/en-us/library/ms752302.aspx

Search google for other info.

I have used it for my menus, family trees but with the issues of trusted
locations, registering it, and a handful of other issues I'm have back to
native access and giving up on this control unless nothing else works. Now
it is really cool if you have the time to work it out.

"Clddleopard" wrote in message
...
Hi! I have the following SQL:
SELECT [Animal Records].ID AS RecordsID, [Animal Records].Date, [Animal
Records].KI, [Animal Records].[Animal Name]
FROM StaffTraining RIGHT JOIN [Animal Records] ON (StaffTraining.Animal =
[Animal Records].[Animal Name]) AND (StaffTraining.Keeper = [Animal
Records].KI)
WHERE ((([Animal Records].NT)=25) AND ((StaffTraining.Keeper) Is Null) AND
((StaffTraining.Animal) Is Null));

It returns records like so:
RecordsID Date KI Animal Name
76218 10/24/2008 JS Fern
76219 10/24/2008 JS Rowdy
76220 10/24/2008 JS Tahoma
76221 10/23/2008 TB Colby
76222 10/24/2008 TB Colby

I would like a treeview that shows:
*JS
--Fern
--Rowdy
--Tahoma
*TB
--Colby

But I just don't understand the treeview control at all. I understand you
have to right some code that you put in the OnLoad event of the form the
treeview control is on.
Could I get some help with the code?

Thanks!

The Treeview control is difficult to program. Unless you are advanced at
Visual Basic, I'd forget it.
If you cannot do without it, I have an example of a form containing a
treeview that allows the addition and deletion of notes and searching the
nodes.

-Dorian

"Clddleopard" wrote:

Hi! I have the following SQL:
SELECT [Animal Records].ID AS RecordsID, [Animal Records].Date, [Animal
Records].KI, [Animal Records].[Animal Name]
FROM StaffTraining RIGHT JOIN [Animal Records] ON (StaffTraining.Animal =
[Animal Records].[Animal Name]) AND (StaffTraining.Keeper = [Animal
Records].KI)
WHERE ((([Animal Records].NT)=25) AND ((StaffTraining.Keeper) Is Null) AND
((StaffTraining.Animal) Is Null));

It returns records like so:
RecordsID Date KI Animal Name
76218 10/24/2008 JS Fern
76219 10/24/2008 JS Rowdy
76220 10/24/2008 JS Tahoma
76221 10/23/2008 TB Colby
76222 10/24/2008 TB Colby

I would like a treeview that shows:
*JS
--Fern
--Rowdy
--Tahoma
*TB
--Colby

But I just don't understand the treeview control at all. I understand you
have to right some code that you put in the OnLoad event of the form the
treeview control is on.
Could I get some help with the code?

Thanks!

How disappointing. It looks so cool, I wish it weren't so hard to do. I guess
I'll just figure out a slightly less slick way of presenting the data.
Really, if microsoft would just allow forms with subforms to be set to
continuous, that would solve a lot of my problems. I guess I'll just use
macros to synchronize forms. Sigh...

"mscertified" wrote:

The Treeview control is difficult to program. Unless you are advanced at
Visual Basic, I'd forget it.
If you cannot do without it, I have an example of a form containing a
treeview that allows the addition and deletion of notes and searching the
nodes.

-Dorian

"Clddleopard" wrote:

Hi! I have the following SQL:
SELECT [Animal Records].ID AS RecordsID, [Animal Records].Date, [Animal
Records].KI, [Animal Records].[Animal Name]
FROM StaffTraining RIGHT JOIN [Animal Records] ON (StaffTraining.Animal =
[Animal Records].[Animal Name]) AND (StaffTraining.Keeper = [Animal
Records].KI)
WHERE ((([Animal Records].NT)=25) AND ((StaffTraining.Keeper) Is Null) AND
((StaffTraining.Animal) Is Null));

It returns records like so:
RecordsID Date KI Animal Name
76218 10/24/2008 JS Fern
76219 10/24/2008 JS Rowdy
76220 10/24/2008 JS Tahoma
76221 10/23/2008 TB Colby
76222 10/24/2008 TB Colby

I would like a treeview that shows:
*JS
--Fern
--Rowdy
--Tahoma
*TB
--Colby

But I just don't understand the treeview control at all. I understand you
have to right some code that you put in the OnLoad event of the form the
treeview control is on.
Could I get some help with the code?

Thanks!

Perhaps a Flex Grid Control will do what you want but you will still
need to write a bit of VBA code, have a look at my Flex Grid Demo
program for some examples.

Go to http://www.rogersaccesslibrary.com/f...ts.asp?TID=180

HTH

Peter Hibbs.


On Tue, 28 Oct 2008 18:36:00 -0700, Clddleopard
wrote:

How disappointing. It looks so cool, I wish it weren't so hard to do. I guess
I'll just figure out a slightly less slick way of presenting the data.
Really, if microsoft would just allow forms with subforms to be set to
continuous, that would solve a lot of my problems. I guess I'll just use
macros to synchronize forms. Sigh...

"mscertified" wrote:

The Treeview control is difficult to program. Unless you are advanced at
Visual Basic, I'd forget it.
If you cannot do without it, I have an example of a form containing a
treeview that allows the addition and deletion of notes and searching the
nodes.

-Dorian

"Clddleopard" wrote:

Hi! I have the following SQL:
SELECT [Animal Records].ID AS RecordsID, [Animal Records].Date, [Animal
Records].KI, [Animal Records].[Animal Name]
FROM StaffTraining RIGHT JOIN [Animal Records] ON (StaffTraining.Animal =
[Animal Records].[Animal Name]) AND (StaffTraining.Keeper = [Animal
Records].KI)
WHERE ((([Animal Records].NT)=25) AND ((StaffTraining.Keeper) Is Null) AND
((StaffTraining.Animal) Is Null));

It returns records like so:
RecordsID Date KI Animal Name
76218 10/24/2008 JS Fern
76219 10/24/2008 JS Rowdy
76220 10/24/2008 JS Tahoma
76221 10/23/2008 TB Colby
76222 10/24/2008 TB Colby

I would like a treeview that shows:
*JS
--Fern
--Rowdy
--Tahoma
*TB
--Colby

But I just don't understand the treeview control at all. I understand you
have to right some code that you put in the OnLoad event of the form the
treeview control is on.
Could I get some help with the code?

Thanks!

Firstly, unlike the others, I wouldn't recommend against the treeview so
quickly. Yes, it does take some programming and yes, it's NOT as intuitive as
the native access controls, but it's NOT impossible to learn and once you
gain an understanding of it, you've:
1) Got a good tool that you'll find other uses for
2) Expanded your skill set, which is always worth the effort.

Having said that, depending on your timeline, I'd go with what you know for
now to accomplish you task, but pursue the treeview on the side.

Secondly, your comment about MS not allowing subforms in continuous view is
a misnomer. Yes, the access subform wizard says you can't do it, and
technically it is correct, IF you want the subform on the detail section of
the main form.
However, simply place your subform in the footer section of your main form
and accept the wizard telling you that the main form will be switched to
single form. Once the subform is sized and in the footer, then in the
properties of the Main form, swithc it back to continuous form. Open the main
form and watch the "magic" happen. Actually it's not magic but it will you
that same feeling the first time you do it!

--
Dan Knight



"Clddleopard" wrote:

How disappointing. It looks so cool, I wish it weren't so hard to do. I guess
I'll just figure out a slightly less slick way of presenting the data.
Really, if microsoft would just allow forms with subforms to be set to
continuous, that would solve a lot of my problems. I guess I'll just use
macros to synchronize forms. Sigh...

"mscertified" wrote:

The Treeview control is difficult to program. Unless you are advanced at
Visual Basic, I'd forget it.
If you cannot do without it, I have an example of a form containing a
treeview that allows the addition and deletion of notes and searching the
nodes.

-Dorian

"Clddleopard" wrote:

Hi! I have the following SQL:
SELECT [Animal Records].ID AS RecordsID, [Animal Records].Date, [Animal
Records].KI, [Animal Records].[Animal Name]
FROM StaffTraining RIGHT JOIN [Animal Records] ON (StaffTraining.Animal =
[Animal Records].[Animal Name]) AND (StaffTraining.Keeper = [Animal
Records].KI)
WHERE ((([Animal Records].NT)=25) AND ((StaffTraining.Keeper) Is Null) AND
((StaffTraining.Animal) Is Null));

It returns records like so:
RecordsID Date KI Animal Name
76218 10/24/2008 JS Fern
76219 10/24/2008 JS Rowdy
76220 10/24/2008 JS Tahoma
76221 10/23/2008 TB Colby
76222 10/24/2008 TB Colby

I would like a treeview that shows:
*JS
--Fern
--Rowdy
--Tahoma
*TB
--Colby

But I just don't understand the treeview control at all. I understand you
have to right some code that you put in the OnLoad event of the form the
treeview control is on.
Could I get some help with the code?

Thanks!

I didn't recommend against it, just that it is advanced. I also provided
example sites any one of which will provide a good jumping off point. In
all truth my problems were more with dealing with the control, registering
it and such which in many situations that I deal with causes it to just not
be worth it. Fact is once you build one you can use that as a jumping off
point for many others but if your going to deploy it to other systems you
need to know the issues. Your suggestion to look at timelines and get
something going first is great, then play with making the treeview to dress
it up. Lots of samples with code are available by searching Google. From
the OP first post I thought that knowing what your getting into was
important. Nothing said give it up...I even included a end note, if you
have time to work it out.

"Dan Knight" wrote in message
...
Firstly, unlike the others, I wouldn't recommend against the treeview so
quickly. Yes, it does take some programming and yes, it's NOT as intuitive
as
the native access controls, but it's NOT impossible to learn and once you
gain an understanding of it, you've:
1) Got a good tool that you'll find other uses for
2) Expanded your skill set, which is always worth the effort.

Having said that, depending on your timeline, I'd go with what you know
for
now to accomplish you task, but pursue the treeview on the side.

Secondly, your comment about MS not allowing subforms in continuous view
is
a misnomer. Yes, the access subform wizard says you can't do it, and
technically it is correct, IF you want the subform on the detail section
of
the main form.
However, simply place your subform in the footer section of your main form
and accept the wizard telling you that the main form will be switched to
single form. Once the subform is sized and in the footer, then in the
properties of the Main form, swithc it back to continuous form. Open the
main
form and watch the "magic" happen. Actually it's not magic but it will
you
that same feeling the first time you do it!

--
Dan Knight



"Clddleopard" wrote:

How disappointing. It looks so cool, I wish it weren't so hard to do. I
guess
I'll just figure out a slightly less slick way of presenting the data.
Really, if microsoft would just allow forms with subforms to be set to
continuous, that would solve a lot of my problems. I guess I'll just use
macros to synchronize forms. Sigh...

"mscertified" wrote:

The Treeview control is difficult to program. Unless you are advanced
at
Visual Basic, I'd forget it.
If you cannot do without it, I have an example of a form containing a
treeview that allows the addition and deletion of notes and searching
the
nodes.

-Dorian

"Clddleopard" wrote:

Hi! I have the following SQL:
SELECT [Animal Records].ID AS RecordsID, [Animal Records].Date,
[Animal
Records].KI, [Animal Records].[Animal Name]
FROM StaffTraining RIGHT JOIN [Animal Records] ON
(StaffTraining.Animal =
[Animal Records].[Animal Name]) AND (StaffTraining.Keeper = [Animal
Records].KI)
WHERE ((([Animal Records].NT)=25) AND ((StaffTraining.Keeper) Is
Null) AND
((StaffTraining.Animal) Is Null));

It returns records like so:
RecordsID Date KI Animal Name
76218 10/24/2008 JS Fern
76219 10/24/2008 JS Rowdy
76220 10/24/2008 JS Tahoma
76221 10/23/2008 TB Colby
76222 10/24/2008 TB Colby

I would like a treeview that shows:
*JS
--Fern
--Rowdy
--Tahoma
*TB
--Colby

But I just don't understand the treeview control at all. I understand
you
have to right some code that you put in the OnLoad event of the form
the
treeview control is on.
Could I get some help with the code?

Thanks!

Thanks for all the info! The subform trick is new to me. I'll have to try it.
One of the example sites has really helped me, and I'm close to getting it.
It is always good to gain a new skill.
Thanks everyone!

"Pete D." wrote:

I didn't recommend against it, just that it is advanced. I also provided
example sites any one of which will provide a good jumping off point. In
all truth my problems were more with dealing with the control, registering
it and such which in many situations that I deal with causes it to just not
be worth it. Fact is once you build one you can use that as a jumping off
point for many others but if your going to deploy it to other systems you
need to know the issues. Your suggestion to look at timelines and get
something going first is great, then play with making the treeview to dress
it up. Lots of samples with code are available by searching Google. From
the OP first post I thought that knowing what your getting into was
important. Nothing said give it up...I even included a end note, if you
have time to work it out.

"Dan Knight" wrote in message
...
Firstly, unlike the others, I wouldn't recommend against the treeview so
quickly. Yes, it does take some programming and yes, it's NOT as intuitive
as
the native access controls, but it's NOT impossible to learn and once you
gain an understanding of it, you've:
1) Got a good tool that you'll find other uses for
2) Expanded your skill set, which is always worth the effort.

Having said that, depending on your timeline, I'd go with what you know
for
now to accomplish you task, but pursue the treeview on the side.

Secondly, your comment about MS not allowing subforms in continuous view
is
a misnomer. Yes, the access subform wizard says you can't do it, and
technically it is correct, IF you want the subform on the detail section
of
the main form.
However, simply place your subform in the footer section of your main form
and accept the wizard telling you that the main form will be switched to
single form. Once the subform is sized and in the footer, then in the
properties of the Main form, swithc it back to continuous form. Open the
main
form and watch the "magic" happen. Actually it's not magic but it will
you
that same feeling the first time you do it!

--
Dan Knight



"Clddleopard" wrote:

How disappointing. It looks so cool, I wish it weren't so hard to do. I
guess
I'll just figure out a slightly less slick way of presenting the data.
Really, if microsoft would just allow forms with subforms to be set to
continuous, that would solve a lot of my problems. I guess I'll just use
macros to synchronize forms. Sigh...

"mscertified" wrote:

The Treeview control is difficult to program. Unless you are advanced
at
Visual Basic, I'd forget it.
If you cannot do without it, I have an example of a form containing a
treeview that allows the addition and deletion of notes and searching
the
nodes.

-Dorian

"Clddleopard" wrote:

Hi! I have the following SQL:
SELECT [Animal Records].ID AS RecordsID, [Animal Records].Date,
[Animal
Records].KI, [Animal Records].[Animal Name]
FROM StaffTraining RIGHT JOIN [Animal Records] ON
(StaffTraining.Animal =
[Animal Records].[Animal Name]) AND (StaffTraining.Keeper = [Animal
Records].KI)
WHERE ((([Animal Records].NT)=25) AND ((StaffTraining.Keeper) Is
Null) AND
((StaffTraining.Animal) Is Null));

It returns records like so:
RecordsID Date KI Animal Name
76218 10/24/2008 JS Fern
76219 10/24/2008 JS Rowdy
76220 10/24/2008 JS Tahoma
76221 10/23/2008 TB Colby
76222 10/24/2008 TB Colby

I would like a treeview that shows:
*JS
--Fern
--Rowdy
--Tahoma
*TB
--Colby

But I just don't understand the treeview control at all. I understand
you
have to right some code that you put in the OnLoad event of the form
the
treeview control is on.
Could I get some help with the code?

Thanks!