[AccessD] running code in a database without referencing the db

As an attempt at a possible solution, I defined a function that was called 
by a query in mdb1.  I then created a query in mdb2 named functionName with 
an IN clause that referenced the query in mdb1 and it returned an "Undefined 
function 'functionName' in Expression' message.  I then defined a different 
function with the name 'functionName' in mdb2 and ran the query in mdb2 and 
the resulting recordset used the calculation from mdb2 while the function in 
mdb1 was not called.

In any event, using a query with a calculated field that calculates one time 
is not able to call a function in its own container mdb as I had thought it 
might.  The function must be defined in the application.  I can't imagine 
any other way of trying this without a reference to the container 
application.  Good luck but you will probably have to create the reference 
on the fly.

Hen

>From: "John Colby" <jcolby at colbyconsulting.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "AccessD" <AccessD at databaseadvisors.com>
>Subject: [AccessD] running code in a database without referencing the db
>Date: Thu, 6 Nov 2003 13:08:20 -0500
>
>Is it possible to call a function in another database without referencing
>that db?
>
>John W. Colby
>www.colbyconsulting.com
>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.  
http://join.msn.com/?page=features/virus&pgmarket=en-ca&RU=http%3a%2f%2fjoin.msn.com%2f%3fpage%3dmisc%2fspecialoffers%26pgmarket%3den-ca