UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Treeview With Listbox, Access 2016    
 
   
mylton
post Sep 16 2019, 09:27 AM
Post#1



Posts: 50
Joined: 13-June 16



Good Morning.
I would like to create a treeview using it from a listbox control.
Would anyone have a small example so they can study and apply in my need?


thanks.
Go to the top of the page
 
DanielPineault
post Sep 16 2019, 10:21 AM
Post#2


UtterAccess VIP
Posts: 6,899
Joined: 30-June 11



I'd highly recommend you stay away from the MS Treeview ActiveX control and instead look at https://jkp-ads.com/Articles/treeview.asp

--------------------
Daniel Pineault (2010-2019 Microsoft MVP, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
GroverParkGeorge
post Sep 16 2019, 10:47 AM
Post#3


UA Admin
Posts: 35,842
Joined: 20-June 02
From: Newcastle, WA


While I agree with Daniel's suggestion, I am curious about what it is you wanted to do here.

What would the list box have to do with a treeview control? How would you anticipate they would interact in an interface?

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
mylton
post Sep 16 2019, 11:21 AM
Post#4



Posts: 50
Joined: 13-June 16



thanks for the tip.
however, was there any control whatsoever that would do the same thing without being treeview?
Go to the top of the page
 
DanielPineault
post Sep 16 2019, 11:27 AM
Post#5


UtterAccess VIP
Posts: 6,899
Joined: 30-June 11



Sorry, but I'm not understanding what you are after. If you want a Treeview then look at the link provided, otherwise, you don't want a Treeview, in which case please explain things more so we can understand better your needs and see if we can offer some guidance.

--------------------
Daniel Pineault (2010-2019 Microsoft MVP, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
mylton
post Sep 16 2019, 12:19 PM
Post#6



Posts: 50
Joined: 13-June 16



OK.
treeview is also a tool where you click and expand or retract the desired information.
I would like to implement a tool that does the same thing as treeview other than treeview.
It could be a continuous form, a listbox, or something else that when you clicked would expand or retract the information.
I don't know if I was clear enough.
I'm sorry if I didn't go.
Go to the top of the page
 
DanielPineault
post Sep 16 2019, 12:26 PM
Post#7


UtterAccess VIP
Posts: 6,899
Joined: 30-June 11



I have to ask why try to reinvent the wheel when there is a tool for exactly that? Did you check out the link? It isn't an actual ActiveX Treeview control, but rather a complete rewrite using pure VBA. So it is basically exactly what you are wanting to do, create a Treeview that isn't a treeview.
What issue are you trying to get around? What problem do you have with the Treeview?

As you mention, you could probably devise your own tool, but this would involve coding and without more information it is hard for us to guide you.

--------------------
Daniel Pineault (2010-2019 Microsoft MVP, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
mylton
post Sep 16 2019, 02:30 PM
Post#8



Posts: 50
Joined: 13-June 16



thanks for the tip.
I will download and study.
good week.
Go to the top of the page
 
mylton
post Sep 16 2019, 10:03 PM
Post#9



Posts: 50
Joined: 13-June 16



good night
Panning, I found this example which is a treeview without being one.
Pure VBA.
I believe it will suit many people.
Language in portuguese.
Attached File(s)
Attached File  MenuTreeView__1_.zip ( 45.35K )Number of downloads: 12
 
Go to the top of the page
 
Phil_cattivocara...
post Sep 16 2019, 11:53 PM
Post#10



Posts: 360
Joined: 2-April 18



The usual Italian @Alex's (very good) job
TreeView VBA
"full" and "light" version (both free = no money), with 23 pages pdf guide but written in Italian language.
Not professional, not bug free (so if you use it in professional environment it's your own risk) but... give it a try and remember to close your mouth at the end.
This post has been edited by Phil_cattivocarattere: Sep 16 2019, 11:54 PM

--------------------
Please forgive in advance my horrible English.
Go to the top of the page
 
DanielPineault
post Sep 17 2019, 06:47 AM
Post#11


UtterAccess VIP
Posts: 6,899
Joined: 30-June 11



Context, I wish you had simply told us what you were trying to do/build, a navigation menu then we could have pointed you to samples. If you search, right here at UA, there are several. At least you have a solution.

--------------------
Daniel Pineault (2010-2019 Microsoft MVP, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    14th October 2019 - 01:57 PM