469,286 Members | 2,442 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,286 developers. It's quick & easy.

Tree View

A2003, XP Pro.

My client wants to navigate around his db forms using a "Tree View". As
far as I know there's no such utility in Access 2003 - are there any
reliable 3rd party plug-ins that any of you have used to any degree of
success?

I've always been a bit wary of plug-ins. The last one I had to deal with
silently disabled the 'filter by form' function.

Many thanks for any recommendations.

Keith.
www.keithwilby.com
Nov 13 '05 #1
13 15131
"Keith" <ke***@NOCARPkeithwilby.org.uk> wrote in message
news:cv**********@sparta.btinternet.com...
A2003, XP Pro.

My client wants to navigate around his db forms using a "Tree View". As
far as I know there's no such utility in Access 2003 - are there any
reliable 3rd party plug-ins that any of you have used to any degree of
success?

I've always been a bit wary of plug-ins. The last one I had to deal with
silently disabled the 'filter by form' function.

Many thanks for any recommendations.

Keith.
www.keithwilby.com

If you can live with it's limitations you can fake a treeview using a
regular list box, a union query and a little code. Screen shot here:
http://www.assaynet.com/downloads/access/treeview.jpg

Sample database here:
http://www.assaynet.com/downloads/access/treeview.mdb
Some limitations:-
- no programmatic access to individual nodes
- no images
- no drag and drop
Not having to use activex controls . . . priceless :-)


Nov 13 '05 #2
The screenshot looks very interesting. Is there a version of the download
for Access 2000.

Thanks

Phil

"John Winterbottom" <as******@hotmail.com> wrote in message
news:38*************@individual.net...
"Keith" <ke***@NOCARPkeithwilby.org.uk> wrote in message
news:cv**********@sparta.btinternet.com...
A2003, XP Pro.

My client wants to navigate around his db forms using a "Tree View". As
far as I know there's no such utility in Access 2003 - are there any
reliable 3rd party plug-ins that any of you have used to any degree of
success?

I've always been a bit wary of plug-ins. The last one I had to deal with
silently disabled the 'filter by form' function.

Many thanks for any recommendations.

Keith.
www.keithwilby.com

If you can live with it's limitations you can fake a treeview using a
regular list box, a union query and a little code. Screen shot here:
http://www.assaynet.com/downloads/access/treeview.jpg

Sample database here:
http://www.assaynet.com/downloads/access/treeview.mdb
Some limitations:-
- no programmatic access to individual nodes
- no images
- no drag and drop
Not having to use activex controls . . . priceless :-)



Nov 13 '05 #3
Assuming you've got it (say from Visual Basic), you can use the standard
Microsoft Treeview that's part of mscomctl.ocx.

Check
http://msdn.microsoft.com/library/en...bjtreeview.asp for
details.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Keith" <ke***@NOCARPkeithwilby.org.uk> wrote in message
news:cv**********@sparta.btinternet.com...
A2003, XP Pro.

My client wants to navigate around his db forms using a "Tree View". As
far as I know there's no such utility in Access 2003 - are there any
reliable 3rd party plug-ins that any of you have used to any degree of
success?

I've always been a bit wary of plug-ins. The last one I had to deal with
silently disabled the 'filter by form' function.

Many thanks for any recommendations.

Keith.
www.keithwilby.com

Nov 13 '05 #4
"Phil Stanton" <ph******@xxstantonfamily.co.uk> wrote in message
news:42***********************@ptn-nntp-reader04.plus.net...
The screenshot looks very interesting. Is there a version of the download
for Access 2000.

Thanks

Phil


Sure, here it is:

http://www.assaynet.com/downloads/access/treeview2k.mdb
Nov 13 '05 #5
rkc
John Winterbottom wrote:
If you can live with it's limitations you can fake a treeview using a
regular list box, a union query and a little code. Screen shot here:
http://www.assaynet.com/downloads/access/treeview.jpg

Sample database here:
http://www.assaynet.com/downloads/access/treeview.mdb


Interesting idea.
Nov 13 '05 #6
On Sun, 27 Feb 2005 18:50:26 -0500, "John Winterbottom"
<as******@hotmail.com> wrote:
"Phil Stanton" <ph******@xxstantonfamily.co.uk> wrote in message
news:42***********************@ptn-nntp-reader04.plus.net...
The screenshot looks very interesting. Is there a version of the download
for Access 2000.

Thanks

Phil


Sure, here it is:

http://www.assaynet.com/downloads/access/treeview2k.mdb


John,

I bet you can anticipate the next question or two.......

Is there anything relied upon which is unavailable through A97? If
so, is there an A97 version?

Thanks

mike

Nov 13 '05 #7
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote:
Assuming you've got it (say from Visual Basic), you can use the
standard Microsoft Treeview that's part of mscomctl.ocx.

Check
http://msdn.microsoft.com/library/en...bjtreeview.asp
for details.


I'll check that out, thanks Doug.
Nov 13 '05 #8
"John Winterbottom" <as******@hotmail.com> wrote:
"Phil Stanton" <ph******@xxstantonfamily.co.uk> wrote in message
news:42***********************@ptn-nntp-reader04.plus.net...
The screenshot looks very interesting. Is there a version of the
download for Access 2000.

Thanks

Phil


Sure, here it is:

http://www.assaynet.com/downloads/access/treeview2k.mdb


Many thanks John, I'll take a look at that. :o)
Nov 13 '05 #9
Thanks

Brilliant

Phil
"Phil Stanton" <ph******@xxstantonfamily.co.uk> wrote in message
news:42***********************@ptn-nntp-reader04.plus.net...
The screenshot looks very interesting. Is there a version of the download
for Access 2000.

Thanks

Phil

"John Winterbottom" <as******@hotmail.com> wrote in message
news:38*************@individual.net...
"Keith" <ke***@NOCARPkeithwilby.org.uk> wrote in message
news:cv**********@sparta.btinternet.com...
A2003, XP Pro.

My client wants to navigate around his db forms using a "Tree View". As
far as I know there's no such utility in Access 2003 - are there any
reliable 3rd party plug-ins that any of you have used to any degree of
success?

I've always been a bit wary of plug-ins. The last one I had to deal with
silently disabled the 'filter by form' function.

Many thanks for any recommendations.

Keith.
www.keithwilby.com

If you can live with it's limitations you can fake a treeview using a
regular list box, a union query and a little code. Screen shot here:
http://www.assaynet.com/downloads/access/treeview.jpg

Sample database here:
http://www.assaynet.com/downloads/access/treeview.mdb
Some limitations:-
- no programmatic access to individual nodes
- no images
- no drag and drop
Not having to use activex controls . . . priceless :-)




Nov 13 '05 #10
"Mike Preston" <mb******@pacbell.net.invalid> wrote in message
news:42***************@news.INDIVIDUAL.NET...

I bet you can anticipate the next question or two.......

Is there anything relied upon which is unavailable through A97? If
so, is there an A97 version?

Thanks

mike


Hi Mike, the code should work fine in A97. Let me know if you want and I'll
put an access 97 version up there as well.

ps, I've started using this concept for more complex hierarchies, (up to 4
levels), the sql becomes a little more involved but it still works ok. Speed
is good. Adding new nodes is a challenge; you need to have a column in your
query to tell access what level you are on, so you can get back there when
you re-quer the list box.

I'll try and make an example with 'new', 'edit' 'delete' functionality.
Nov 13 '05 #11
On Mon, 28 Feb 2005 10:20:06 -0500, "John Winterbottom"
<as******@hotmail.com> wrote:
"Mike Preston" <mb******@pacbell.net.invalid> wrote in message
news:42***************@news.INDIVIDUAL.NET...

I bet you can anticipate the next question or two.......

Is there anything relied upon which is unavailable through A97? If
so, is there an A97 version?

Thanks

mike

Hi Mike, the code should work fine in A97. Let me know if you want and I'll
put an access 97 version up there as well.


I would very much like to look at it in A97.
ps, I've started using this concept for more complex hierarchies, (up to 4
levels), the sql becomes a little more involved but it still works ok. Speed
is good. Adding new nodes is a challenge; you need to have a column in your
query to tell access what level you are on, so you can get back there when
you re-quer the list box.
Sounds even more interesting.
I'll try and make an example with 'new', 'edit' 'delete' functionality.


I'm guessing that many will appreciate that.

Take care,

mike
Nov 13 '05 #12
Thanks for the info. Could it be adapted for form and report navigation?

Regards,
Keith.

John Winterbottom wrote:
"Keith" <ke***@NOCARPkeithwilby.org.uk> wrote in message
news:cv**********@sparta.btinternet.com...
A2003, XP Pro.

My client wants to navigate around his db forms using a "Tree View". As
far as I know there's no such utility in Access 2003 - are there any
reliable 3rd party plug-ins that any of you have used to any degree of
success?

If you can live with it's limitations you can fake a treeview using a
regular list box, a union query and a little code. Screen shot here:
http://www.assaynet.com/downloads/access/treeview.jpg

Sample database here:
http://www.assaynet.com/downloads/access/treeview.mdb
Some limitations:-
- no programmatic access to individual nodes
- no images
- no drag and drop
Not having to use activex controls . . . priceless :-)



Nov 13 '05 #13
On Sun, 27 Feb 2005 21:35:25 +0200, John Winterbottom wrote
(in message <38*************@individual.net>):
If you can live with it's limitations you can fake a treeview using a
regular list box, a union query and a little code. Screen shot here:
http://www.assaynet.com/downloads/access/treeview.jpg


I'm a bit late on this topic (didn't read cdma the last 2 months)
but I recently wrote an (ugly) prototype of something similar.

If someone's interested:

<http://homepage.mac.com/micih>
(db15.zip, an Acc97 database).

I did no deep tests because I had other things to work on lately.
Of course this is not ready for prime time, just a "study" what
could be possible with a ListControl as a fake TreeView.

I will probably post a better documented/more bug free version some
time...

The basic concept is a very ugly implementation of some kind of
"materialized path" for the outline structure.
Most of the code for moving nodes around is inside a class module.
(triggered by the buttons on the sample form.)

You can set the number of alowed outline levels and the max. number
of entries per level (the demo uses 4 levels and a maximum of 99
entries per level). The Key-Field (string) must be adjusted if
you want to change this.
(For 4/2 the key length is 8, i.e entry 1.2 is 01020000).

The whole code is probably too slow for very big outlines...

The outline/tree-structure is kept in a separate table.
It's possible to use the whole parent Outliner-Table (see
example form) or only a restricted set: This was implemented
because the original motivation for the whole thing was
a database for meetings.

Meetings<--1toMany-->Topics<--1to1-->OutliningStructure

It is possible then to work only with topics of specicif meetings
by setting the appropriate restrict Parameter (see Class_Init).

And there is also code to get the path to a specific entry with
a delimiter like "->" (i.e. Computers->Portables->IBM->Thinkpads).

Mike

Nov 13 '05 #14

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by imani_technology_spam | last post: by
reply views Thread by Tree menu using XML | last post: by
1 post views Thread by Jesper DK | last post: by
3 posts views Thread by Saradhi | last post: by
10 posts views Thread by dwok | last post: by
3 posts views Thread by gmail | last post: by
1 post views Thread by happy.john1234 | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.