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 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70
|
Private Sub cmdRegion_Click()
Dim db As DAO.Database
Dim recEnreg As DAO.Recordset
Dim sSQL As String
Me.ProgressBar1.Value = 0
sSQL = "SELECT dbo_OSMOSE_SITE_THEORIQUE.REGION_EXPLOITATION as LaRegion"
sSQL = sSQL & " FROM dbo_OSMOSE_SITE_THEORIQUE"
sSQL = sSQL & " Union"
sSQL = sSQL & " Select " & """" & "NAT" & """" & " From dbo_OSMOSE_SITE_THEORIQUE AS LaRegion"
Set db = DBEngine.Workspaces(0).Databases(0)
Set recEnreg = db.OpenRecordset(sSQL, dbOpenSnapshot)
On Error Resume Next
If StrTable = "Regions" Then
sSQL = "insert into Region values ('IDF-RN')"
Call db.Execute(sSQL)
While Not recEnreg.EOF
If (recEnreg!LaRegion <> "IDF" And recEnreg!LaRegion <> "RN") Then
sSQL = "insert into Region values ('" & recEnreg!LaRegion & "')"
Call db.Execute(sSQL)
End If
Call recEnreg.MoveNext
Me.ProgressBar1.Value = recEnreg.PercentPosition
Me.LblPercent.Caption = Format(recEnreg.PercentPosition / 100, "0.00 %")
Wend
Me.Repaint
'=> La partie qui m'intéresse se situe ici :
ElseIf StrTable = "Villes" Then
Set recEnreg = db.OpenRecordset("reqAlimVille", dbOpenSnapshot)
While Not recEnreg.EOF
If (recEnreg!LaRegion <> "IDF" And recEnreg!LaRegion <> "RN") Then
sSQL = "insert into Ville values ('" & Replace(recEnreg!COMMUNE, "'", "''") & "','" & recEnreg!REGION_EXPLOITATION & "')"
Else
sSQL = "insert into Ville values ('" & Replace(recEnreg!COMMUNE, "'", "''") & "','IDF-RN')"
End If
Call db.Execute(sSQL)
Call recEnreg.MoveNext
Me.ProgressBar1.Value = recEnreg.PercentPosition
Me.LblPercent.Caption = Format(recEnreg.PercentPosition / 100, "0.00 %")
Me.Repaint
Wend
ElseIf StrTable = "Sites" Then
Set recEnreg = db.OpenRecordset("reqAlimSite", dbOpenSnapshot)
While Not recEnreg.EOF
sSQL = "insert into Site values ('" & recEnreg!NUM_SITE_THEORIQUE & "','" & Replace(recEnreg!COMMUNE, "'", "''") & "')"
Call db.Execute(sSQL)
Call recEnreg.MoveNext
Me.ProgressBar1.Value = recEnreg.PercentPosition
Me.LblPercent.Caption = Format(recEnreg.PercentPosition / 100, "0.00 %")
Me.Repaint
Wend
End If
ExitHandler:
Me.ProgressBar1.Value = 100
Me.LblPercent.Caption = 100 & " %"
Call recEnreg.Close
Call db.Close
End Sub |
Partager