BD ADO

ErmesindePorto

25-01-2013 19:49:07

Oi,

Necessitava da vossa grande ajuda. Seria possível, por favor, alguém conseguir adaptar o seguinte código para BD ADO:


Sub DemoProgress()
'
' Barra de progresso
'
Dim intIndex As Integer
Dim sngPercent As Single
Dim db As Database
Dim Rs As Recordset, Rs1 As Recordset, Rs2 As Recordset, Rs3 As Recordset, Rs4 As Recordset, Rs5 As Recordset


Set db = OpenDatabase(ThisWorkbook.Path & "\" & ThisWorkbook.Name, False, False, "Excel 8.0")
Set Rs = db.OpenRecordset("SELECT COUNT(») AS TotalJan FROM [Janeiro$]", dbOpenSnapshot)
Set Rs1 = db.OpenRecordset("SELECT COUNT(») AS TotalFev FROM [Fevereiro$]", dbOpenSnapshot)
Set Rs2 = db.OpenRecordset("SELECT COUNT(») AS TotalMar FROM [Março$]", dbOpenSnapshot)
Set Rs3 = db.OpenRecordset("SELECT COUNT(») AS TotalAbr FROM [Abril$]", dbOpenSnapshot)
Set Rs4 = db.OpenRecordset("SELECT COUNT(») AS TotalMai FROM [Maio$]", dbOpenSnapshot)
Set Rs5 = db.OpenRecordset("SELECT COUNT(») AS TotalJun FROM [Junho$]", dbOpenSnapshot)




intMax = 1 + Rs(0) + Rs1(0) + Rs2(0) + Rs3(0) + Rs4(0) + Rs5(0)
db.Close
Me.GravarHeader
Me.GravarJaneiro
Me.GravarFevereiro
Me.GravarMarco
Me.GravarAbril
Me.GravarMaio
Me.GravarJunho


End Sub



Obrigado

webmaster

27-01-2013 02:40:31

Colega,

Veja se isso ajuda:

http://p2p.wrox.com/access/4547-convert ... #post80899

Abraços