Search results

  1. CadMonkey

    Dynamic table structure-needed?

    Thankyou! I'm using Access 2000 and treeview control version 5.0 (Sp2) I've had a look at an example, but to be honest my understanding was limited. I wander if the ability to add a record (or node) from within the control is possible?
  2. CadMonkey

    Dynamic table structure-needed?

    Ah I C! I started in qbasic when I was 10 and followed a long winding road to becoming a CAD techician who just writes DBs for employers.... I'm wandering if there are any examples of this one to many within itself relationship? I've searched the posts and sample DBs. I'll give it a whirl...
  3. CadMonkey

    Dynamic table structure-needed?

    What quality replies! Sorry I haven't been in touch 'till now but I have multi Access projects looming. So do you pros make a living out of DB design- Pat and Mile? I'm looking at your sample databases to see if I can get my head around this relationship. I almost wish I stayed on my...
  4. CadMonkey

    Dynamic table structure-needed?

    Thankyou for your help. Instead I think I may take this route: To just have the simple saving items under a schedule format, however... Create a new table realted to the schedule called sections: 1 schedule can have many sections: Sections table: ID... number Schedule ID .... Num...
  5. CadMonkey

    Dynamic table structure-needed?

    Resolved?! Well, thankyou.. I've tried but I think this one is sending me doolaly. Can anyone glean my problem from this? (Please see attached erd pic)
  6. CadMonkey

    Dynamic table structure-needed?

    Hi, Mucho gracias if you pros can help me! I've only completed 1 year of a degree... I have a many to many table relationship that I have resolved with another table- therefore I now have two one to many relationships, fairly standard stuff. Basically I need to list items under a schedule. So...
  7. CadMonkey

    Create a Word doc & Make Current- easy peasy

    Hola! Everyone who reads this thread will likely find this the easiest thing in the world to do... In VBA I have coded to create a new word document. Now I need to make this document I've just crated the active document, so that I can add some text to it. Does anybody know any code that could...
  8. CadMonkey

    Can I borrow your Module? Please???!

    The reason I am after this class is because it has ready made objects such as ThisDocument and ThisApplication which allow you to refer to word objects without full declarations. The truth is all I need to do is to create a word document (which I know how to code), then assign the word document...
  9. CadMonkey

    Can I borrow your Module? Please???!

    :eek: Hi, I'm using access that handles some data and at the end of it all produces a ws mord document including pictures etc. I'm OK at VBA and am using to access functions of word. But I need to use the OfficeCodeBehind class which allows me to use the ThisDocument member. The only thing...
  10. CadMonkey

    Continuous Form Visible Controls

    Thanks for all your help people. I've ended up implementing Leo's solution, which functions well. The only snag is you can still see the control on every instance of the continuous form when you are on an "hd" item. Of course if you try and click the checkbox on a non-hd item .... well you...
  11. CadMonkey

    Continuous Form Visible Controls

    I do believe you can't conditionally format a yes/no checkbox, because I still can't use this feature. I was wandering if a VBA solution is possible- it just seems very tricky thing to do.
  12. CadMonkey

    Continuous Form Visible Controls

    Thankyou, but can you conditionally format on a form? The option seems to be greyed out to me... I'm using Access 2k though... Regards
  13. CadMonkey

    Continuous Form Visible Controls

    Hi, This is an intriguing one- and never thouroughly solved on this forum? I have a continuous form with records PK- [item_ID]. when this [item_ID] = "hd" it needs to make visible a yes/no control: [new] ..... BUT.... just on that one record on the continuos form, not on all of them! I can...
  14. CadMonkey

    Subtotalling

    Dude, I've just got your post- You are a stalliano- I've yet to implement but initially it looks purrfect. Many thanks El-mono
  15. CadMonkey

    Subtotalling

    THIS IS IMPOSSIBLE! subtotalling Hi, I have another problem a stupid monkey like myself cannot solve... I have a report that shows a Schedule- with items on it. Only one schedule is shown at a time, although there are many in my database. The report is grouped by schedule ID (though not...
  16. CadMonkey

    Subtotal on each page??

    THIS IS IMPOSSIBLE! page subtotals Hi, I have another problem a stupid monkey like myself cannot solve... I have a report that shows a Schedule- with items on it. Only one schedule is shown at a time, although there are many in my database. The report is grouped by schedule ID (though not...
  17. CadMonkey

    Calling a sub in a different form in VBA

    oops! No still need to access one forms sub from another... the reason is I'm trying to set the focus to a form so I can sort using this code: Work_Ref.SetFocus DoCmd.RunCommand acCmdSortAscending but I can't set the focus on the Work_Ref field from another form- that's why this sub is in...
  18. CadMonkey

    Calling a sub in a different form in VBA

    please see next post....
  19. CadMonkey

    Calling a sub in a different form in VBA

    Hi, I wander if anyone can help? Multiple web searches have turned up nothing! I would like to call a sub that is defined in form1. However, I am trying to call it from another form: form2. I.E In vb if use this code: call sub1 It says no sub defined, beacuse I'm calling it from form2. (The...
  20. CadMonkey

    Allow Only One Record Entry on Form

    I am probably Not Using Access in the best way I know but it's too make things simpler. I'm using a switchboard with a different form to add a record, another one to view old ones. I'm going for mega user friendliness, which is a hard thing to do because there's so many possibilities, wrong kep...
Back
Top Bottom