Others

How to Use Shared VBA Functions in Microsoft Access Builder

WPS Content Manager Oct 10, 2026 869 views

Question details

The user wants to know if Microsoft Access can utilize VBA functions stored in an externally referenced database and how to resolve the issue where these functions do not appear in the Builder's autocomplete.

How to Use Shared VBA Functions in Microsoft Access Builder

Product: Microsoft Access
Device & OS: not provided
Scenario: Managing shared VBA code and error handling across multiple Microsoft Access database projects.
Observed behavior: Functions stored in referenced modules function correctly but do not appear in the Access Builder's autocomplete dropdown, leaving users unsure of how to invoke them properly.

Before you start

Ensure that the external database containing your shared VBA functions is correctly referenced in your current Microsoft Access project via the VBA Tools menu.

Solution 1Recommended

Manually Enter Shared VBA Functions in the Builder

Since referenced functions do not trigger the autocomplete feature in the Access Builder, you must type the function names and their arguments manually.

Although the autocomplete feature fails to display functions from referenced library databases, the Access Builder fully supports executing them. Bypassing the autocomplete behavior by typing out the command is the simplest and most direct workaround.

Open the Access Builder

Launch the Microsoft Access Builder in the specific form or query where you intend to use the shared VBA function.

Type the function name manually

Instead of waiting for the autocomplete dropdown to populate, manually type the exact name of the VBA function as it is defined in the referenced database module.

Provide the required arguments

Carefully type in the necessary arguments for the function exactly as required by the shared code's parameters, then save your changes.

Manually Enter Shared VBA Functions in the Builder

Solution 2

Use Project Explorer to Verify Referenced Code

Use the VBA Project Explorer to review objects, modules, and code syntax within the referenced database before typing them in the Builder.

Free Microsoft Office alternative

Try WPS Office for Your Data and Spreadsheet Needs

While Microsoft Access is used for complex relational databases, you can easily manage extensive data lists, build reports, and run VBA macros using WPS Spreadsheet. WPS Office is a highly compatible, lightweight, and completely free alternative for your daily productivity and data management tasks.

1. Download the software: Visit the official WPS Office website and download the free installer for your operating system.
2. Install the application: Run the setup file and follow the on-screen instructions for a quick, hassle-free installation.
3. Manage your data: Open WPS Spreadsheet to seamlessly organize data, utilize formulas, and run VBA scripts just as you would in Microsoft Excel.

Fully compatible with Microsoft Excel (.xlsx), Word, and PowerPoint formats.Supports advanced spreadsheet data management and VBA macros for automation.Lightweight software architecture that runs smoothly on almost any device.Familiar tabbed user interface allowing for a seamless migration from Microsoft Office.

microsoft office alternative - wps office

Frequently Asked Questions

Why aren't my referenced VBA functions showing up in the Access autocomplete?

Microsoft Access Builder does not inherently support the autocomplete (IntelliSense) feature for functions stored in externally referenced database modules. This is a known limitation of the Builder UI, even though the functions themselves execute perfectly.

Can I share error handling code across multiple Access databases?

Yes, you can place your shared error handling routines and common VBA code inside a centralized, referenced Access library database to seamlessly use them across multiple different database projects.

How do I correctly reference another Access database in my VBA project?

Open the VBA editor by pressing ALT + F11, click on Tools > References in the top menu, and browse your computer for the external Access database (.accdb, .mdb, or .accde) you want to link to your current project.

Office Quick Solutions