Forum Discussion
Inconsistent MS Acess form behaviour
are you using API calls?
do you use it on x32 and x64 Office?
- GXB16386May 08, 2023Copper Contributor
Thanks for your interest. I do not know what API calls are. I use only the wizard type features in Access and don't delve into the progamming.
There is no error message. The form opens in form view but displays only the main form header and the subform. The main form detail is not visible. There is a scroll bar on the right for the subform but the navigation buttons for the subform are missing (the navigation buttons for the main form are set to be hidden).
The details of the Laptop on which the database was built and on which the form behaves correctly
System type is a 64 bit operating system, x64-based processor. Operating system Windows 11 Home Version 22H2. OS build 22621.1555
Version of access Microsoft Office Professional 2021
I only have access to one of the machines on which the form fails to open correctly and for that the details are as follow.
System type 32-bit operating system, x64-based processor
Edition Windows 10 Home
Version 22H2
OS build 19045.2846
Version of Access 2007-2010 (as shown in the top bar when the app is open)
I hope this helps!
- George_HepworthMay 08, 2023Silver ContributorIt almost sounds like the problem machines are not finding the data in the bound tables. That behavior is consistent with opening a form with an empty recordsource (no records).
So try opening the tables directly on those computers where the problem exhibits itself.
Also, temporarily remove any filtering in the form(s) to see if they return records.