report generation

[sameen]

Hi
my database is in access..and front end is vb....i want to create reports in access....if i do this how can i link these reports to my vb form.....and is there any drawback of making reports in access and using thm through vb form......i need advice
thnx

[Hack]

Moved to reporting section.

Create your reports in Access.

To call them from VB, set a reference to the Microsoft Access X.X Object Library (where X.X is the version installed on your machine.)

Then, use code like this:

Private Sub cmdPrintReport_Click()
          Set Axs = CreateObject("Access.Application")
           Axs.OpenCurrentDatabase (DBPath)
           Axs.DoCmd.OpenReport "MyReport"
           Set Axs = Nothing
           Axs.Quit
End Sub

Where MyReport is the name of the report that you have previously created in Access.

I don't see drawbacks. I've used Access reports from VB before with great success.