Recent content by mloucel

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...

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...

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...

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.

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...

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...

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...

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...

Yes I got that one as well, thanks .

Thank you Ken.

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...

Thank you Sir.,

Thanks Colin, I was able to get a hold of an old friend, who point me towards the right direction, I am currently working on it, and IF IT WORKS, I;ll be more than happy to post the code, for others to check and maybe could be of use for someone else. And yes unfortunately as you said I do not...

-- Two offices in same org, same network? What does "100% similar" mean? -Yes same Network and data files are exactly structurally the same except for the data. -- If same table structure why not 1 BE and apply filters appropriate for user? Due to administration restrictions databases MUST be...

Thanks, I understand your logic, 2 points: 1) Managers in the office want to have access to BOTH data so the reason I created 2 programs. --- I fully understand that thru the way you explain this it could be possible maybe at the splash level or somewhere in between to have somehow a dropdown (I...