Code:
Private Sub cmdGenerateReport_Click()
Dim conString As String
conString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\" & "Database.mdb;"
Set con = New ADODB.Connection
con.Open conString
Set rec