Recent content by mloucel

  1. mloucel

    Access instance remains in memory once closed

    #3 worked perfectly for me, just a little change I did: Many times there are forms like LOGIN, were if you login successfully you have to close the form and continue, but as well I happen to have an EXIT button, besides the LOGIN button, when On Close event is triggered will equally trigger the...
  2. mloucel

    Access instance remains in memory once closed

    My apologies I did not read that post, somehow I skip it, yours is way more complete. Thanks.
  3. mloucel

    Access instance remains in memory once closed

    I found this jewel, I hope it helps for the rest of us that still have the problem: How to kill a process, by Richard Rost.
  4. mloucel

    Access instance remains in memory once closed

    Thanks Doc, I think I was a bit late in the night writting, what I meant to say was, that 1 application opened those 4 times, at least to my knowledge my app open once and then opens a splash, a login, a menu, and the menu has different windows depending on the needs of the EU. So yes you are...
  5. mloucel

    Access instance remains in memory once closed

    Hello everyone, I am not sure if this is going to help, finding the culprit of this behavior in access but look at the picture, I am trying to find out why the difference in the icons of access when closing, these are 4 different times, and the icons are different for all of them. I hope someone...
  6. mloucel

    Access instance remains in memory once closed

    Ok.. So the clue is here.. strComputer is a fixed object that we can easily do with vba code: Environ("ComputerName") I have to try this approach. NEVERMIND.. WHAT HAPPENS WHEN YOU DO NOT READ THE CODE ENOUGH TIMES.. The solution is right there in the code, OLD MSDOS trick: Dim strComputer...
  7. mloucel

    Access instance remains in memory once closed

    by rule of thumb, I always turn off my computer at the end of the day, [Yes fast startup is disabled], but the other tips are really good, I'll check.
  8. mloucel

    Access instance remains in memory once closed

    Sorry but I am confused in this line, can you explain: Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\\" _ & strComputer & "\root\cimv2") I've never worked with anything similar to that code, I understand is a vbs script and the logic i got it, but that line...
  9. mloucel

    Access instance remains in memory once closed

    I honestly never noticed, it was just after last week that I started to dig a bit more, my computer thou I have 32 g of ram, it was going slow and my application acted erratically, I was just saying is cache issues, or memory corruption, or too many things, so I was doing what I preach, RTDT...
  10. mloucel

    Access instance remains in memory once closed

    Windows 11 25H2 OS Build 26200.7628 Hate to say this but is happening to me as well, I assumed it was something I was doing, but I change my Exit code to: Application.Quit acQuitSaveNone 'CR As you suggested, but strange enough it happens, very frequently I would say 8 of 10 times, access...
  11. mloucel

    Using VBA? [My THINKING] to LINK a BE

    Thank you: @isladogs , @GPGeorge , @DHookom and @Ken Sheridan . Not going to be easy for me, I am going to start playing with the code, I really appreciate your wisdom, I am truly listening to all of you, I do understand the ability to let the EU pick their BE with a new update, but for my...
  12. mloucel

    Using VBA? [My THINKING] to LINK a BE

    Yes I got that one as well, thanks .
  13. mloucel

    Using VBA? [My THINKING] to LINK a BE

    Thank you Ken.
  14. mloucel

    Using VBA? [My THINKING] to LINK a BE

    Thank you Ken, I have checked also what Colin sent me, so far I think your approach is simpler and easy to follow, I am trying both codes, but I suspect that with a little bit of tweak I can work with your code, I want to avoid, completely any interaction with the EU, I need the code to do it...
  15. mloucel

    Using VBA? [My THINKING] to LINK a BE

    Thank you Sir.,
Back
Top Bottom