RAYOL
17-06-2012 20:46:29
Pessoal algum pode me ajudar? O codigo abaixo retorna o erro acima na linha
Set rst = db.OpenRecordset(sSql)
Grato,
Marcelo
**********************************************************************************************
Private Sub LerBancoDados(ByVal sFile As String, ByVal sPass As String, _
ByVal sTab As String, ByVal sFld As String)
Dim db As Database
Dim rst As Recordset
Dim sSql As String
Set db = OpenDatabase(sFile, False, False, ";PWD=" & sPass)
sSql = "SELECT * FROM tabLojas WHERE UF = 'PA'"
' E para DELETE, UPDATE e INSERT INTO, ao invés de:
Set rst = db.OpenRecordset(sSql)
' Use:
' db.Execute (sSql)
While Not rst.EOF
MsgBox rst(0).Value & vbNewLine & rst(sFld)
rst.MoveNext
Wend
Set rst = Nothing
db.Close
End Sub
Public Sub teste()
Dim sFullFileName, sPassword, sTable, sField As String
Dim vContent As Variant
sFullFileName = SPATH & "bdSetups.accdb"
sPassword = ""
sTable = "tabLojas"
sField = "UF"
vContent = "PA"
LerBancoDados sFullFileName, sPassword, sTable, sField
End Sub
..
Set rst = db.OpenRecordset(sSql)
Grato,
Marcelo
**********************************************************************************************
Private Sub LerBancoDados(ByVal sFile As String, ByVal sPass As String, _
ByVal sTab As String, ByVal sFld As String)
Dim db As Database
Dim rst As Recordset
Dim sSql As String
Set db = OpenDatabase(sFile, False, False, ";PWD=" & sPass)
sSql = "SELECT * FROM tabLojas WHERE UF = 'PA'"
' E para DELETE, UPDATE e INSERT INTO, ao invés de:
Set rst = db.OpenRecordset(sSql)
' Use:
' db.Execute (sSql)
While Not rst.EOF
MsgBox rst(0).Value & vbNewLine & rst(sFld)
rst.MoveNext
Wend
Set rst = Nothing
db.Close
End Sub
Public Sub teste()
Dim sFullFileName, sPassword, sTable, sField As String
Dim vContent As Variant
sFullFileName = SPATH & "bdSetups.accdb"
sPassword = ""
sTable = "tabLojas"
sField = "UF"
vContent = "PA"
LerBancoDados sFullFileName, sPassword, sTable, sField
End Sub
..