mescalona
asked on
Building a Data tree with MS Access (VBA)
Hi Experts,
I have to build a data tree by using MS Aceess (VBA). The idea is having a data tree with information from a table that has string and numeric values. For instance, I have a table called projects that has name of the project, time, resources, and cost, so what I want to do is building a project category data tree. We want to create a category called home project. This categeory will have all the home development projects we have done so far. I want the posibility of doing drill up and drill down, so if I di drill up the cost will be the average of all the projects within this category. I can create as many categories as posibble and each category has subcategories or childs.
USING VBA IS NOT A RESTRICTION, IF YOU KNOW ANY OTHER TOOLS THAT CAN DO THIS FASTER AND BETTER, I WILL REALLY APPRECIATE IT.
THANKS
I have to build a data tree by using MS Aceess (VBA). The idea is having a data tree with information from a table that has string and numeric values. For instance, I have a table called projects that has name of the project, time, resources, and cost, so what I want to do is building a project category data tree. We want to create a category called home project. This categeory will have all the home development projects we have done so far. I want the posibility of doing drill up and drill down, so if I di drill up the cost will be the average of all the projects within this category. I can create as many categories as posibble and each category has subcategories or childs.
USING VBA IS NOT A RESTRICTION, IF YOU KNOW ANY OTHER TOOLS THAT CAN DO THIS FASTER AND BETTER, I WILL REALLY APPRECIATE IT.
THANKS
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Sorry I lost track of this one ... hope you got answers to this elsewhere, in the future if one of the Experts hasn't responded in a reasonable length of time then you can "ping" the thread again ... just post something like "any thoughts" or "you still out there" and we'll be alerted.
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
for drill up:
HOME IMPROVMENT
+ Total home improvement 16 days average at $ 100,000 average cost
for drill down
HOME IMPROVEMENT
-project A 2 dats at $ 78,000 cost
-project B 5 days at $ 89,000 cost...
The tree display is not that important, but I would like to know how "simple treeview-style " works.
What is really important is the table structure. I mean how many tables to use, queries, and the code.
Do you think you can help me?