Using a centralized VBA module in multiple Access databases

by

Don’t worry, it’s quite simple.

  1. Make your “helper” database. Put a few procedures in there.
  2. In your ‘client’ databases, open the VBA Editor
  3. Go to Tools->References. Browse and select your helper database.
  4. Done! You can now use all the functions in your helper database throughout your client databases.

So… no .dll files to worry about. No Visual Studio needed.

More Related Contents:

  1. How does one decompile and recompile a database application?
  2. What are the rules governing usage of parenthesis in VBA function calls?
  3. Autonumber value of last inserted row – MS Access / VBA
  4. Code to loop through all records in MS Access
  5. Bang Notation and Dot Notation in VBA and MS-Access
  6. How do I force VBA/Access to require variables to be defined?
  7. VBA: Difference in two ways of declaring a new object? (Trying to understand why my solution works)
  8. How to diagnose MS access crashes
  9. Equivalent cURL in VBA?
  10. How do I access the selected rows in Access?
  11. Run-time error ‘3061’. Too few parameters. Expected 1. (Access 2007)
  12. Prevent enabling of shift bypass – Access 2010
  13. VBA procedure to import csv file into access
  14. Transform multiple rows into columns with unique key
  15. how to show query results in a datasheet in the same form?
  16. Access VBA: Find max number in column and add 1
  17. MS Access prepared statements
  18. Create sequential ID value based on the year that a record is added
  19. UrlDownloadToFile in Access 2010 – Sub or Function not Defined
  20. Null values for variables in VBA
  21. How to execute a query in ms-access in VBA code?
  22. How to add a menu item to the default right click context menu
  23. VBA – Run Time Error 3271 using DAO object
  24. Trouble with InputBoxes
  25. Get Name of Current VBA Function
  26. Is there any way to create multiple insert statements in a ms-access query?
  27. Save password for ODBC connection to MS SQL server from MS Access 2007
  28. How to write Case Sensitive Query for MS Access?
  29. Access – compare two tables and update or insert data in first table
  30. How to copy to clipboard using Access/VBA?

Leave a Comment