[AccessD] Open report from remote db

Alright, Lonnie.
I think the simplest method would be to create a public function
in the referenced database that tells the report to open.
Then it doesn't matter where you call it from, it just pops up.

Michael R. Mattys
MapPoint & Access Dev
www.mattysconsulting.com
  ----- Original Message ----- 
  From: Lonnie Johnson 
  To: Access Developers discussion and problem solving 
  Sent: Sunday, April 15, 2007 9:01 PM
  Subject: Re: [AccessD] Open report from remote db


  Thanks for the tip. I have set a reference but do "see it" as you say. I may need a little more hand holding. Never had to do this before.
   
  May God bless you beyond your imagination!
  Lonnie Johnson
  ProDev, Professional Development of MS Access Databases
  Visit me at ==> http://www.prodev.us




   



  ----- Original Message ----
  From: Michael R Mattys <mmattys at rochester.rr.com>
  To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
  Sent: Thursday, April 12, 2007 10:23:10 PM
  Subject: Re: [AccessD] Open report from remote db


  Hi Lonnie,

  Set a ref to that mdb and you should be able to 'see' it to call it.

  Michael R. Mattys
  MapPoint & Access Dev
  www.mattysconsulting.com
    ----- Original Message ----- 
    From: Lonnie Johnson 
    To: AccessD solving' 
    Sent: Thursday, April 12, 2007 11:14 PM
    Subject: [AccessD] Open report from remote db


    Can you open a report in one database from another database? 
     
    I know how to get the data from a query or table in another database with...
     
    "SELECT * FROM TABLE/QUERYMAME IN 'C:\MYDB.MDB'"
     
    Any help?
     
    May God bless you beyond your imagination!
    Lonnie Johnson
    ProDev, Professional Development of MS Access Databases
    Visit me at ==> http://www.prodev.us




     



    Sucker-punch spam with award-winning protection.
    Try the free Yahoo! Mail Beta.


           
    ____________________________________________________________________________________
    Don't pick lemons.
    See all the new 2007 cars at Yahoo! Autos.
    http://autos.yahoo.com/new_cars.html 
    -- 
    AccessD mailing list
    AccessD at databaseadvisors.com
    http://databaseadvisors.com/mailman/listinfo/accessd
    Website: http://www.databaseadvisors.com
  -- 
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com

  __________________________________________________
  Do You Yahoo!?
  Tired of spam?  Yahoo! Mail has the best spam protection around 
  http://mail.yahoo.com 
  -- 
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com