Search results

  1. K

    Transgenders in Olympics

    The Olympics officially bans all transgenders from competing in female competitions. I wonde if they cancel all the records made by them too. https://www.aa.com.tr/en/sports/transgender-women-to-be-banned-from-all-female-olympic-events-after-scientific-review-report/3740472...
  2. K

    Pat Hartman has left the building

    I think there's a difference between "caring for others" and "pleasing others". Maybe I failed to show how I think, even though I used "Care" multiple times. Can you guarantee that your idea of what’s right and decent is truly correct? Isn’t it possible that those who do wrong, also act from a...
  3. K

    Solved How to Update a recordset without a loop?

    I think it's the simplest way. Thanks for your time and help. I really appreciate it.
  4. K

    Solved How to Update a recordset without a loop?

    Thanks again for your time. I'll test both, first thing on Monday when I'm back to my desk.
  5. K

    Solved How to Update a recordset without a loop?

    Unfortunately it's not a filtered form, but a form with Data Entry set to Yes. I'm actually using the method you explained in other forms. For this specific situation, I was trying to find a way not to work on the recordsetClone of the form, specially in a loop (Because of screen flickerings)...
  6. K

    Solved How to Update a recordset without a loop?

    The recordset is : Set rs=Me.RecordsetClone It's a copy of the recordset of the form opened for user to work on. The only way to be prepared, is to check all the order sheets one by one to see if the contents are met with a business rule. I can not ask someone to check all sheets at the start...
  7. K

    Solved How to Update a recordset without a loop?

    I'm sorry. I don't understand what you're trying to tell me. The same userID may have thousands of records in the table (previous days, previous hours). A user is handed a 50 order sheets. He opens a continous form and starts registering data. Let's say while entering the 30th order, a specific...
  8. K

    Solved How to Update a recordset without a loop?

    I have a continous form that is used for saving new records. Ater a few input, or 20 or more, if a specific condition is met, I have to update a field named "Identifier" of all data which have been saved by this user. So, the only thing that I have is Set rs = me.recordsetclone Then, loop...
  9. K

    Solved How to Update a recordset without a loop?

    Transaction is a new world for me. But it's never too late to learn something. I'll try it Monday morning as soon as I'm back to my desk to see if it can be used. Thanks for your time.
  10. K

    Solved How to Update a recordset without a loop?

    A question just for clarification. If one has to loop through the recordset, how updatebatch can be useful. I mean while looping, a simple line .fields("X")="Y" is enouh.
  11. K

    Solved How to Update a recordset without a loop?

    If I have a DAO recordset, can I run an update on the recordset to update a field in all records , instead of using a loop and update one record at a time? Something like an update query, but the object being a recordset instead of a table. Thanks
  12. K

    Pat Hartman has left the building

    I try to be nice because I care about how people see my personality. I try to be polite because I don’t want others to think I’m rude. I wake up every morning 30 minutes earlier to take a shower, shave, and brush my teeth, so that others feel comfortable when talking to me. I wear decent...
  13. K

    Will China Beat US?

    Nvidia’s CEO explained why China could soon lead the global AI race Jensen Huang, CEO of Nvidia, said China’s massive market, deep research talent, and fast AI adoption across daily life give it a unique advantage over the United States. He noted that around half of the world’s AI researchers...
  14. K

    How to always set focus on the control on parent form after entering data in the subform

    It will. The AfterUpdate will fire even if there's only one text box in a form. Give it a try. I'm at work and haven't time to read all the rest of your reply. I'll check it during lunch time. Thanks for taking your time and replying.
  15. K

    How to always set focus on the control on parent form after entering data in the subform

    While I enjoyed reading your reply, may I ask why you suggested above? You can have a form with only one text box, and when you type something and press Enter (or scan a barcode that ends with Enter), the AfterUpdate event still fires, even though there’s no other control on the form for the...
  16. K

    Solved conditional formatting duplicates

    It doesn't work when you have two (or more) sets of duplicates: (If I understand the request correctly) Also, If it's triplicate (instead of duplicate), only the second one is red. The third one remains normal) Whether it's what OP requires or not, I don't know.
  17. K

    Shoei Ohtani

    And now social media is filled with comments saying the whole series was rigged. It seems that so many people believe there's no way US allow a non-American team win the series.
  18. K

    Shoei Ohtani

    I'm only 8 years into English, and my understanding may be wrong. For me: The word “world” doesn’t always literally mean “the entire planet” or “all countries.” In many contexts, it’s used figuratively and means a specific area, group, or way of life. Fashion world, Tech world, or likewise words...
  19. K

    Pat Hartman has left the building

    At least, It's a relief.
  20. K

    Shoei Ohtani

    Unfortunately they lost 2 games at home. It's hard to win both remaining games away.
Back
Top Bottom