Capabilities Of Access (Tree Diagrams?!)

Feb 7, 2006

Hi,

I am part of a team working on part of an ongoing project that requires a flexible and easy to update database from which to compile our data. The general format that we have, is that of a "Tree Diagram" (see sample attached). As you can see, this is where one branch has in turn several branches and this cascades downwards to some base values.

On the diagram you can see that I have used the example of "Costs In Football". Firstly the tree is branched into countries where football leagues exist (England, France etc...), each of these countries then has a number of leagues - I have only shown this for the English leagues. These leagues are all made up of teams, only following the Premiership league, you can see some of the teams in it (Arsenal, Chelsea...). Using the Liverpool team, the team is then made up of players such as Gerrard, Reina etc...
These players have a specific postion where they play (i.e. Goalkeeper, defence, midfield, attack) - this has been illustrated with only "Gerrard". The next set of branches examines the costs associated with each player (current value, weekly wage...)
The weekly wage is then examined in more detail by what components make it up and their respective costs. I have stopped the tree here and I am using this last line as the base values.

Now, what we wish to do, is to be able to calculate easily (and automatically) what costs are associated at each level of the tree diagram. i.e. "How much money is spent on wages in all the clubs in the Premiership league", or "Which country spends the most on Sponsorship Deals?"

The flexibility of the database must also be high. Each year the teams that make up each league are changed - we need to be able to make these changes to the database - and the automatically calculated values must change along with the changes.
Also, if a club buys a player - i.e. Liverpool (England) buy Beckham (Real Madrid, Spain) then the details for both Liverpool and consequently the Premiership league will have to change, along with the details for Real Madrid and the Spanish data.

In short, additions of data, changes of data and deletions of data must result in the database automatically changing the values involved in each step of the tree. i.e the change made in the Players branch must cascade up and down the branch so that the calculations at every level are recalculated.

Any help and feedback on this would be much appreciated,

Thanking you,

Matt.

View Replies


ADVERTISEMENT

Keyword Query In Access For Knowledge Tree

Jul 31, 2006

Hi

Does anyone know how to do a keyword search in MS access so in a knowledge tree with 100 of records with a few keywords in one of the main fields i.e. symptoms i can reduce the amount of records to go throught


Many thanks in advance

View 1 Replies View Related

Entity Relationship Diagrams

Nov 7, 2007

Somewhere on the Internet are some sample entity relationship diagrams for various database designs.

I've used every sort of Google search criteria I can think of, and haven't been able to find it.

Anyone got any idea of the site I'm talking about? Or any other resources even.

Thanking you in anticipation.

Cheers Tony

View 6 Replies View Related

Report Count Capabilities

Nov 12, 2004

Good afternoon! I have a report that looks just like a spreadsheet. I have names down the side and dates across the top. The grid contains the count of date for each name. These are the dates that an employee is scheduled to work. Is there a way to also document within this report (with "R" for requested off, or "A" for available), to note when they are available or have requested off? I'm attaching a zip of the report and the code that calculates the grid also. Thank you for your help...

KellyJo


This is the query I used:
PARAMETERS [Forms]![frmDates]![Date] DateTime;
TRANSFORM Count([Staffing Query].Title) AS CountOfTitle
SELECT [Staffing Query].ERName, [Staffing Query].Department, [Staffing Query].Shift, Count([Staffing Query].Department) AS [Total Of Department]
FROM [Staffing Query]
GROUP BY [Staffing Query].ERName, [Staffing Query].Department, [Staffing Query].Shift
PIVOT "d" & DateDiff("d",[Forms]![frmDates]!Date,[Date Scheduled]) In ("d0","d1","d2","d3","d4","d5","d6","d7","d8","d9","d10","d11","d12","d13","d14","d15","d16","d17","d18","d19","d20","d21","d22","d23","d24","d25","d26","d27");

View 6 Replies View Related

Technology Tree

Nov 11, 2006

I want to create a technology tree that is database driven. Something like this:

Tech1 -> Tech2 -> Tech3
xxxxxxxxxx||=>Tech4 -> Tech5

All of the techs follow a specific hierarchy. So if you want to get tech3 in the above example, you need to research techs 1 and 2 first. If you want to get tech5, you need to research techs 1, 2 and 4 first.

Once the layout of the database is there, I want to be able to run queries on specific techs to see what techs are needed to open that tech up. Each of the techs have numbers associated with them also, and I would like to also be able to query a tech, and find out all of the added totals for every tech that is needed to get to that tech. For example:

Tech1 (has values 1a, 2b) -> Tech2 (has values 3a, 5b) -> Tech3 (has values 4a, 7b)

I run a query on tech3, and it shows me that the totals for that tech path are: 8a, 14b. (1a+3a+4a=8a, and 2b+5b+7b=14b).

I know this is possible, but it is very complex. I have some ideas on how to start this, but I would appreciate some feedback/samples on where to get started. If someone spends the time and gives me some really helpful samples, please include your paypal in your post.

View 1 Replies View Related

Need File Tree In A Form.

Jul 14, 2005

I have a form in which I want to place a box that has a specific file directory displayed at all times for the user to open files from.

Please help!! Really new at this.

:)

View 5 Replies View Related

How To Update Tree View?

Sep 5, 2005

This problem is driving me crazy.... :mad:
I have main form which contains treeview control. TreeView contains list of all users that have been added. I add users in pop up form. But when I hit Update button in pop up form the treeview dosen`t want to update.
I can make it work only if I close main form and open it again when I hit Update button on pop up form.

If IsLoaded("frmOsnovnoOkno") Then
DoCmd.Close acForm, "frmOsnovnoOkno"
DoCmd.OpenForm "frmOsnovnoOkno"
DoCmd.Hourglass False
End If

I dont want to close main form ("frmOsnovnoOkno") and open it again I just want to update treeview without closing and opening main form. Please help me.. :)

View 6 Replies View Related

Tree-like Menu Style

Nov 3, 2005

Hi!

I need a help.
I would like to (if possible) to place into Form an object that could create a Tree-like menu structure. The source from this object should be table/query.
Is this possible?

Many thanks.

Krava :)

View 10 Replies View Related

Tree View Question

Dec 30, 2005

Good morning from the UK,

I hope one of you can help me out.

I am looking at setting up a treeview for users, with the idea that it will be easier for people to use.

The data i need to pull of is as follows:-

The table i have is called tbl User Accounts, the true values could be set to false as well as true.

Top Node = User Names
Alastair Lane
Passwordnorman27
AccessDatabaseTrue
AccessUsersTrue
SalesInput True
ProcessInputTrue
AddClients&ContactsTrue
EditReportsTrue
ApprovalOfAccountTrue
ImportReportsTrue
ExportReportsTrue
ManagementTools True
UnLockRecordTrue
Calls35

Nevil Appleton
Passwordpassword
AccessDatabaseFalse
AccessUsersTrue
SalesInput True
ProcessInputTrue
AddClients&ContactsTrue
EditReportsTrue
ApprovalOfAccount True
ImportReportsTrue
ExportReportsTrue
ManagementTools True
UnLockRecordTrue
Calls10


I am not sure how to even start this process so any examples would be good.

Alastair

View 11 Replies View Related

Left Side Tree Menu

Sep 24, 2006

Hi,

I would like to create an application with a left side tree menu.
Each leaf of the tree should open a form or launch a procedure.
The branches could expand or collapse.
Nodes could have pics.

There must be a couple of VAB examples. Would you recommend me some of the best ones ?

Thanks

View 1 Replies View Related

Modules & VBA :: Expand Only One Selected Row In The Tree

Jul 30, 2014

OFC without "+" Now I have something like this in double click event in one of my field

Code:
If Me.SubdatasheetExpanded = False Then
Me.SubdatasheetExpanded = True
Else
Me.SubdatasheetExpanded = False
End If

But this code expand all of my items:/

View 1 Replies View Related

Tree View Structure For Indented BOM

Oct 2, 2013

I need a tree view structure for indented BOM (Bill Of Material) as shown below

Assembly1
Assembly1.1
Assembly1.1.1

Assembly1.1.2
Child1
Child2
Assembly1.2
Child1
Child2

Assembly2
Assembly 2.1

Assembly 2.2 and it continues

View 1 Replies View Related

Tree View Library Reference Table

Nov 7, 2005

I am not sure if this is the correct forum to post this question but I am trying to create a tree view library reference database for several pdf documents I need to index, and would be happy if there is a sample available to download.

Thanks!

View 1 Replies View Related

Tree View Library Reference Table

Nov 7, 2005

Tree view library reference table

I am not sure if this is the correct forum to post this question but I am trying to create a tree view library reference database for several pdf documents I need to index, and would be happy if there is a sample available to download.

Thanks.

View 1 Replies View Related

Can Draw Binary Tree In Forms Or Excel

May 30, 2013

I have requirement to draw a binary tree in forms, how to implement this?

View 1 Replies View Related

Modules & VBA :: Optimizing Tree View Of Large Database

Oct 24, 2014

I have a form with a Treeview in. I have it populated from a self-referencing database using the following code.

Code:
Private Sub Form_Load()
Const strTableQueryName = "SELECT * FROM tblHierarchy ORDER BY tblHierarchy.Function_Parent;"
Dim db As DAO.Database, rst As DAO.Recordset
Set db = CurrentDb
Set rst = db.OpenRecordset(strTableQueryName, dbOpenDynaset, dbReadOnly)

[Code] ....

The database this is referencing is about 30000 lines and it takes ~4 minutes to populate this way. I know Treeview isn't really supposed to be used in this way however it's what is required.

Now I have come up with the theory that I will populate each node with children as its clicked to be expanded.

Uploaded my current treeview example ....

View 4 Replies View Related

Modules & VBA :: Recursive Search And Populate Results In Tree View Control

May 28, 2015

I need some VBA coding to do the following tasks

Table 1: two columns - Child Tag and Parent Tag. Parent Tags can also be in Child Tag column. In other words, a parent can have multiple levels of children.

Table 2: one column - Backup Tag.

I'd like to have a form with a combo box, pick a Parent Tag, the search all its child tags and compare each Child Tag found with records in Table 2 to see if there is a match. Then populate all results in a tree view control.

A visual example :

Parent Tag
...Child Tag 1 - Back up tag found
......Child Tag 11
......Child Tag 12 - Back up tag found
...Child Tag 2
......Child Tag 21
...Child Tag 3
......Child Tag 31
.........Child Tag 311 - Back up tag found

View 7 Replies View Related

Add "and", "or" Bolean Capabilities To A Simple Search

Jul 9, 2005

Working in ColdFusion, the following works good with just one term criteria:

<cfquery ...
where
A.TITLE LIKE <cfqueryparam cfsqltype="cf_sql_varchar" value="%#criteria#%">
OR A.SUBTITLE LIKE <cfqueryparam cfsqltype="cf_sql_varchar" value="%#criteria#%">
OR A.ABSTRACT LIKE <cfqueryparam cfsqltype="cf_sql_longvarchar" value="%#criteria#%">
OR A.CONTENT LIKE <cfqueryparam cfsqltype="cf_sql_longvarchar" value="%#criteria#%">
...

Please advise the best approach so that multiple terms may be used.
Thank you very much.
ContiW

View 4 Replies View Related

Can Office Access 2003 Runtime-Based Solutions Applies To Access 2007?

Jan 29, 2007

Hello,

I have installed Microsoft Access 2003 and Microsoft Access 2003 Developer Extensions. I can create Access application by using the Package Wizard.
But after I upgrade from Microsoft Access 2003 to Microsoft Access 2007.
I can't use the Package Wizard.

How can I do to solve this?

Thanks.

View 1 Replies View Related

Automated Access Launch Causing Access Window To Fail To Hide

Jul 10, 2006

Hi,
I have been using "fSetAccessWindow (SW_HIDDEN)" in the open event of my
main switchboard to hide the grey Access screen from being visible behind
forms, reports, etc in this db. But when I started using a .vbs script file
to launch the db, the Access window stopped being hidden. (The reason I use
the script for launching is that it temporarily sets the db's security level
to 1 which stops the macro security warning from coming up.) Apparently MS
knows about this happening and released a technique to rectify the situation,
but I don't understand their instructions. It looks like they expect one to
have more understanding than I have. Could someone help me get this
impliemented? Here is the article:
http://support.microsoft.com/kb/167659/en-us
Thanks!

View 2 Replies View Related

How To Access Ms-Access WorkGroup Tables To Change Database Login Password

Apr 13, 2007

Hi!
This is Kishore, working on VB Project which is using MS-Access95 as backend.
Now, i want to change the Database login Password.
Could anyone guide me in this context.

Regards,
Kishore

View 4 Replies View Related

Using Access's User And Group Accounts Or Using A Login Form To Access Database?

Sep 9, 2005

Using Access's User and Group Accounts or Using a Login Form to access database?

I've been researching on how to make a database secure. How to create User and Group Accounts on access, I see the step by step instructions and tried it out myself.

I also saw some sites where they give an example of a Login Form and how to create one.

My question is do you need to create both. First create the users and groups to permit or deny access to certain forms and then have a login form?

But would that mean that they'd have to login twice? Once when the database opens because it activates the db security that was created and then login again in the login form that was created?

Also when the user logins in and clicks on the cmd button on the form which opens up another from, frmWorkLog, I have an Employee field. This field I want it to have the user's name entered automatically and "locked". So that info, employee name, is extracted from the user's login. So then the user can only see his or her records only and no one elses.

How would I go about creating that. Hope I made my explanation clear.

Thanks in advance.

View 3 Replies View Related

Locking User Access To Database Objects (MS Access 2000 And 2003)

Apr 15, 2007

I have two database applications and they are:
- the (A) application is for administration use.
- the (B) application is for normal users use.

the idea is that: I made the (A) application for administrators who have full control over the database objects (tables, forms, queries, and so on ...).

the (B) application I have created for normal users who will have only to use forms to insert some data and display data only.

but the two applications has a respective table called "vacation request" table. where I linked them, so the both administrators and users can share the data.

The real question is that: How can I prevent the users from seeing the database objects in their application. I used the database options which have helped me in hidding the database objectives when the users open the application, but unfortunately they managed to access to the database objects by pressing the special keys.

I would like to have an access to the (B) application when I want to make some modifications to the forms and then lock it from users where they only have to use the forms for requesting vacations and view the vacations.

View 1 Replies View Related

Remove Access Parameters Request For Simple Access Search Form

May 3, 2014

I have a simple access search form , that's based on a query that fill parameters from the form textboxes, when the access form loads its keeps prompting for parameters value which looks ugly .. I want to open the form, displaying all the records in the table and filter when i click search ..

I have a data entry entry form, that i want to generate success message after successful insert in database. I have done it in the button event if no error happens, still if i left all fields blank and clicked save, it displays the message ..

I need to change that to display please fill the textboxes then click save , and display success message when the row is actually inserted ..

Check the following attachment for sample.

View 14 Replies View Related

Forms :: Multi Select Listbox Access 2003 Code Gives Syntax Error In MS Access 2010

Oct 24, 2013

I've been using the following code successfully in Access 2003 & now I need to migrate to Access 2010. The purpose of the code is to use the items that the user selects in the list box to build the criteria of a query. Access 2010 keeps giving me a syntax error when I try to run the query & I don't know why:

My code is:

On Error GoTo Err_Command151_Click

' Declare variables
Dim db As DAO.Database
Dim qdf As DAO.QueryDef
Dim varItem As Variant
Dim strCriteria As String
Dim strSQL As String

[Code] .....

The syntax error I get in Access 2010 is:

Syntax Error in query expression 'SELECT * FROM
qryContractListSummarybyDateContract3TYPEBREAK WHERE
qryContractListSummarybyDateContract3TYPEBREAK.Rep ortableName IN('Adbri
Masonry NSW');'

View 12 Replies View Related

Table Problems Moving From Access 2003 -&gt; Access 2007

Jun 19, 2007

Attached is a screenshot of the relationships in a database I built a couple of years ago. It's worked absolutely fine in Access 2003 and currently has over 18,000 customers with associated information in it.

However, when I open the database in Access 2007 the performance is awful. All the forms are very slow to respond when tabbing between form elements. I've experimented by reducing the number of form elements calling on related data on a given page and whilst this improves performance it reduces usability - something I don't want to compromise on especially since Access 2007 should be able to cope with this.

My next question is therefore whether I've got the most efficient underlying table design and I can't see any other way of doing it than my current method so I'd be grateful for any feedback or advice anyone has.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved