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