Search results

  1. BlueSpruce

    Access Stability

    I guess you can categorize an organization with 19 hospitals as a government. I think some heads are going to roll if they don't fix this soon. Production has been at a standstill.
  2. BlueSpruce

    Access Stability

    I would think anybody in their right mind would thoroughly test Win11 with everything else before upgrading 2,500+ workstations.
  3. BlueSpruce

    Access Stability

    Yes, its all setup as you described. The issue here is with the Citrix Workspace software. All 2,500+ workstations cannot communicate with the server. IT has been working on this for several hours. They recently upgraded all workstations to Win11 Enterprise. Maybe there's issues with 11 and Citrix?
  4. BlueSpruce

    Access Stability

    😁 Yeah, I searched for anything Access Citrix and this relic thread popped up. I saw Pat and MrsGorilla's (Rat Race Participant) replies lol
  5. BlueSpruce

    Convert old DB

    I scanned the entire file and didn't see any Personal Info
  6. BlueSpruce

    Access Stability

    We have 2,500+ workstations running Office365, Sharepoint Colab, some siloed departamental Access apps, ERP/EHR, PACS, and other tools accessed via Citrix Workspace. It was all stable until IT pushed out Win11 to all workstations, which are not all the same. So I'm theorising variety of NIC...
  7. BlueSpruce

    Convert old DB

    I didn't and wouldn't upload that file to the forum, the OP did, and if it were up to me, I would remove it from the OP's post to ensure there's no potential fallout.
  8. BlueSpruce

    Using VBA to find perfect numbers, and accurately calculate pi to 100,000 decimal places.

    Seen the movie 6 times, and counting. For John Glenn's re-entry they needed very precise calculations for the landing coordinates near the USS Randolph (CV-15) aircraft carrier. I cannot think of any practical applications that would require pi acuracy of more than 30 decimal places. However...
  9. BlueSpruce

    Using VBA to find perfect numbers, and accurately calculate pi to 100,000 decimal places.

    That was a very interesting read of how string theorists accidentally discovered a very fast way for calculating pi. It inspired me to find a faster way for finding perfect numbers, and I have achieved at least six orders of magnitude, (Million times faster), from the original method I was...
  10. BlueSpruce

    Using VBA to find perfect numbers, and accurately calculate pi to 100,000 decimal places.

    Accurately calculating pi to nth decimal places has been a classic computing topic for hundreds of years. I remember an IBM 7090 being used to calculate pi to 100K places, and now there's supercomputers that do it to billions of decimal places. When dealing with very large numbers, most...
  11. BlueSpruce

    Convert old DB

    Although the file's timestamp is more than 30 years old, according to the OP it contains personal information. Would AWF be liable if we discover the file was illegaly obtained, helped the OP to open the file , and then something bad happens to people mentioned in that file?
  12. BlueSpruce

    Using VBA to find perfect numbers, and accurately calculate pi to 100,000 decimal places.

    In my other Watercooler post about "Showcase Your Relics" I mentioned the first basic program I wrote in high school for finding perfect numbers. The thread detoured into that topic when I posted vba code to find perfect numbers. So I am forking this new thread to continue with that topic here...
  13. BlueSpruce

    Showcase Your Relics!

    Understood Yeah, as the loop increments the number being evaluated, the more divisors it has to examine to see which one's are integers, add them to the running total, and compare the final sum to the number being evaluated to see if it's a perfect num. Try 33,550,336 to 33,550,336 to see if...
  14. BlueSpruce

    Showcase Your Relics!

    Oops, I must have accidentally commented that line when posting the code. Your results for 2 to 100K are valid because there's no perfect numbers between 8,129 and 100K. The next perfect number is 33,550,336. That one has many whole number divisors. You can set min to 1 number below that num...
  15. BlueSpruce

    Showcase Your Relics!

    That's fast. Try 2 to 100,000. Where did you find the bug?
  16. BlueSpruce

    Showcase Your Relics!

    Reminds me of an ICL mainframe.
  17. BlueSpruce

    Showcase Your Relics!

    Any challenge takers to see how long it takes for your machine to run the above code? I'm curious to see how fast your machines CPU's can crunch those nested loops. I scaled down the run to 29,999 numbers. Processing 100K might take too long. CAVEAT: If you overclocked your cores, make sure you...
  18. BlueSpruce

    How to register library/reference from vba code?

    You still have to register the underlying COM DLL on the target machine where the app is going to run. Windows needs to know how to locate and instantiate the COM component at runtime. The type library file only provides the interface definition, it doesn't replace the need for COM registration...
  19. BlueSpruce

    How to register library/reference from vba code?

    Yes, I had edited my previous post that mentions what you just said.
  20. BlueSpruce

    How to register library/reference from vba code?

    I developed an app with Ac2010 that references the 14.0 Office Library, it will work with newer Ac versions without me having to change that ref because it auto refs the newer libraries. I have the following code behind a command button, in an app I plan to soon deploy, for users to pick a...
Back
Top Bottom