[AccessD] Open report from remote db

Jim,

The issue it appears is one of scope.  Queries running in an access
environment can see code inside of that container.  It cannot see functions
inside of the excel spreadsheet.  To my knowledge, while you can reference
the Excel libraries, you cannot reference code modules inside of
spreadsheets or workbooks (from within Access), nor code inside of documents
(word, from inside of Access).  That makes Access unique within office as a
container that can contain referencable code.  

IOW, I BELIEVE that you can reference an Access MDA from any of the other
office applications - Word, Excel, PowerPoint, and of course, Access.
However you cannot reference modules inside of a workbook from word,
PowerPoint etc, nor can you reference code inside of word documents from
inside of Excel, PowerPoint etc.


John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hale, Jim
Sent: Monday, April 16, 2007 3:31 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Open report from remote db

A number of years ago when I first started running Access queries from
inside Excel I found that I was unable to run queries with functions in the
database for criteria. I was told this was a limitation of VBA (I was using
office 97). Ever since then I have gotten around this by using sub queries
which get the criteria from a table, ie a pure sql solution. This thread has
me wondering if it is possible to use Access functions within queries
executed from within Excel by using different referencing?
Jim Hale 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D.TEJPAL
Sent: Monday, April 16, 2007 9:19 AM
To: Access Developers discussion and problem solving
Cc: A.D.TEJPAL
Subject: Re: [AccessD] Open report from remote db


Lonnie,

    Two alternatives are available as follows, for viewing / printing
reports & forms belonging to external db:

    (a) Library reference to external db:
    (i) In local db, set up library reference named "External" to the
external db and then call subroutines & functions belonging to external db
by using the qualifier "External." 
    (ii) In the code modules of external db, care is to be taken to use
CodeDb & CodeProject in lieu of CurrentDb & CurrentProject respectively,
wherever occurring.
    (iii) Automatic setting up of correct reference to external db can be
ensured programmatically, through code in start-up form of local db.

    (b) Access automation:
    Activate the external db via automation and toggle respective
visibilities of local & external db's appropriately, for user convenience.

    Two of my sample db's mentioned below, might be of interest to you:
    (a) ExternalDbAsLibraryRef
    (b) ExternalDbAutomation

    Both samples are available at Rogers Access Library (other developers
library). Link -
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Tejpal,A.D.
 
    You could adapt the underlying approach suitably, for your specific
needs.
 
Best wishes,
A.D.Tejpal

***********************************************************************
The information transmitted is intended solely for the individual or entity
to which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of or
taking action in reliance upon this information by persons or entities other
than the intended recipient is prohibited.
If you have received this email in error please contact the sender and
delete the material from any computer. As a recipient of this email, you are
responsible for screening its contents and the contents of any attachments
for the presence of viruses. No liability is accepted for any damages caused
by any virus transmitted by this email.
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com