Sub ApercuAvancements(NumDos) req = "SELECT <champsl> from <table> WHERE ID_DOSSIERS = NumDos;" Set rq = CurrentDb.QueryDefs("requête Access") rq.SQL = Replace(req, "NumDos", NumDos) rq.Close CurrentDb.QueryDefs.Refresh End Sub
Dim appAccess As Object = CreateObject("Access.Application") Try appAccess.OpenCurrentDatabase(PathDBB) appAccess.Run("ApercuAvancements", CInt(_IdDossier)) appAccess.DoCmd.OpenReport("Nom de l'état à imprimer") appAccess.visible = True Catch ex As Exception MsgBox(ex.Message, MsgBoxStyle.Exclamation) Finally appAccess.Quit() appAccess = Nothing End Try