Search results

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

Yes BE's are consistent, the main issue is that the NAMES are different. BE-a and BE-b FE-A is linked to BE-a FE-B is linked to BE-b FE is the base program but in order to get the data from either office I have to re-link the BE with the corresponding office. I usually work with FE-A and...

Because the BE is different. FE-A uses BE-a FE-B uses BE-b This done in my LAB, all paths are a mimic of the production. FE is exactly the same program, when I save (Compile "Make ACCDE") is when I do the work: If I am working with BE-a Just Compile "Make ACCDE" and save as FE-A to make the...

Thanks Doc, that is SORT OF what I want to do, the code assumes you have 1 BE and and when the EU uses the new FE re-links to the BE in that environment (or so I think). In my case I have 2 different FE files, I need to somehow send to the code which office I want to relink, depending on the FE...

I'll look for that code.. thanks. And yes that is exactly what I have: From Post #1: Work on my Test DB with a fictional BE [which mimics the production one, up to the path exactly], Thank you.

I did search: " link BE with VBA " No luck, I guess I don't know how to correctly search, sorry Doc and thanks, I will do it again maybe different wording.