Japer Reports and iReports

#
1

Open Microsoft Visual Basic Express, click "New Project..." then select "Windows Forms Application." Click "OK."
#
2

Double-click "Button" on the "Toolbox" pane to add a new button control. Double-click "Button1" to open the "Form1.vb" module.
#
3

Type the following under "Button1_Click" to declare an object variable:

Dim oAccess As Microsoft.Office.Interop.Access.Application
#
4

Type the following to start a new instance of Access:

oAccess = New Microsoft.Office.Interop.Access.Application
#
5

Type the following to open the Access database in exclusive mode:

oAccess.OpenCurrentDatabase(filepath:="F:\DemandStudios\Archive\Northwind 2007.accdb", Exclusive:=True)

Edit the path and type the path and name to your Access database.
#
6

Type the following to preview a report named "Customer Address Book":

oAccess.DoCmd.OpenReport(ReportName:="Customer Address Book", _

View:=Microsoft.Office.Interop.Access.AcView.acViewPreview)

Edit the "ReportName" and type a report in your Access database.
#
7

Type the following to print the report named "Customer Address Book":

' Print a report named Sales:

oAccess.DoCmd.OpenReport(ReportName:="Customer Address Book", _

View:=Microsoft.Office.Interop.Access.AcView.acViewNormal)

Edit the "ReportName" and type a report in your Access database.

Press "F5" to run your program then click "Button1."

Read more:http://www.ehow.com/how_7654006_access-reports-vb.html#ixzz18WU7FWLM Answered Dec, 20 2010

Delete report/Delete all reports: to delete one/all report(s), do the following:

In the list of reports select the necessary report and right-click it.
In the shortcut menu select Delete report to delete the selected report or Delete all reports to delete all reports shown in this window.

Answered Jul, 06 2010

Here you are. Hope it helps.

http://www.eggheadcafe.com/aspnet_answers/securitybaseline_analyzer/Jul2006/post27533343.asp

Answered Jul, 07 2010