Ok thanks. Heres my code for viewing a report:
How would i go about detecting when the report has closed in access so that i can call oAcces.Quit?Code:Try Dim oAccess As Access.Application oAccess = New Access.Application oAccess.Visible = True Call oAccess.OpenCurrentDatabase(filepath:=FilePath, Exclusive:=False, bstrPassword:="A5B7C5D8E4") With oAccess.DoCmd .OpenReport(ReportName:=ReportName, View:=Access.AcView.acViewPreview) .Maximize() End With oAccess = Nothing Catch ex As Exception MessageBox.Show("The following error occured: " & ex.Message) End Try




Reply With Quote