Search results

  1. T

    Access 2007 Form which 'autofills'

    yeah, about the 1 :P i said that back in an old version of the DB hehe! Ok, so pretty much what I want is this: When someone choses the projuct number, it will automatically fill the Client, Project name, Phase (this is a time sheet, and the people who I work with are Lazy, lol) so say like...
  2. T

    Access 2007 Form which 'autofills'

    Ok, here is my db, please ignore the fact that it is prolly really bad, i have deleted a lot of stuff and added stuff i prolly dont need :) Thanks,Paul
  3. T

    Access 2007 Form which 'autofills'

    Yeah, thats the way I did it the first time, but when I do that it..well doesnt change any of the other fields... I am in a tabular view for my form (thats the way I need it to be) so im not sure if that affects it, since the one on the tutorial is a columnar view (i think.. lol) ... Also, in...
  4. T

    Access 2007 Form which 'autofills'

    Ok, I think I did what you said to do...lol...Im kinda new to Access, but I think I got it...then I assigned the combo box the following code using DLookup: Private Sub Project_Number_AfterUpdate() If (Project_Number <> Empty) Then Client = DLookup("[Client]", "d", "[Project_Number]=" &...
  5. T

    Access 2007 Form which 'autofills'

    Cool, I will play around with combo boxes :D not sure exactly what you mean by a form bound to a query tho :P Thanks
  6. T

    Access 2007 Form which 'autofills'

    So..I have this form and it has about 6 fields, and what I want, is that when someone enters a project number (they can choose between already listen ones, cant make their own) then 3 of the other fields are automatically filled in based on the project number...I know there may be an easier way...
  7. T

    Using Treeview checkboxes to determine if a node is 'active'

    Sorry John, but when I downgrade it, the form gets deleted, im guessing they implement a different version of treeView. I will, however let ya see my code (works in 2007..:P) So far all that I have done is: adds nodes CORRECTLY, adds checkboxes, when a node is clicked the information in the...
  8. T

    Using Treeview checkboxes to determine if a node is 'active'

    Hm, I dont quite understand where you use the strNodeInfo = Me.tvwHierarchy.SelectedItem.Tag and what sort of a value it saves...does it just give a unique number to each node like a key? Here is my database (dont mind the horribly messy, probably half useless code :P, ive only been using VB...
  9. T

    Using Treeview checkboxes to determine if a node is 'active'

    I'm assuming that it will be something like Private Sub TreeView_Click()I have a treeview on the left side of my form and a textbox on the right. when a node's checkbox is...checked, I would like it to display the information relating to that cell (that part I can do, but only when the node is...
  10. T

    Access 2007 Treeview Sub..with code

    Cool thanks... ill keep my eyes open...i didnt even know there was a sample section >.<
  11. T

    Access 2007 Treeview Sub..with code

    Hey! So i have made a treeView in access 2007, and i made it successfully implement the first tier...but when i go to add children is when it gets funny... So how the data looks, in column (field??) 1, there are part number, and in number 2 there are sub number... so for example Part 1 (in...
  12. T

    Tree View in a Report

    Cool! thanks so much, this is a great start :)
  13. T

    Tree View in a Report

    Hey! I am trying to make a database for my uncle, and one of the things which he wants, is a tree view/explorer type menu on the side of the report. I am just wondering if this is possible in access 2007? I know it is possible in 2003, but not sure how to do it in 2007 (not that I know how in...
Back
Top Bottom