ModuleTest.bas 397 B

12345678910111213141516171819202122
  1. Option Compare Database
  2. ' with references:
  3. ' Microsoft ADO Ext 6.0
  4. ' Microsoft Office Object Library 14.0
  5. ' Microsoft Office Runtime 1.0
  6. Public Sub TestModule()
  7. Dim rs As DAO.Recordset
  8. Set rs = CurrentDb.OpenRecordset("TableWithData", dbOpenSnapshot)
  9. rs.MoveFirst
  10. Do Until rs.EOF
  11. Debug.Print rs![param], rs![key]
  12. rs.MoveNext
  13. Loop
  14. End Sub