Opening report in another database

[Guest]

I have the following code which opens a connection to another access
database. How can I modify or add to this code to print a specific report
from this database?

Private Sub Command0_Click()
Dim conn As New ADODB.Connection
Dim prop As Property
Dim strg As String

strg = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\EUsers\reports\My
Documents\Access Reports\Balance Center.mdb;Persist Security Info=False"

conn.Open strg


I have several access databases which have linked data to another program
"Medisoft". My goal is to create a way to open each individual access
database and print a monthly report from a command button. Bottom line I do
not want to have to open each database and report manually.

 

[Guest]

Consider opening the other db using a command-line switch. You can call a
macro from the commandline. Create macros that open reports and then quit the
database. Open the db's by using the Shell command.

HTH,
Barry

 

[Douglas J. Steele]

You can't. ADO is strictly a method for getting at data, not Access objects
such as forms or reports.

Consider using Automation. See http://support.microsoft.com/?id=296586 for
sample code.