Is there a native access version of the treeview?
in [Form]
|
Prev: Subform question
Next: Filter in the form
From: sk on 10 Apr 2010 00:10 I have a need to use the treeview control in a database I'm working on but I do NOT want to deal with the activex registration issues if I can get around it. Is there any control native to access that can be made to act the same? I can go with 2 or 3 listboxes but that is just not as slick looking in a finished application and it uses up too much space on the form. I have used the treeview with nested recordsets in the past but that was on a single user app so there was not a big issue in getting the control loaded. The app I'm working on now will be used by 20+ people so I want to stay away from the registration issues if I can.
From: sk on 10 Apr 2010 00:16 forgot to add I'm using 2007. "sk" wrote: > I have a need to use the treeview control in a database I'm working on but I > do NOT want to deal with the activex registration issues if I can get around > it. Is there any control native to access that can be made to act the same? > I can go with 2 or 3 listboxes but that is just not as slick looking in a > finished application and it uses up too much space on the form. > > I have used the treeview with nested recordsets in the past but that was on > a single user app so there was not a big issue in getting the control loaded. > The app I'm working on now will be used by 20+ people so I want to stay away > from the registration issues if I can. > >
From: Tom van Stiphout on 10 Apr 2010 14:13 On Fri, 9 Apr 2010 21:16:01 -0700, sk <sk(a)discussions.microsoft.com> wrote: No. Create a setup program, which will install all required components. Here is a link: http://msdn.microsoft.com/en-us/library/aa139957%28office.10%29.aspx The Wise installer is generally considered the best. -Tom. Microsoft Access MVP >forgot to add I'm using 2007. > >"sk" wrote: > >> I have a need to use the treeview control in a database I'm working on but I >> do NOT want to deal with the activex registration issues if I can get around >> it. Is there any control native to access that can be made to act the same? >> I can go with 2 or 3 listboxes but that is just not as slick looking in a >> finished application and it uses up too much space on the form. >> >> I have used the treeview with nested recordsets in the past but that was on >> a single user app so there was not a big issue in getting the control loaded. >> The app I'm working on now will be used by 20+ people so I want to stay away >> from the registration issues if I can. >> >>
From: Larry Linson on 13 Apr 2010 14:02 Some time ago, I did a demo using the TreeView. I did not have to load anything "special", but do note that the sample includes two References that are not "basic": Microsoft Office SP Web Components and Microsoft Windows Common Controls v 6. As I often use the Windows Common Controls for file selection, I suspect the TreeView is in the Microsoft Office XP Web Components. If all your users have full Microsoft Office Pro installed, I think there's a probability that they'll already have the Web Components installed and you won't face ActiveX registration issues. (Caveat: But, that may not be the case with all versions of Office.) Former MVP (now Microsoft employee on the Access team) Jeff Conrad has several useful links about TreeView at http://www.accessmvp.com/JConrad/accessjunkie/treeview.html. Larry Linson Microsoft Office Access MVP "sk" <sk(a)discussions.microsoft.com> wrote in message news:E7542D57-8E92-447A-822D-8F510C84FF04(a)microsoft.com... >I have a need to use the treeview control in a database I'm working on but >I > do NOT want to deal with the activex registration issues if I can get > around > it. Is there any control native to access that can be made to act the > same? > I can go with 2 or 3 listboxes but that is just not as slick looking in a > finished application and it uses up too much space on the form. > > I have used the treeview with nested recordsets in the past but that was > on > a single user app so there was not a big issue in getting the control > loaded. > The app I'm working on now will be used by 20+ people so I want to stay > away > from the registration issues if I can. > >
From: Larry Linson on 13 Apr 2010 23:03
Oops, finger-fumble. The first reference should be Microsoft Office XP Web Components Larry "Larry Linson" <bouncer(a)localhost.not> wrote in message news:uKmBnNz2KHA.1452(a)TK2MSFTNGP06.phx.gbl... > Some time ago, I did a demo using the TreeView. I did not have to load > anything "special", but do note that the sample includes two References > that are not "basic": Microsoft Office SP Web Components and Microsoft > Windows Common Controls v 6. As I often use the Windows Common Controls > for file selection, I suspect the TreeView is in the Microsoft Office XP > Web Components. If all your users have full Microsoft Office Pro > installed, I think there's a probability that they'll already have the Web > Components installed and you won't face ActiveX registration issues. > (Caveat: But, that may not be the case with all versions of Office.) > > Former MVP (now Microsoft employee on the Access team) Jeff Conrad has > several useful links about TreeView at > http://www.accessmvp.com/JConrad/accessjunkie/treeview.html. > > Larry Linson > Microsoft Office Access MVP > > > "sk" <sk(a)discussions.microsoft.com> wrote in message > news:E7542D57-8E92-447A-822D-8F510C84FF04(a)microsoft.com... >>I have a need to use the treeview control in a database I'm working on but >>I >> do NOT want to deal with the activex registration issues if I can get >> around >> it. Is there any control native to access that can be made to act the >> same? >> I can go with 2 or 3 listboxes but that is just not as slick looking in a >> finished application and it uses up too much space on the form. >> >> I have used the treeview with nested recordsets in the past but that was >> on >> a single user app so there was not a big issue in getting the control >> loaded. >> The app I'm working on now will be used by 20+ people so I want to stay >> away >> from the registration issues if I can. >> >> > > > |