Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sub plausibilitaet_check()
- Dim rs As DAO.Recordset
- Dim rs2 As ADODB.Recordset
- Dim db As database
- Dim strsql As String
- Dim strsql2 As String
- Dim tdf As TableDef
- Set db = opendatabase("C:Codebook.mdb")
- Set rs = db.OpenRecordset("plausen1")
- Set rs2 = CreateObject("ADODB.Recordset")
- rs2.ActiveConnection = CurrentProject.Connection
- For Each tdf In CurrentDb.TableDefs
- If Left(tdf.Name, 4) <> "MSys" Then
- rs.MoveFirst
- strsql = "SELECT * From [" & tdf.Name & "] WHERE "
- Do While Not rs.EOF
- On Error Resume Next
- strsql2 = "select * from table where GHds <> 0"
- Set rs2 = CurrentDb.OpenRecordset(strsql2)
- Sub plausibilitaet_check()
- Dim rs As DAO.Recordset
- Dim rs2 As DAO.Recordset
- Dim db As database
- Dim strsql As String
- Dim strsql2 As String
- Dim tdf As TableDef
- Set db = opendatabase("C:Codebook.mdb")
- Set rs = db.OpenRecordset("plausen1")
- For Each tdf In CurrentDb.TableDefs
- If Left(tdf.Name, 4) <> "MSys" Then
- rs.MoveFirst
- strsql = "SELECT * From [" & tdf.Name & "] WHERE "
- Do While Not rs.EOF
- On Error Resume Next
- strsql2 = "select * from table where GHds <> 0"
- Set rs2 = CurrentDb.OpenRecordset(strsql2)
Add Comment
Please, Sign In to add comment