?
Solved

Tree-view in Access

Posted on 2013-11-26
4
Medium Priority
?
2,169 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 668 total points
ID: 39678430
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 48

Assisted Solution

by:Dale Fye
Dale Fye earned 668 total points
ID: 39678452
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 38

Assisted Solution

by:PatHartman
PatHartman earned 664 total points
ID: 39678846
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
ID: 39679123
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses
Course of the Month10 days, 19 hours left to enroll

770 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