TreeView Query and or Queries Question

Trying to use treeview (not sure how many queries I need Or how to accomplish
this)
My goal is to filter a datasheet form based on my tblAssets (AssetID,
LocationID, ClassificationID, CategoryID, SubCategoryID) next to the treeviw
by each selection from the treeview all the way down to the specific i.d.
number. Any help with treeview query/queries set-up would be Greatly
Appreciated

I click on "Asset Locations, it opens up listing the three locations in my
tblLocation (LocationID, LocationName)

I then click on Asset Main Classifications, it opens up listing all
Classifications in my tblAssetClassifications(ClassificationID,
ClassificationName)

I then click on Asset Main Categories, it opens up showing all categories in
my tblAssetCategories(CategoryID, CategoryName)

I then click on Asset Main SubCategories, it opens up showing all
subcategories in my tblAssetSubCategories(SubCategoryID, SubCategoryName) I
now see all equipment listed by ID

example:
My Assets...
Asset Locations = Location1
Location2 (I select location 2, now show
Classifications)
Location3

Asset Main Classifications = Plant Equipment (I select Plant Equipment , now
show Categories)
Field Equipment
Production Equipment

Asset Categories = A/C Units (I select A/C Units , now show
SubCategories)
Furnace

Asset Sub-Categories = Window Mounted
Main Unit (I select
Main Unit , now see all Assets by ID)

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200912/1

Can any offer some advise / guidance on setting this up, seems to more
difficult then I thought?

Russ wrote:
Trying to use treeview (not sure how many queries I need Or how to accomplish
this)
My goal is to filter a datasheet form based on my tblAssets (AssetID,
LocationID, ClassificationID, CategoryID, SubCategoryID) next to the treeviw
by each selection from the treeview all the way down to the specific i.d.
number. Any help with treeview query/queries set-up would be Greatly
Appreciated

I click on "Asset Locations, it opens up listing the three locations in my
tblLocation (LocationID, LocationName)

I then click on Asset Main Classifications, it opens up listing all
Classifications in my tblAssetClassifications(ClassificationID,
ClassificationName)

I then click on Asset Main Categories, it opens up showing all categories in
my tblAssetCategories(CategoryID, CategoryName)

I then click on Asset Main SubCategories, it opens up showing all
subcategories in my tblAssetSubCategories(SubCategoryID, SubCategoryName) I
now see all equipment listed by ID

example:
My Assets...
Asset Locations = Location1
Location2 (I select location 2, now show
Classifications)
Location3

Asset Main Classifications = Plant Equipment (I select Plant Equipment , now
show Categories)
Field Equipment
Production Equipment

Asset Categories = A/C Units (I select A/C Units , now show
SubCategories)
Furnace

Asset Sub-Categories = Window Mounted
Main Unit (I select
Main Unit , now see all Assets by ID)

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200912/1

Hi Russ,

Here's a selection of articles regarding the treeview control:

The best example I've seen which illustrates the MS treeview control and its
capabilities is on Alex Dybenko's site, at
http://www.pointltd.com/Downloads/Details.asp?dlID=36

There's an article on using the MS Treeview control in one of Helen
Fedemma's Access Archon columns: http://www.helenfeddema.com/access.htm - on
the Archon page (which opens from that link) download accarch52.zip.
There's also an article on using the MS Treeview wizard (formerly available
as a separate download for A87 - not sure if it's stilll available, or works
with later versions) in accarch53.zip. And, perhaps most applicable to your
current situation, an article on using a treeview control as a record
selector, at accarch103.zip.

For more references, see this page on Jeff Conrad's Access Junkie site:
http://www.accessmvp.com/JConrad/acc.../treeview.html

HTH,

Rob


Russ via AccessMonster.com wrote:
Can any offer some advise / guidance on setting this up, seems to more
difficult then I thought?

Russ wrote:
Trying to use treeview (not sure how many queries I need Or how to
accomplish this)
My goal is to filter a datasheet form based on my tblAssets (AssetID,
LocationID, ClassificationID, CategoryID, SubCategoryID) next to
the treeviw by each selection from the treeview all the way down to
the specific i.d. number. Any help with treeview query/queries
set-up would be Greatly Appreciated

I click on "Asset Locations, it opens up listing the three locations
in my tblLocation (LocationID, LocationName)

I then click on Asset Main Classifications, it opens up listing all
Classifications in my tblAssetClassifications(ClassificationID,
ClassificationName)

I then click on Asset Main Categories, it opens up showing all
categories in my tblAssetCategories(CategoryID, CategoryName)

I then click on Asset Main SubCategories, it opens up showing all
subcategories in my tblAssetSubCategories(SubCategoryID,
SubCategoryName) I now see all equipment listed by ID

example:
My Assets...
Asset Locations = Location1
Location2 (I select location 2,
now show Classifications)
Location3

Asset Main Classifications = Plant Equipment (I select Plant
Equipment , now show Categories)
Field Equipment
Production
Equipment

Asset Categories = A/C Units (I select A/C Units , now show
SubCategories)
Furnace

Asset Sub-Categories = Window Mounted
Main Unit (I
select Main Unit , now see all Assets by ID)