No code being displayed on lAccess Visual Basic Screen.

Question

Worked in my Access Database yesterday and all was working fine. Today, when I go to my Visual Basic Screen, all my code is gone. The page is blank.

Answer 1

If your code is not displaying in the Access Visual Basic screen, it could be due to a few reasons:

1. Hidden Modules: Check if the module containing your code is hidden. You can unhide it to see if the code reappears.
2. Missing References: If your database has missing references, it may cause issues with displaying code. You can check for missing references by going to the Visual Basic Editor, selecting Tools > References, and looking for any marked as MISSING.
3. Corrupted Database: Sometimes, the database itself may become corrupted. You can try to compact and repair the database by going to Database Tools > Compact and Repair Database.
4. Access Settings: Ensure that your Access settings haven't changed, which might affect the display of your code.

If these steps do not resolve the issue, consider restoring from a backup if available.

---

References:

• Visual Basic for Applications (VBA) functions break in a database with missing references

Answer 2

Hi @George Stacy

Thank you for posting your question in the Microsoft Q&A forum.

Based on the information you described, I understand that your Access Database was working fine yesterday, but today, when you open the Visual Basic screen, the page is blank, and no code is being displayed.

To help me better diagnose the issue, could you please answer a few questions?

• What version of Windows and Microsoft Access are you currently using?
• When you are in the Visual Basic Editor, please try going to the View menu. What happens if you select Properties Window, Project Explorer and Code (as shown in the image below)? Do the windows reappear?

• If possible, could you please send me a screenshot of your Visual Basic screen via Private Message?

In the meantime, please try setting the folder containing your database as a Trusted Location. Sometimes security settings can block the code from loading.

1. Open Access and go to File > Options.
2. Select Trust Center > Trust Center Settings.
3. Select Trusted Locations.
4. Click Add new location...
5. Browse to the folder containing your .accdb file and add it.
6. Restart Access and check if the code appears.

Please provide the additional details so I can assist you further.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".   

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Please provide a screenshot of the Navigation Pane, showing modules. It'll look like this (with fewer modules, of course).

Also, as previously requested, show us a screenshot of your VBE, it should look something like this (again, with fewer modules):