1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
|
Dim r As ADODB.Recordset 'r sera un objet de la classe des record set
Set r = New ADODB.Recordset 'creation d'un record set nouveau qui se nome r
Set r.ActiveConnection = CurrentProject.Connection 'connection courante
r.CursorType = adOpenDynamic 'type curseur
r.LockType = adLockOptimistic
Dim sql1 As String
sql1 = "SELECT t_proj_unit.id_proj, t_proj_unit.axe, t_proj_unit.position, t_proj_unit.pt_forts, t_proj_unit.pt_faibles " _
& " FROM t_proj_unit " _
& " where id_proj = " & Me!id_proj
r.Source = sql1
r.Open
r.Close
End Sub |
Partager