1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
| Private Sub Report_Load()
'
' Variables locales :
' ===================
'
Dim rsRequete As ADODB.Recordset
Dim strSQL As String
'
' Traitement :
' ============
'
If Me.id_adresse <> "" Then
strSQL2 = "SELECT adr_ville,adr_ville_cedex,adr_code_postal,adr_code_postal_cedex FROM adresses WHERE adr_identifiant = " & Me.id_adresse
Set rsRequete2 = New ADODB.Recordset
Call rsRequete2.Open(strSQL2, CurrentProject.Connection)
If Not rsRequete2.EOF Then
strCodePostal = IIf(Len(Nz(rsRequete2("adr_code_postal"), "")) = 0, IIf(Len(Nz(rsRequete2("adr_code_postal_cedex"), "")) = 0, "", rsRequete2("adr_code_postal_cedex")), rsRequete2("adr_code_postal"))
strVille = IIf(Len(Nz(rsRequete2("adr_ville"), "")) = 0, IIf(Len(Nz(rsRequete2("adr_ville_cedex"), "")) = 0, "", rsRequete2("adr_ville_cedex")), rsRequete2("adr_ville"))
End If
[code_postal].Value = strCodePostal
[ville].Value = strVille
Call rsRequete2.Close
Set rsRequete2 = Nothing
End If
End Sub |
Partager