Report ..

How can I make a Report like in acces? Is it easy to make a Report and take print as easy in Access. Please help.

Seema_s

Make your report in Access and just call it from VB.

Other than the printer object, VB has not built in reporting features.

Quote:

---

Originally Posted by Hack

Make your report in Access and just call it from VB.

Other than the printer object, VB has not built in reporting features.

---

What is the code to call a report from VB? I need help plz.

select data report in vb ide from project>add data report and then change the data source and record source properties .create text boxes and labels in that report and also link them.Then just call your report from vb code .

Quote:

---

Originally Posted by seema_s

What is the code to call a report from VB? I need help plz.

---

First, go into Access and create the report.

Then, from your VB program, set a reference to the MS Access Object Library, then run something like this

VB Code:

Private Sub cmdPrintReport_Click()
           Dim Axs As Access.Application
           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 your Access report and DBPath is the full path and db name of your database.

Quote:

---

Originally Posted by Hack

First, go into Access and create the report.

---

Hi, Friends. Thanks for the help. Let me know is it hard to create a report in VB?

Regards,

Seema_S

Moved

Quote:

---

Originally Posted by seema_s

Hi, Friends. Thanks for the help. Let me know is it hard to create a report in VB?

Regards,

Seema_S

---

I already explained that you don't create a report in VB. You create a report in Access, or Crystal Reports or some other type of report generator, and call the report from VB.