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!
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.
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.. :)
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
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
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 ....
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
I have an Access project in which the main form is based on a view. The WHERE clause in the view needs to equate the value of a table field to the value of a combobox on the form. In the script that creates the view, I get a syntax error when the clause is:
WHERE Acct = [Forms]![frmMain]![cboAcct]
When I changed the clause to:
WHERE Acct = Me.cboAcct
I got no syntax error, but I got an error when I tried to run the script.
How should I code the script so I can create the view?
I have a table called NewTransactions_tbl that I have been using for some time. I am trying to add a new field called CustomerProjectNumber. It's not being displayed when I look at the table view. I've attached an image showing the settings for the field. I am probably missing something obvious.
Any ideas why it is not showing?
I am using Access 2000.
First of all apologies for the lack of proper terminology I'm a novice Ms Access user and I like to thank everyone in advance for trying to help.
Ok here is the situation:
I have two tables, NewJobs and Contacts which have the following fields.
Newjobs
--------
JobID (AutoNumber, Primary Key)
JobName
JobDate
JobDescription
JobOwner (Linked to table 'contacts' via LookUp)
Contacts
---------
DisplayName
EmailAddress
Department
Extension
Ok basically what I want is to have a form based on table NewJobs which will allow me to enter new jobs into the database. When I get to JobOwner a drop down list linked to 'Contacts' table will show me all the data from column 'DisplayName' and allow me to select it (saves time on typing). I have already done this and its not a problem.
Now I would also like in the same form to have additional fields from table 'contacts' such as EmailAddress, Department and Extension which will autofill with the right information soon after I select a JobOwner from the drop down list.
So for example if I select 'Joe Bloggs' Access will automatically fill the additional fields in the form with Joe's information (department, extension etc) from the Contacts table.
I hope all this makes sense. Thank you all for your support.
- Mitch
You know how normally in design view there would be a table at the bottom of the screen where you can drag your fields from the view above.
Well, I have a query where this table view has disappeared ?
I can edit the query in SQL view, the query works, just the table view is missing.
Ever happened to anyone else ? I've done the obvious and scrolled down as far as I can and nope, it's not there ??? :confused:
I'm trying to achieve something that I'm sure someone has figured out long ago. I have a DB that currently only shows the zip code for certain records. Is there a way that I can have the DB take the current zipcode, reference a zip code table, and then return both the zip and city/state?
Thanks
I'm trying to get a query to count all the pole positions, fastest laps, first places etc a driver has had, here is a picture of the sample for fastest lap, i have a small problem i cant get it to only count the current drivers fastest laps
so i need to know how i get the drivers.id to match with the driver id in the results table
http://www.alexsawczuk.co.uk/access.jpg
basically i want to know how i get the dcount to reference a different table?
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.
I have a query that currently calculates a rating based on various values entered into the database. This rating corresponds to a Quality Index value based in another table. I tried to set up a query that links the rating value in the query to the Rating in the table, however, when I run this query, I don't get all the results I should. Is there some other way to make this work? I thought it would be simple to link the rating value that is calculated to the rating in the table and have it report the Quality Index value associated with that value. Please help! :confused:
View 5 Replies View RelatedI have a form which have a sub form. In the sub form I have a the direct table to update data on it.
Example:
The form has the name of the project and the subform the name of one of the items of the same project and the table present the documents for the particular item.
The users have the option to add or edir docs to this item.
If I would like to reffer to a value they are entering on this table in VBA . how can I do that?
(I would like to present a msgbox when they are entering a date that isn't right on the table for this item.)
By the way, I can't use validation rule because I have a different dates needed per item.
When entering a lookup reference to a table field it pop up message saying, "you can't modify the table 1 this time as it is in use by other person or process" i have closed all forms and table reports but the problem is same to rectify ? also when going to see the realationship then there shows no relation ship developed even after the lookup reference from one table filed to another table field.
View 1 Replies View RelatedI have two tables, Table 1 and Table 2 and two related forms, Frm1 and Frm2. I want to be able to update the data on Table1 from Frm2, that is, if I change the data on Frm2, the corresponding fields in Table1 will update to the same data. I know that if both tables are open I can reference the fields on Frm1 and Frm2 with an IF statement: If Active = True And Forms!Frm1a.DoNotchange = False Then..And I know on the update query I can reference a control on a form by Forms!Formname.Control. Wll works fine.What I would like to know is can I reference a table field in the same way. For example, I have tried to use the IF Statement If Active = True And Tables!Table1.DoNotchange = False Then..Is there a way to reference the Table instead of the Form in both the VBA and the query? The problem seems to be that I have the two bound controls [Active] on Frm2 and [DoNotChange] on Frm1. (Which I need).
View 5 Replies View RelatedI 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.
:)
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 :)
I would like to update two fields [Category] and [ProdType] in tblAccum based on a reference table.
The reference table is tblReference and contains the fields [Code], [Category] and [ProdType].
tblReference example of field values:
Code Category ProdType
A Blank Accessory
BS Blank Blank Stock
O Printed Offset
So if the Code field in tblAccum has a value of O then based on the tblReference table the Category value would be Printed and the ProdType value would be Offset.
Any help is greatly appreciated.
Thanks,
I reused one macro to develop a form in MS access.
The macro fetch the record set corresponding to the reference value from the table.
The reformat value is a numeric field.
The macro code is :
Private Sub Modifiable20_AfterUpdate()
Dim rs As Object
Set rs =Me.Recordset.Clone
rs.FindFirst "[Reference_Number] = ' " & Me![Modifiable20] & " ' "
If Not rs.EOF then Me.Bookmark = rs.Bookmark
End Sub
What to change in the above code to make it work....
I have created two tables, I want to copy one column from one table to another table column with repeat value in rows.
example :- copy "Material number" column from Table1 to Table 2. In Table 2 Material number will repeat in 20 rows.
Like in excel we give one cell reference to multiple rows.
How I can link table and give reference of column.
I have an access db that is linked to a sharepoint list (the list originated in Access).I tried a simple select query with parameters to search for by id and another query of the same table to search by date.They both come back with the same error of "cannot reference a table with a multivalued field using an IN clause that refers to another database"Iv'e gone through the table and these fields that the query is using and none seem to have any multivalues.
View 6 Replies View RelatedHi,
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.
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