Printing a report from another database.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I currently have a database that is my "automated" coding to open another
database, run several codes to import tables, run queries and make a
finalized report. Well within my "automated" database, I want to completely
make it automated and also print out the report that is made in the other
database. How would I go about doing this? My current code is

DoCmd.OpenReport "L:\ and the rest of the path"

I was figuring by just adding the full pathname it would print out that
report from the specific database I entered, but I get the error message
stating "could not find report" etc. Could anyone please help me, is this
even possible?
 
Hi,
you have to start new access instance, open otehr database there and then
prinet a report. i believe that you can find a sample code at
www.mvps.org/access
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Access Report Works on One Machine but not Another 3
EMailing a report in Access 2003 3
Opening report in another database 2
Send report to Fax 1
Can't get this code to work properly to print 1
Open another database and close the current one 3
Sharing Database 1
Reports from an unbound database 2

Back
Top