Reusable Code

[Tom P.]

What are my options as far as writing some VBA code and
reusing it among multiple Access applications? I've
played with creating an MDB file with just VBA and
referencing it from other Access files and this works.
I've read a little about access add-ins but see no
advantage there.

Any thoughts or preferences on how to reuse code?

 

[Paul]

Yes...it is possible reference an MDB/MDE and it does allow for code reuse.
However, one note of caution. If you make any changes to the referenced
MDB/MDE, you must recompile any MDB/MDE that references it. Add-ins provide
an ability to create utilities for use within Access. Most of the wizards
in Access are in fact contained within a add-in library (utility.mda).

--
Michael Badnarik for President '04
Libertarian...the freedom party
www.lp.org
www.badnarik.org

"If you are in prison and your chances are 50% for execution by electric
chair, 45% for execution by lethal injection, and 5% for escape, are you
just going to vote for the chair because it is the likeliest outcome?" Vote
Libertarian and live to be free.

 

[Tom P.]

Thanks for the thoughts.

-----Original Message-----
Yes...it is possible reference an MDB/MDE and it does allow for code reuse.
However, one note of caution. If you make any changes to the referenced
MDB/MDE, you must recompile any MDB/MDE that references it. Add-ins provide
an ability to create utilities for use within Access. Most of the wizards
in Access are in fact contained within a add-in library (utility.mda).

--
Michael Badnarik for President '04
Libertarian...the freedom party
www.lp.org
www.badnarik.org

"If you are in prison and your chances are 50% for execution by electric
chair, 45% for execution by lethal injection, and 5% for escape, are you
just going to vote for the chair because it is the likeliest outcome?" Vote
Libertarian and live to be free.




.