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 42 43 44 45 46 47 48 49 50 51 52 53 54 55
| Public Function AccesADB(mycont As ContactItem)
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim sql As String
Dim strFullName As String, strCompanyName As String, strJobTitle As String
Dim strBusinessTelephoneNumber As String, strMobileTelephoneNumber As String
Dim strBusinessFaxNumber As String, strEmail1Adress As String
strFullName = Nz(CStr(mycont.FullName), "nc")
strCompanyName = Nz(CStr(mycont.CompanyName), "nc")
strJobTitle = Nz(CStr(mycont.JobTitle), "nc")
strBusinessTelephoneNumber = Nz(CStr(mycont.BusinessTelephoneNumber), " ")
strMobileTelephoneNumber = Nz(CStr(mycont.MobileTelephoneNumber), " ")
strBusinessFaxNumber = Nz(CStr(mycont.BusinessFaxNumber), " ")
strEmail1Adress = Nz(CStr(mycont.Email1Address), " ")
sql = "SELECT tblContact.*, tblContact.Nom, tblContact.EmailC "
sql = sql & " FROM tblContact "
sql = sql & " Where tblContact.Nom = """ & mycont.FullName
sql = sql & """ AND tblContact.[EmailC] = """ & mycont.Email1Address & """;"
Set db = CurrentDb
Set rs = db.OpenRecordset(sql)
If rs.RecordCount = 0 Then
'nb:La police de la msgbox n'est pas à "pas constant", utiliser plutôt un formulaire.
Select Case MsgBox("Importation de : " & mycont.FullName & vbCrLf & _
"Société : " & mycont.CompanyName & vbCrLf & _
"Fonction : " & mycont.strJobTitle & vbCrLf & _
"Tel profess. : " & strBusinessTelephoneNumber & vbCrLf & _
"Mobile : " & strMobileTelephoneNumber & vbCrLf & _
"Fax profess. : " & strBusinessFaxNumber & vbCrLf & _
"Adresses Email : " & strEmail1Adress & vbCrLf & vbCrLf & _
"Validez cette importation", vbYesNoCancel + vbQuestion, "xxx")
Case vbYes
If Len(strCompanyName) = 0 Then strCompanyName = InputBox("Renseignez la Société : ", "Importation de " & strFullName, "nc")
If Len(strJobTitle) = 0 Then strJobTitle= InputBox("Renseignez la Fonction : ", "Importation de " & strFullName, "nc")
rs.AddNew
rs.Fields(1) = strFullName
rs.Fields(2) = strCompanyName
rs.Fields(3) = strJobTitle
rs.Fields(4) = strBusinessTelephoneNumber
rs.Fields(5) = strMobileTelephoneNumber
rs.Fields(6) = strBusinessFaxNumber
rs.Fields(7) = strEmail1Adress
rs.Update
retourAccesADB = True
Case vbNo
retourAccesADB = True
Case vbCancel
retourAccesADB = False
End Select
Debug.Print "retourAccesADB2 " & retourAccesADB
End If
rs.Close
db.Close
Set rs = Nothing
Set db = Nothing |
Partager