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:/
the login is working perfectly, once It logs in there is a button to expand all that is based in JS. I can't seem to work out how to get it to click the button to expand the whole menu, latest code is below:
Code:
Option Explicit
Function Checkpage()
Dim IE As Object
Dim lform As Object
Dim Document As Object
Dim item As Object
[code]...
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
HI
i never needed help this much.
i worked on an access application for 1/2 year. Everything went fine. But now we wanted to start working with it, some older acces versions are acting weird.
I have a form that contains a subform datasheet, and the datasheet has a datasheetsubform aswell.
This works fine in 2003. De datasheet is displayed, and when you click on the plus, the other datasheet opens in the maindatasheet.
But in 2000, you dont see the plusjes.
It is a major issue that i fix that! can some help me to solve this?
Joost
I want to make a table (1 row, 3 columns) on Form like we create the table in Microsoft Word. When I type the data in the first row more than one line. The other rows will then automatically expand. All the data will be saved in the same table.
I try to combine 3 textboxs but do not know how to solve the problem.
Thank you very much.
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'm working on a sub-form set to continuous and would like to amend a memo filed so that it autoexpands when entered. Have tried amending the height of the field through the on enter an on exit functions but this alters the size of the form.
Any clues would be much appreciated.
Fozi
On my main screen I have a button that I press and it pulls up a
pop up box...in the box you type in one item and hit ok then
the query goes and gets the results.
My quesion:
how do it make it so when I click the button the pop up box
has lets say four areas where I can enter different items and
then it goes and gets all four...or three or whatever I need ?
thanks...
Any ideas why combo boxes that all have their "auto expand" option set to YES are not auto expanding as I type-in text? They were working last week and I have no idea why they're not working now. Strangely, if I type in any of the entries present in the combobox list (text such as "St. Louis City") exactly as it appears in the combobox list, and then press enter, I get an error message telling me the value is invalid. Then, if I use the drop-down list to find and select "St. Louis City", it allows me to enter this value.
View 1 Replies View RelatedHi
I have a report with a column of data. It contains a variable amount of data according to the demand of the user (criteria entered in a parameter query). The problem I have is that the data is short string of 3 letters but there are generaly lots of entries so the report runs over several pages. I would like to be able to creat columns side by side. A bit like with the "Can grow" option" but that a new column appears...
I am not sure I am clear...
Many thanx for your help
I have a report that needs to show about 20 different fields from 24 records. I have it set up in landscape view, with one record per line (running horizontally). It allows me to show about 15 of the fields, spanning two pages (wide). I don't know how to add a third page to show the remaining fields.There are no Groupings.
Also, is there a way to "wrap" text in the column header?
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.
:)
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.. :)
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 :)
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
Is there a code for event procedure OnEnter() that allows me to expand my list box so that i can see a list that's larger than the size of it. I was hoping to multiple select from the list and do it at a glance because my list is very long.
View 1 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
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
MS ACCESS 2010
AutoExpand Property Set to Yes
I have a bound combo box that has a query as a row source, The query has 3 fields called from tblMasterItems, The ItemID , ItemDesc and ItemSupplier(related to the PK of tblSupplier).
Column Count = 3
Column Width = 0";1";0"
If I do not put a criteria under ItemSupplier, the combo box behaves just fine. The problem happens when I set the criteria under ItemSupplier, the criteria being the supplier ID, the combo box no longer expands and searches as you type, but the items in the combo box have been filtered and are there.
Summary:
When the row source qry ItemSupplier Field does not have a criteria, cbo works just fine.
When the row source qry ItemSupplier has a criteria, cbo no longer expands and searches as you type, but has the filtered data showing if you hit the expand button (that arrow pointing down in the cbo)
Have a generic dashboard report with multiple charts in it. One in particular is a bar chart, but depending on what the dashboard is produced for, the bar chart may have too many bars in it to make it legible. Therefore I'd like to conditionally determine the number of bars (basically the number of records in the query) and then make the chart go from one page and continue onto another.
View 4 Replies View RelatedI 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.
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
I have requirement to draw a binary tree in forms, how to implement this?
View 1 Replies View Related