How to Fix Access Switchboard Options and VBA Functions Not Working
Question details
The user needs to troubleshoot Microsoft Access switchboard buttons that fail to execute VBA procedures, macros, or queries properly without displaying error messages.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Attempting to run legacy switchboard commands in an inherited Access database stored on a portable drive, but the commands move wrong records or do nothing.
- Observed behavior
- Switchboard buttons fail silently without triggering error messages, resulting in incorrect data manipulation or no action at all.
Before making any modifications to VBA code or query structures, securely back up your entire Access database file to a local drive to prevent accidental data loss during testing.
Verify Database Trusted Locations in Access
Ensure that the portable drive or folder hosting your Access database is marked as a trusted location, which is required to allow VBA macros and procedures to run safely.
Microsoft Access often disables VBA code silently if the database is opened from an untrusted location like a portable drive. Adding the drive to the Trust Center will unblock these functions.
Launch Microsoft Access, click on the 'File' tab in the top left corner, and select 'Options'. In the Access Options dialog box, click 'Trust Center' on the left pane, then click the 'Trust Center Settings' button.
Select 'Trusted Locations' from the left menu of the Trust Center window. Here you will see a list of folders that Access currently trusts.
Click 'Add new location' at the bottom of the window. Browse to the specific folder on your portable drive where the database is stored. Check the box for 'Subfolders of this location are also trusted' if necessary, and click 'OK' to save.
Inspect Switchboard Event Procedures in the VBA Editor
Open the built-in VBA editor to review the code behind the switchboard buttons, identify broken commands, and test them.
Switch to WPS Office for Seamless Document Management
While WPS Office does not include a direct replacement for complex Microsoft Access databases, it serves as a highly efficient, lightweight, and entirely free alternative for your Word, Excel, and PowerPoint files. Experience seamless format compatibility and a user-friendly interface.
Frequently Asked Questions
Why do Access switchboard buttons fail without giving an error message?
This commonly occurs if the database is running from an untrusted location, which silently disables VBA macros for security reasons. It can also happen if the VBA script contains error-handling commands like 'On Error Resume Next', which suppresses alerts.
How do I find out what VBA is doing behind an Access button?
Open your database in Design View, select the specific button, and press F4 to open the Property Sheet. Go to the 'Event' tab and click the ellipsis (...) next to the 'On Click' event to view the exact VBA code or macro associated with it.
Can I run an Access database from a portable USB drive?
Yes, but you must manually add the portable drive's specific path to the Trusted Locations in the Access Trust Center (File > Options > Trust Center) on the host computer. Otherwise, security protocols will block macros and VBA functions from executing.
How do I compare code between an older working Access database and a broken one?
Open both databases simultaneously if your system allows, or open them one after the other. Press Alt+F11 to open the VBA editors, locate the specific form module in the Project Explorer, and visually compare the VBA scripts side-by-side to find discrepancies.
