[AccessD] Export a report in another database

Lonnie Johnson prodevmg at yahoo.com
Thu Oct 23 07:30:21 CDT 2003



Forgive me for my lack of clarity. My mind was going but my fingers were not. I have database A and B. I want to write a VBA procedure in database A that will export a report in database B to a snapshot file.


Charlotte Foust <cfoust at infostatsystems.com> wrote: Export what, the object or the report it generates? It isn't clear
exactly what you want to do. Is the code supposed to execute in
database A to open database B and do something there? Is database B
open or being opened at all, or what?

Charlotte Foust

-----Original Message-----
From: Lonnie Johnson [mailto:prodevmg at yahoo.com] 
Sent: Wednesday, October 22, 2003 12:59 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Export a report in another database




Actually I am writing code in database A and want to export a report
object that is in database B.



Charlotte Foust wrote: Is
DoCmd.TransferText what you're looking for?

Charlotte Foust

-----Original Message-----
From: Lonnie Johnson [mailto:prodevmg at yahoo.com] 
Sent: Wednesday, October 22, 2003 10:36 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Export a report in another database




I can't put my finger on this one. How do I programatically export a
report in another to a file such as snap shot or word?

Thx, I'm sure it's simple, I've never had a need to do and just can't
seem to find the process. 


Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us









---------------------------------
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
_______________________________________________
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



Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us









---------------------------------
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
_______________________________________________
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



Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us




 




---------------------------------
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search


More information about the AccessD mailing list