Solved

Tree-view in Access

Posted on 2013-11-26
4
1,664 Views
Last Modified: 2013-11-28
Hi Experts,

Does MS Access have a tree-view control, sort of file manager, where I can have expandable/collapsible nodes that I can build either by a loop or a recordset.

Finally, if the user highlights a node and clicks a button, the button can know which node is highlighted. Sort of where each node would have a label and a hidden ID and the button can read the ID.

If no such control is available in MS Access can anyone recommend something?

Thank you
0
Comment
Question by:APD_Toronto
  • 2
4 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 167 total points
Comment Utility
Yes ...

Freeware Instant Treeview (Scroll down to bottom  of the page until you get to Access Tools)
           http://datapigtechnologies.com/AccessMain.htm
Comes with db that has jump start example and an online tutorial. It's very cool.
0
 
LVL 47

Assisted Solution

by:Dale Fye (Access MVP)
Dale Fye (Access MVP) earned 167 total points
Comment Utility
I actually like the Treeview Blog website.  The creator walks you through the basics all the way to the complex in 7 steps.
0
 
LVL 34

Assisted Solution

by:PatHartman
PatHartman earned 166 total points
Comment Utility
The Treeview activeX control is not being ported to 64-bit and may not work with A2013 32-bit.  Check if it matters to you.

I found this treeview that is built with VBA and so is not an add-in.

http://www.jkp-ads.com/articles/treeview.asp
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
Interesting that the JLP TV has not been tested in A2013:

Access 2003
Access 2010 (32 bit)
Access 2010 (64 bit)

However, I just tested in 2013 and it seems to work just fine.
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Suggested Solutions

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now