Search results

  1. Y

    Loop through Form Objects

    Hi Mark, Thanks for the quick reply. I have been working today on modifying code to change labels on a new form. I am not a masterful programmer, but I am enclosing what I have done for your review. It may be crude, but now does what I am looking to do. I am sure it can be more elegant, but...
  2. Y

    Loop through Form Objects

    I want to thank you for the code. I so study it and adapt as I can. Can you help me understand these lines If ctl.Name = "theNameOfLabel" Then frm("theNameOfLabelHere").Caption = "xxxx" End If I don't understand the first 2 of the 3 lines above...
  3. Y

    Loop through Form Objects

    Hi, I am looking for suggestions and direction, so I can develop a function to allow me to loop through my forms and change names on labels etc. Any suggestions are welcome. Thanks yianni
  4. Y

    What's your best/worst joke?

    If it is appropriate, you may post it. Four old retired men are walking down a street in Yuma, Arizona . They turn a corner and see a sign that says, "Old Timers Bar - ALL drinks 10 cents."They look at each other and then go in, thinking this is too good to be true. The old bartender says in a...
  5. Y

    What's your best/worst joke?

    Congratulations! You have me by 1. I have 1 granddaughter and 1 grandson. They are great to be with. Playing games we haven't played in 30-40 years. Old fashion Monopoly etc.
  6. Y

    Help with vba code

    I am enclosing a screen clip of results. It certainly picked up the A and C as needed. However; why does it not start at the 1's? What did you do to pickup up the A's? You are on the right track! 168 A 171 A 174 A 176 A 176 C 178 A 178 C 178 C 179 A 179 C 179 C 179 C 181 A 181 C 181 C 181 C...
  7. Y

    What's your best/worst joke?

    By a little. 76 and 5 months
  8. Y

    What's your best/worst joke?

    I'll bet I am older than you, but haven't seen it (maybe I don't remember) :-)
  9. Y

    What's your best/worst joke?

    I will send in a couple. Thanks
  10. Y

    Help with vba code

    A single table no joins.
  11. Y

    Help with vba code

    It is a table. ID_fk is a number and PC is text
  12. Y

    Help with vba code

    Hi, I need some help with my code. The following was copied from my screen when I opened the table directly ID_fk PC ClientType 1 A REP 1 C 1 C 1 C 1 C 1 C 1 C 1 C 2 A REP 2 C 2 C 2 C 2 C 2 C 4 A REP 11 A REP 11 C 13 A REP 13 C 14 A REP 18 A REP 19 A REP 19 C 19 C 19 C 19 C...
  13. Y

    What's your best/worst joke?

    Lightened my mood. Worth keeping! Thanks
  14. Y

    What computer

    Thanks for the prompt reply. I was just curious as to what make/model of computer you were using and whether you recommend it as a good one for Access programming. Thanks
  15. Y

    What computer

    Can you tell what computer you use?
  16. Y

    What computer

    I have been having issue with my AltF11 and F8 keys. I noticed that many new laptops do not have Pause/Break key. Do you know which laptops have the necessary Keys for programming in Access?
  17. Y

    Group Sum Calculation Works on First Set of Data Only

    I have a similar problem and hope you can help. I have a report which counts and calculates properly. After I add it to another report as a subreport the counts per Town are correct but the percent calculation is done on the grouping TOWN. countinTown/totalcount Can you show me how to fix it...
  18. Y

    Passing Variables

    Thanks so much. I got it to work. Now to clean it up and see what I can do. Your help is greatly appreciated.
  19. Y

    Passing Variables

    I am submitting my Code crude as it is. Thanks
  20. Y

    Passing Variables

    I will do that, thanks
Back
Top Bottom