Solved

Combo Box in Tree View Control

Posted on 2003-10-29
7
439 Views
Last Modified: 2008-02-01
Hi Folks -

Does anyone have any familiarity with putting combo boxes in treeview controls...?  Basically I want to have a certain node that, when clicked to expand, displays a combobox.  Can this be done in Access (I know it can be done in VB)  I was playing around with an ActiveX Control (Microsoft ImageComboBox Control 6.0) That seems to be something like this but I don't have any familiarity with this...

Also - anyone know of a good reference for ActiveX controls and where to find out about how to code for them?

Thanks in Advance,
kev
0
Comment
Question by:Kevin_S
  • 4
  • 3
7 Comments
 
LVL 8

Expert Comment

by:MrRobin
ID: 9645086
Where do you want to display this combo box and why?

I strongly recommend that you avoid using the ImageCombo - last time I tried to use it I found it to be a buggy piece of rubbish that Microsoft should be pretty ashamed of (try selecting text in the text box part using the mouse).  Do you need a combo box with images in it?  If not then how is the ComboBox in Access differentl to the one in VB that s causing you problems here?
0
 
LVL 1

Author Comment

by:Kevin_S
ID: 9645372
I want to display the combo box in the actual Tree View control on my form.  In theory, I want to have certain nodes in the treeview that, when clicked, make a combo box appear next to them that the user can select items from.  I tried to simply use a regular combo box and put it on top of the treeview but when I view the treeview in form view the combo is not longer visible (I haven't altered its properties in any way).  I figured that this was caused by the treeview having the focus and, subsequestly, hiding the combo box but I cant set the focus to the combo or anything...

Any tips/thoughts as to how to achieve the desired result?

Thanks,
Kev
0
 
LVL 8

Accepted Solution

by:
MrRobin earned 125 total points
ID: 9645512
Gotcha.  You could put the combo box in a sub form.  I think the subform, unlike the combo box, will stay on top of the tree view - bit like putting an unwindowed control (such as a Label) into a PictureBox in VB.
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 1

Author Comment

by:Kevin_S
ID: 9645798
Nope. Just tried both a subform, command button, and listbox on the treeview and all of them went away!~)

Any other ideas..?
0
 
LVL 8

Expert Comment

by:MrRobin
ID: 9649065
Subform works for me (the others don't).  I'm using Access 2002 - what are you using?
0
 
LVL 1

Author Comment

by:Kevin_S
ID: 9652319
MrRobin -

The subform does indeed work (I was a little *Fuzzy*yesterday) so this will work for my needs...

Thanks for the help :)
Kev
0
 
LVL 8

Expert Comment

by:MrRobin
ID: 9653468
No problem!  Glad I could help.  Good luck with your crazy tree view/combo box thang!

Kind regards,

MrRobin
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

867 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

21 Experts available now in Live!

Get 1:1 Help Now