[AccessD] Open report from remote db

Thanks. I guess I should have been more revealing. 

I have been asked to create a process by which the user can type in a database path and name into one field and a report name in another field, click a button and that report opens. So I will be adding references to the main database dynamically and through code and retrieving the report. It sounds like a pain but it's what they want. They are bent on certain conveniences like not having to open another database.

Does that help?
 
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: Sunday, April 15, 2007 9:23:16 PM
Subject: Re: [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
-- 
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