Problems once a record is retrieved to a form

[PrimoTenore]

I have a problem with Access. Once I retrieve a record to a form, tables/forms are no longer viewable or accessible via the navigation pane. If I click design mode on the open form, the options are invisible but by moving the cursor each option is displayed. Once the form is opened in designed mode, I cannot access any code or make any changes. Also, once I close the form, I still not access any objects. I can close the database, re-open it and all it fine until I retrieve a record. As long as I do not retrieve a record, I can access and objects via the navigation pane and make changes or read the tables. I moved my larger tables to separate databases but that has not helped. There are no errors messages.

 

[Jon]

Welcome to Access World! We're so happy to have you join us as a member of our community. As the most active Microsoft Access discussion forum on the internet, with posts dating back more than 20 years, we have a wealth of knowledge and experience to share with you.

We're a friendly and helpful community, so don't hesitate to ask any questions you have or share your own experiences with Access. We're here to support you and help you get the most out of this powerful database program.

To get started, we recommend reading the post linked below. It contains important information for all new users of the forum:

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We hope you have a great time participating in the discussion and learning from other Access enthusiasts. We look forward to having you around!

 

[theDBguy]

Hi. Since this is your first post since joining, Welcome to AWF!

Just FYI, I moved your thread out of the Introduction Forum to avoid any confusion.

 

[arnelgp]

upload your db for troubleshooting.

 

[The_Doc_Man]

First question: Which version of Office & Access are you using?

Second question: Get to the folder where your file is located. Right-click on the DB file. Select properties >> security. The file in question should have MODIFY access for your account. Now use the up-arrow in the folder's toolbar to get to the parent of the working folder. Right-click on the folder that holds your files. Again, select properties >> security. The folder in question should have MODIFY access for your account.

The selective locking of different parts, depending on what is open at the moment, suggests to me that the file locking code is struggling due to permission conflicts. Also, when you have this problem, is anyone else in the database at that time? Because improperly shared use could also lead to conflicts that cause abnormal behavior.

 

[PrimoTenore]

Thanks for the quick response. I am using Windows 11 with Office 365 (desk) but I had the same problem with Windows 10 and Access 2016. I am only person with access to the database. In terms of security, I have full authority. One other issue, once I retrieve a record, the navigation pane cannot be opened. I can retrieve as many records as I want. I just cannot edit any forms or open any tables.

 

[The_Doc_Man]

The only time I ever see a problem remotely close to that is if I try to open a bound form and then try to separately open the table to which the form is bound. I have no trouble opening other tables. It works the other way, too. If the table is open, the form doesn't want to open but other forms will open just fine. Regardless of which one is open first (table or form), the other object cannot be opened simultaneously. I'm on Office 2021 LTSC, not 365, and Win 11.

As to opening a code window, I debug code in which the form is open and a breakpoint opens the code window. I can also look at unrelated code from uninvolved general or class modules, so I don't know that I've ever seen the exact situation you mention. If I can't reproduce it, I can't debug it. I will have to wait for more information.

As a curiosity, is this a split database or a single-file (monolithic) database? And what is the file type of the app file? .MDB or .ACCDB? Or something else?

 

[arnelgp]

I just cannot edit any forms or open any tables.

what do you mean? navigation pane is not visible?
maybe some code is running on the form to hide the navigation pane, try pressing F11 key.

 

[Gasman]

I have a problem with Access. Once I retrieve a record to a form, tables/forms are no longer viewable or accessible via the navigation pane. If I click design mode on the open form, the options are invisible but by moving the cursor each option is displayed. Once the form is opened in designed mode, I cannot access any code or make any changes. Also, once I close the form, I still not access any objects. I can close the database, re-open it and all it fine until I retrieve a record. As long as I do not retrieve a record, I can access and objects via the navigation pane and make changes or read the tables. I moved my larger tables to separate databases but that has not helped. There are no errors messages.

Sanitize a copy of your DB id need be with https://www.access-programmers.co.uk/forums/threads/randomizing-data-for-posted-dbs.306745/ and upload it, or enough to se e the problem.
Could create a new DB and import first, just to see if that corrects it.

 

[PrimoTenore]

When the problem initially occurred, I split the db by moving the largest table to a new db. I created a new db and imported everything to it. Neither corrected the problem.

Once I open a form and retrieve data, I can create, save and retrieve all records that I want while the form is open without any issues. I can open any sub-forms that are associated to the form. I tried having tables opened and then opened the form and retrieve a record, those tables are "frozen" and I can not navigate or even refresh the data in the table. The navigation pane is hidden and pressing F11 does not open the pane.

I can re-open the form and retrieve as many records as I want and all is fine. But I cannot access any tables. If I want to access the tables, I have to close and re-open the db.

 

[Mike Krailo]

Did you try to do the Shift-Bypass on the database? When you launch the database, hold shift key and then double click the file to open it. This bypasses any startup code that might be affecting things adversely so you can troubleshoot the problem.

 

[PrimoTenore]

Did the shift-bypass. When the db opened, I opened the navigation pane and one table. I then opened the form and retrieved a record. The problem still occurs. I closed the form but I cannot close the open table nor can I select an object in the navigation pane.

 

[Mike Krailo]

I then opened the form and retrieved a record.

Don't do that. To troubleshoot, I would just go straight to code using Alt-F11. From there, open the page code for the form you are opening and see what events are being used. Maybe put a break point at the start of the On Open event or On Load event, whichever is being used. There has to be some code that is manipulating the interface. Just step through it and see what it's doing.

 

[MajP]

1. Can you compile the code in the VBA editor?
2. When this happens is the play button greyed out as if it is running?

2. Set the form so it is not not modal. May help troubleshoot.

 

[June7]

The_Doc_Man, I have no problem opening form and table at same time.

 

[Pat Hartman]

One other issue, once I retrieve a record, the navigation pane cannot be opened

This is not normal behavior so you need to look for any code you have that runs when a form opens.