When I save a system as a ACCDE file for use by users, some functionality is lost. A simple Macro, which closes existing form and opens a New form fails, but a similar Macro opening a differnt form works OK. Has anyone any experience of this??
Novice
Windows 10 
Access 2016
When I save a system as a ACCDE file for use by users, some functionality is lost. A simple Macro, which closes existing form and opens a New form fails, but a similar Macro opening a differnt form works OK. Has anyone any experience of this??
Access Developer
Windows 10 Access 2016
What happens if you use vba instead of macros
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
Novice
Windows 10 Access 2016
Not skilled with vba, as novice user.
Access Developer
Windows 10 Access 2016
If the macros are run from within a form (button click event), then in design view, there is wizard available to convert macros to vba.
Make a backup first, of course
If this helped, please click the star at the bottom left of this posting and add to my reputation
Bob Fitzpatrick
Virtually Inert Person
Windows 10 Access 2016
If some macros run but not others, it's likely not a Trusted Locations issue. Your situation is not clear.
The macro does nothing?
It closes one but doesn't open the next?
No error message raised?
It works for some users but not others?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Posting Permissions
Reply With Quote