473,657 Members | 2,316 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 15382
"Keith" <ke***@NOCARPke ithwilby.org.uk > wrote in message
news:cv******** **@sparta.btint ernet.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******@hotma il.com> wrote in message
news:38******** *****@individua l.net...
"Keith" <ke***@NOCARPke ithwilby.org.uk > wrote in message
news:cv******** **@sparta.btint ernet.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***@NOCARPke ithwilby.org.uk > wrote in message
news:cv******** **@sparta.btint ernet.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******@xxsta ntonfamily.co.u k> wrote in message
news:42******** *************** @ptn-nntp-reader04.plus.n et...
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******@hotma il.com> wrote:
"Phil Stanton" <ph******@xxsta ntonfamily.co.u k> wrote in message
news:42******* *************** *@ptn-nntp-reader04.plus.n et...
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_djsteel e@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******@hotma il.com> wrote:
"Phil Stanton" <ph******@xxsta ntonfamily.co.u k> wrote in message
news:42******** *************** @ptn-nntp-reader04.plus.n et...
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******@xxsta ntonfamily.co.u k> wrote in message
news:42******** *************** @ptn-nntp-reader04.plus.n et...
The screenshot looks very interesting. Is there a version of the download
for Access 2000.

Thanks

Phil

"John Winterbottom" <as******@hotma il.com> wrote in message
news:38******** *****@individua l.net...
"Keith" <ke***@NOCARPke ithwilby.org.uk > wrote in message
news:cv******** **@sparta.btint ernet.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

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
10816
by: imani_technology_spam | last post by:
We need to present hierarchical data on a web page, the same way the tree view shows files in Windows Explorer. Here's the catch: that tree view needs to be bound to a SQL Server database. How can this be done?
0
2175
by: Tree menu using XML | last post by:
I have one XML file that has nodes and sub node and each and every node has the attribute call visible if its value is true then diplay this node else don't display thid node, but this condition i am able to check using xpath in asp.net 2.0 till MenuItem node. if i check visible attribute value till SubMenuLevel0 node then in tree it will not display the MenuItem Node at all Note: My tree Menu will start from MenuItem node and it will...
1
4907
by: Jesper DK | last post by:
Hi, I have docked a tree view to the left on a form. When I start to populate this tree view with nodes, a horizontal scroll box appears in the bottom of the tree view even though thee tree view is big largely big enough to fit the nodes and text. If I widen the tree view the scroll bar doesn't resize itself to show the relative view size in relation to the total size. Only if I narrow the view to not fit the nodes, the scroll box...
3
6057
by: Saradhi | last post by:
Hi All, Here I am facing a performance problem with the TreeView Node renaming. I am displaying a hierarchy Data in a treeview in my Windows C# Application. My tree view represents an hierarchical view of Parent Nodes and projects where in a projectnode can be added to any ParentNode and hence we may have a project node added to 100 Parent nodes. In this one, I have an operation of Renaming a Project Node. So whenever I am doing the...
1
2174
by: Kaye | last post by:
It seems that when I dynamically resize items in a tree-view control, using TVM_SETITEM and the TVITEMEX iIntegral member, things go awry. The window draws properly, but it seems like the RECTs for the HTREEITEMs are not updating properly. This is espeically true if I update the size of an individual HTREEITEM more than once -- making it larger, and then smaller again. The tree view's scroll bar no longer works correctly -- it doesn't scroll...
10
2522
by: dwok | last post by:
Does anyone know of a good article that discusses creating a "Tree View" control in ASP.NET? Or perhaps a Tree View Control that comes with source code? I have come across a lot of tree controls for ASP.NET however most of them are already compiled and don't come with source code. I am really just looking for an example on how to create my own Tree Control. Thanks a bunch.
0
1425
by: rinishrk | last post by:
Hi, I have a web application that contains subfolders Admin and User with related webpages inside them. Within the Admin folder I have a page containing a Tree View Control.I want this tree view to have nodes for all pages in the website. However it seems that I cannot create child nodes within this tree view for pages that exist outside the Admin folder.(i.e.pags within the User folder or the Root folder ).It gives me an errors stating...
3
2372
by: gmail | last post by:
Hi Friends, Can any body suggest me on this. I am working on .NET 2005 Frame work 2.0 . I am facing problem using the tree stucture. I created the site map.Now i want use the site map in every page by keeping the tree structure in master page. Note: tree structure is created success fully. Now i want it display the output in the iframe which is besides the tree structure. That tree structure should display in every page with out hard...
1
4755
by: BeginingOfLife | last post by:
i am using a java script to create a tree view in my html page. i got that script from this link : http://destroydrop.com/javascripts/tree/ given script is static script creations for tree view,but i want to add a new node on that tree. i select a node location in a dropdown control(nodes present in a tree will appear in this control). i will give the new node name in a text box control. when i press a button in my html page
1
2611
by: happy.john1234 | last post by:
Hi, i have got large xml file which i have to show in tree view windows form.I tried with loading all those data at once to tree view but it took a long time to render that tree view.Now i am looking to polpulate tree view selectively.Only populating those nodes that user expands it by reading xml file.Can any one plz help me with some suggestions or point out to some sample code(it would be better) on how can i accomplish this.Thank in...
0
8411
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8838
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8513
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7351
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6176
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5638
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4173
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4329
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
1969
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.