Can Draw Binary Tree In Forms Or Excel
May 30, 2013I have requirement to draw a binary tree in forms, how to implement this?
View Replies
ADVERTISEMENT
Draw Dynamic Forms On The Fly
Aug 8, 2006I have a large master table with hundreds of fields. Say, for example, in the master table, they are listed as "A1", "A2", "A3", "B1", "B2", "B3", "C1", "C2", "C3", etc. The form for this would draw every field, with a label matching the field name.
I have a second table that lists all the same fields, but has two extra columns. The first column's values will have what is known as the "friendly name" of the field. So for example, this column would have values of "A one", "A two", "A three", "B one", "B two", etc. The second column's value is whether or not this form should show this field, a simply yes/no field. This form should draw only the fields that are listed as yes, with the friendly name as the label value.
How do I dynamically draw this form on the fly, depending on the table values, while making sure that there is no extra spacing? Specifically, I can't just turn a field visible or not, I need X/Y coordinates to actually change depending on the field values ("yes" or "no"). Ideally, I would start on one line, continue to draw fields until "x" width was reached, then move to the next line, lather/rinse/repeat, and just continue on until there were no more fields that needed to be drawn.
Draw In Access
Apr 18, 2006Hi,
Is it possible to draw plans (house plans) in access - draw the plan for each record - displayed on a form ??
any help appreciated
How To Enable Users To Draw A Picture For Structure
Apr 9, 2013I am very new to access. I have tried to create form for my user to fill in all information they work each day and possible to update in to access database. But my users also want to be able to draw a picture like how the structure of things they have made based on each record. How can i have a place in userform to enable my users to draw such picture? I also want it to be saved together with the record they made and sometimes possible to come back and do revision of the drawing.
View 1 Replies View RelatedBlob Or Binary??
Jul 24, 2006I am looking for some help, I have a access database that is interfacing to a sql storage.
The problem I am having, is I have a Image that is containing archives for emails, however I have been yet to figure out hor to read that text stored in the image.
So far I have been able to come up with the data being stored in binary, but am unable to read it in a access form.
Make sence? Hope so.
Through SQL, I am able to run a query to read the data:
SELECT CONVERT(varchar(8000),CAST (body AS binary(8000) )) from arc_bodies
However I would like this text to be read through a form in access, and am unable to figure out how... Please help if possible, would be greatly appreciated.
Binary Operators In Access 97
Jan 6, 2006I am trying to store binary values (as decimal long integers) and then use bitwise comparisons to update the values. MS help suggest that the standard logical operators (And or etc) can do bitwise comparison as opposed to comparing boolean logical values for expressions; but I have found no way of making this work.
Is this possible? Any ideas. Doing it mechanically, by splitting the decimal into the relevant parts for any bit is very tedious!
Gibbo
Binary Values In Access
Dec 6, 2006Hi
I have a problem in binary type in access
I have some values that are between 1 to 32 byte
I want to specify the type of my field to something like "varbinary" such as SQL server but I have not this type
actually I used OLE object type but it doesn't like it.
for example when I use:
insert into t_t1(i,j) values(1,23)
while j's type is OLE object,
the row is inserted but I can not see the value of j column and I can not select on j column too for example
select * from t_t1 where j=23
has no result.
furthermore, I want to use hex values but I can not do it.
when I use
insert into t_t1(i,j) values(1,0xAD)
I got an error that says the type is mismatched
I know it may shows I expect unreasonably from access but please help me to find the solution
thanks for your attention
Best regard
Raw Data/binary Field, Or A Workaround?
Jan 29, 2007Hi there,
I have a simple bit of VBcode in my database which reads the password a user enters and 'encrypts' it for storing in the user table. It's more obfuscation than encryption to be honest, and I feel limited by the 'text' data type assigned to the password field.
At the moment it works by taking the password entered, and converting the whole lot into a byte array, then for each 'character' in the array, changing its binary value. At the moment it's then converted back into a string and dumped into the 'password' field, as garbage characters. But they are still characters, and if I go out of range of the character set it results in horrible errors :D.
I feel I may be missing the blindingly obvious and could just not convert it back to string, and write the binary into a text field instead, but I'm not sure how I'd get intelligible data back.
The reason it's not exactly encryption is because the key is the same for all characters on all passwords (I just multiply the binary value by 2!) what I want is to have a key as well, stored in another field alongside, but again can't implement this due to character-set range issues.
So my question is - is there a 'raw' data field hidden somewhere amongst the features of microsoft access, or should I be thinking about just storing the numbers themselves? For the moment I'll investigate the latter, but I'll appreciate any help! Thanks :)
Queries :: Hexadecimal String To Binary
Sep 24, 2013I have a text column with hexadecimal strings like "4E1B0A65FE3299FE", ie. of length 16.I'm doing an ALTER COLUMN query to convert the column to varbinary, but Access is doing conversion by ASCII, which results in a varbinary field of size 32, I think this is because the text column is in Unicode.
SQL Server has something called "styles" which are used with CONVERT.where you can choose to convert by two characters at a time 2:1..How do I do the same in an Access query? CONVERT/CAST are no supported.
Tables :: Binary Data Copy To Other Table?
May 10, 2014i want to copy binary data to another table with same structure.
how can i do this.
Technology Tree
Nov 11, 2006I 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.
Make Table Query Returns Binary Data Types
Jan 31, 2008This the first time I post in this forum and I tried looking for an answer to my question before posting, so I apologize if my question has been answered previously.
Is it possible to determine, in Access 2000, the data type in a Make-Table query of a new column with null value so that it does not default to binary.
Here is my sample sql:
SELECT tblAddressBook.Name, Null AS Email INTO tblTestTable
FROM tblAddressBook;
The output is tblTestTable with two columns: Name and Email. The data type of column Email defaults to Binary. How do I make it default to Text.
Thank you.
Modules & VBA :: Encrypt / Decrypt JPEG Image / Binary File
Oct 7, 2014I am looking for a function that will allow me to encrypt/decrypt single image files as and when required. I have built my own simple one to encrypt a string that will be stored in a filename as all the ones I found created unusable filenames.
However I don't know where to start with the image file encryption.
(Any better way to encrypt a string that can be used in a file name that would be great too. My method is a bit basic).
Convert Large Number To Binary For Use In TCPIP Socket Project
Apr 8, 2013I am working on a project that requires data transfer using TCPIP sockets. I am using a 3rd party Library (Ostrosoft) that handles the wsock32.dll api calls.
The project calls for the creation of a header that logs into a user account.
The first part of the header is a marker, with a value of 4,275,878,552. It is to be supplied in a Binary format of length 4.
My quesion is "How do I create this marker".
What I have tried so far is a string variable - strMarker thus:
strMarker = ChrB(&HFE) & ChrB(&HDC) & ChrB(&HBA) & ChrB(&H98)
Using the ChrB function to convert the Hex version of that number (FEDCBA98)
Need File Tree In A Form.
Jul 14, 2005I 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.
:)
How To Update Tree View?
Sep 5, 2005This 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.. :)
Tree-like Menu Style
Nov 3, 2005Hi!
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 :)
Tree View Question
Dec 30, 2005Good 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
Capabilities Of Access (Tree Diagrams?!)
Feb 7, 2006Hi,
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.
Left Side Tree Menu
Sep 24, 2006Hi,
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
Modules & VBA :: Expand Only One Selected Row In The Tree
Jul 30, 2014OFC 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:/
Tree View Structure For Indented BOM
Oct 2, 2013I 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
Tree View Library Reference Table
Nov 7, 2005I 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
Nov 7, 2005Tree 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.
Keyword Query In Access For Knowledge Tree
Jul 31, 2006Hi
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
Modules & VBA :: Optimizing Tree View Of Large Database
Oct 24, 2014I 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 ....