View Single Post
  #2 (permalink)  
Old February 21st, 2004, 08:27 AM
joefawcett's Avatar
joefawcett joefawcett is offline
Wrox Author
Points: 9,763, Level: 42
Points: 9,763, Level: 42 Points: 9,763, Level: 42 Points: 9,763, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Exeter, , United Kingdom.
Posts: 3,074
Thanks: 1
Thanked 38 Times in 37 Posts
Default

That's fine although I think you need to close it in between:
Code:
objRecordset.Open "SELECT * FROM tbl_student", objConn
'list of students
'process data
objRecordset.close()
objRecordset.Open "SELECT * FROM tbl_teacher", objConn
'list of teachers
'process data
objRecordset.close()
objRecordset.Open "SELECT * FROM tbl_subject", objConn
'list of subjects
'process data
objRecordset.close()
--

Joe