Opening Access reports

[DocA]

How do I open a access report in vb, but only the report and not the the access window?

Thanx

[cusmar]

you can use crystal reports its on the VB6 CD and it has a component where you install your report easy

[Gaffer]

Well, seeing as DocA probably has his reports already set up in Access, I guess he wouldn't want to convert everything over to Crystal reports...

To answer your question:

Dim acc As New Access.Application

With acc
    .OpenCurrentDatabase "C:\NWIND.mdb"
    .DoCmd.OpenReport "Catalog", acViewPreview
    .DoCmd.Maximize
    .Visible = True
End With

[DocA]

No, I dont want the access window to open, only the report window. The user shouldnt be allowed to see the database.

[Gaffer]

Access reports are an inherent part of Access aplication, therefore I am almost 100% sure you have to endure opening Access. There are ways in which you can hid the data from the user, (such as shutting the application once the report is closed) but the old F11 - Show Database Window trick will always allow them to see the underlying data.

[DocA]

Thanx, any other sugestions?

[Hack]

If you are going to stay with Access reports, you have no other options if you wish to preview your report rather than sending it to print.

What Gaffer told you IS 100% correct.

[SeanK]

The other option would be to convert to Crystal reports, as has been suggested.

[DocA]

How do i convert it? Is it just on the vb cd, is there a plug in to convert? On the professional or enterprice cd, i couldn't find it on the prof CD, maybe just didin;t look right?