Reusable code for Access?

[elliotgr]

Is there a way to make reusable VBA/VB code for different Access applications, similar to the way references work ? I have tried writing Dll's using Express 2010 with no luck.

 

[RainLover]

I have a separate Database where I store snippets that may be usefull one day.

As far as being resuable I find that I need to change Names etc to suit the particular application I am working on at the time.

Over a period of years this has built into a large Library.

Hope this helps.

 

[Galaxiom]

Set a reference to the library database using the Browse button in the references dialog.

As far as being resuable I find that I need to change Names etc to suit the particular application I am working on at the time.

Well designed reusable code does not need the names changed.

 

[RainLover]

Galaxiom has the answer that you require, however I must add this rider.

The Database Reference Library should be placed on the Client, not the Server. (Except for the Master Copy)

If users link to the same Library it is the same as sharing a Front End.

Sharing a Library with other users can cause corruption.

You can however use the same Library for multiple Databases on the Client's machine without problems.