Forum Discussion
Inconsistent MS Acess form behaviour
A form with a subform that I have built in Access via my recent Office 365 subscription opens inconsistently. It opens correctly on both Windows 11 machines running Access 2007-2016 (office 365?) I have tried it on and also on a windows 10 machine running Access 2007. But on my older laptop with windows fully updated, running windows 10 and Access 2010 and also on the two machines I need it to work on, windows 7/10 machines (I need to check OS if necessary) but running very recent downloads of Access via current Office 365 accounts, it doesn't open properly. The issue is consistent on the three machines where it fails. In form view, the main form header is displayed but the main form detail is missing. The subform is displayed but the navigation buttons for that are missing. In design view the form is as it was built! I have looked at different forums but because the form doesn't need fixing on three of the machines I have tried it on I don't know what to try to fix! I have built the database for a charity and they need it quite urgently. Please help!
3 Replies
- what are the Errors you encounter.
are you using API calls?
do you use it on x32 and x64 Office?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!
- It 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.
