I have been fighting this problem for some time so it's time to ask for help!
The problem I am having is inconsistency in how macros operate from one end user machine to another.
For example on my development machine a particular macro runs fine no matter how many times I run it. On another user machine clicking the same button that runs the same macro generates an error code generated by running the macro that usually says the function is not supported or similar. In most every case the function is a relatively simple one that IS supported and should give no grief.
Things I have tried:
1) Recompiling the code on the form that calls the macro
2) Testing the functionality of the macro step by step to ensure correctness
3) Decompiling the entire application using run msaccess.exe /decompile and then using Alt- F11 to recompile all of the code in the application and then compiling the application into a runtime.
No matter what I try these problems keep re-occuring - isn't always the same version of the application, isn't always the same macro - just whatever macro on whatever machine that Access decides to screw up.
The end users are using compiled (runtime) versions of the applications - when compiled and tested on my machine and some other machines the macros work fine - on other machines you will get an error.
We have checked to make sure that the OS versions and updates are the same all to no avail. All machines working and otherwise are running Win 10 V1803 with the 2019-02 update.
The Access version is 1902 Build 11328.20146 and is part of Office 365
So if anyone can suggest what is causing this situation I would be grateful!
Thanks in advance for any help