Open a report in a different mdb

[JimP]

If this is possible, how would I do it using "DoCmd.OpenReport"?

 

[Douglas J. Steele]

Dim appAccess As Access.Application

Set appAccess = New Access.Application
appAccess.OpenCurrentDatabase "C:\Folder\File.mdb"
appAccess.DoCmd.OpenReport "NameOfReport"

Once you're done with the report, you need

appAccess.CloseCurrentDatabase
appAccess.Quit
Set appAccess = Nothing

 

[Marco]

Friends and friends around the world.
We are presenting the new messenger.
He will be in the commissioning by the friends that we indicate to use the
system.
Access the system by clicking the link below and register free.

You get something for using orkut?
You get something for using skype?
You gain something by using twiter?
You get algumaocisa for using facebook?

Enjoy this is your time!!

Sign up and join for free.


http://www.sqipcom.com/?ref=webempreendedor

http://stakeholder.sqipcom.com/user/webempreendedor

 

[JimP]

Thank you, seems easy enough and will give it a try.

What if some of the report objects are in the "calling" mdb. Will the report
be able to find objects in both mdb's, or will all objects need to be in the
mdb with the report?

 

[Douglas J. Steele]

No, objects in one mdb aren't usually available to other mdbs.