Run VBA function in one mdb from another mdb

[Sheryl]

I would like to have an Access database with a switchboard that runs
functions and macros in another Access databases. Ooperations are done on
Tables in the other database.

Specifically, I have two databases A.mdb and B.mdb. A.mdb builds some
complicated tables. B.mdb has some tables that link to tables in A.mdb. It
does complicated testing of those tables, and manages an upload to a network.
I'd like a database C.mdb that runs functions in A.mdb and B.mdb. Maybe even
pops up forms in A.mdb. C.mdb will have no tables of its own.

Thanks.

 

[Tony Toews]

I would like to have an Access database with a switchboard that runs
functions and macros in another Access databases. Ooperations are done on
Tables in the other database.

Specifically, I have two databases A.mdb and B.mdb. A.mdb builds some
complicated tables. B.mdb has some tables that link to tables in A.mdb. It
does complicated testing of those tables, and manages an upload to a network.
I'd like a database C.mdb that runs functions in A.mdb and B.mdb. Maybe even
pops up forms in A.mdb. C.mdb will have no tables of its own.

The term you're looking for is add-ins. The trouble is doing searches
on words with hyphens is very troublesome as quite often such searches
will look for all pages with the word add but don't have the word in.

See my Add-in Tips, Hints and Gotchas page at
http://www.granite.ab.ca/access/addins.htm

You can only call subroutines and functions from within add-ins so if
you want to open a form you'll have to call a subroutine which in turn
open the form.

Thus if you have no control over A.mdb or B.mdb to add thus kind of
functionality you won't be able to do this.

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