Repost:Opening Rpt in Another DB

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

I posted a question on how to open a report from another
db. JohnFol replied with

"This is a starter for you

Public Sub OpenAnotherReport()

Dim MyAccess As Access.Application
Set MyAccess = New Access.Application
MyAccess.OpenCurrentDatabase ("C:\Program
Files\Microsoft
Office\Office10\Samples\Northwind.mdb")
MyAccess.Application.DoCmd.OpenReport "Catalog",
acViewPreview

End Sub"

and this gets me part way there.

I used what John sent and the machine seems to go through
the motions, a quick hour glass, but the screen does not
change and I get no errors. The form I started on is
still showing. I know it is opening another active Access
because if I go to the Task Manager it shows two instances
running. If I click on the command button again, there
are three instances running. One last thing, after I
click the command button and then try to modify the form I
get a message that the db is open for exclusive use by the
administrator and have to shut down to get this to release.

Any suggetions? I would appreciate any help.

Thanks

Ken
 
But of course: You need to add the line:
MyAccess.Visible = True
Otherwise, it's there, but unseen.
 
Back
Top