VBA, Calling module in a Database from another Database!

Calling module in a Database from another Database!

Author	Message
Peter Meulendijk #1 / 2	Calling module in a Database from another Database! Mike, Once you have set the reference, you can call any procedure in worldwide.mdb as if it were in overall.mdb (provided of course you have public functions in your code) Function mp() sRunCARmp() End function Cheers, Peter Quote: > In Access, I have been trying to call a module in one of my > databases called Mckinsey worldwide.mdb from another one of > my databases called Overall.mdb. I have been refered > previously to reference Mckinsey worldwide.mdb in my > Overall.mdb. I attached a document showing how I did that. > I am still having problems calling it. Would you be able to > help call it? > Thank You, > Mike
Sun, 28 Dec 2003 04:50:57 GMT

Tony Toew #2 / 2	Calling module in a Database from another Database! Quote: >In Access, I have been trying to call a module in one of my >databases called Mckinsey worldwide.mdb from another one of >my databases called Overall.mdb. I have been refered >previously to reference Mckinsey worldwide.mdb in my >Overall.mdb. To add to Peters comments there are some quirks when it comes to MDEs. An MDE can't reference an MDB. And you can't update the referenced MDE without also updating the calling MDE. Tony ---- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Wed, 31 Dec 2003 08:32:45 GMT

Page 1 of 1

[ 2 post ]