Lonnie Johnson
prodevmg at yahoo.com
Thu Oct 23 07:43:52 CDT 2003
Got it.
'***** CODE START *****
Public Sub ExportReport()
Dim objApp As Access.Application
Set objApp = New Access.Application
objApp.OpenCurrentDatabase ("C:\Reporting.mdb")
objApp.DoCmd.OutputTo acOutputReport, "rptAccountHistory", "Snapshot Format", "C:\NewSnapshot.snp"
MsgBox ("Done!")
End Sub
'***** CODE END *****
Thanks for you time.
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