Automatically add module to new DB

[SimonB1978]

Hi,

Is there a way to configure Access so that it automatically adds a specific module (.bas file) when creating a new DB? Same thing would be useful for References...

Thank you,

Simon B.

 

[boblarson]

Not really. Not unless you create a special "create a database" database which then could have all sorts of code to do things.

 

[SimonB1978]

That's exactly what I did not want to have to do...

Thanks,

Simon B.

 

[Rabbie]

You could of course make a DB with just the Module and references in it. Then all you would need to do is to copy that file and use that when you build a new DB

 

[boblarson]

You could of course make a DB with just the Module and references in it. Then all you would need to do is to copy that file and use that when you build a new DB

OOOH - TEMPLATE - Boy, that is a good tip and so simple that even a cave man should have thought of it

 

[SimonB1978]

That's a good idea, not quite what I wanted, but that could do it

Thank you very much,

Simon B.

 

[gemma-the-husky]

one other thing you could also do is to have a separate database with your commonly used functions - add a reference to it in your database.

In some ways this is better, as if you change the library, all databases using the library will change automatically, without needing to change all the databases manually.

This depends of course on exactly what functions are in the library - obviously some changes may need you to change structures in the main database.

 

[AccessJunkie]

This feature is built right into Access 2007. See this page on my site for more information:
http://accessjunkie.com/faq_50.aspx

--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

 

[SimonB1978]

That's nice!!! this is exactly what I wanted, however we are not going to have Access 2007 at work anytime soon....

 

[Rabbie]

OOOH - TEMPLATE - Boy, that is a good tip and so simple that even a cave man should have thought of it

If its simple I can just about get there