<div>
tusharashah is right, if you try to close a recordset which has an update pending, you get that error.
</div>


tusharashah is right, if you try to close a recordset which has an update pending, you get that error.

<div>
<div class="content wysiwyg-content">
Sorry guys, these are my last remaining points. In my program I have the code:<br />
Private Sub Form_Load()<br />
rs.Close<br />
rs.Open &quot;select * from UserNames where UserName = '&quot; &amp;&nbsp;gstUserName &amp;&nbsp;&quot;'&quot;<br />
rs.Fields!Grade = TeacherGrade<br />
rs.Close &lt;&lt;&lt;&nbsp;operation not allowed in this context, runtime error 3219<br />
rs.Open TeacherGrade<br />
rs.MoveFirst<br />
Do Until rs.EOF<br />
List1.AddItem rs.Fields!NameGrade<br />
rs.MoveNext<br />
Loop<br />
End Sub<br />
<br />
Any suggestions? and no this isn't a school project =P
</div>
</div>


Sorry guys, these are my last remaining points. In my program I have the code:
Private Sub Form_Load()
rs.Close
rs.Open "select * from UserNames where UserName = '" & gstUserName & "'"
rs.Fields!Grade = TeacherGrade
rs.Close <<< operation not allowed in this context, runtime error 3219
rs.Open TeacherGrade
rs.MoveFirst
Do Until rs.EOF
List1.AddItem rs.Fields!NameGrade
rs.MoveNext
Loop
End Sub

Any suggestions? and no this isn't a school project =P

rs.Close, Runtime Error 3219 (VB6)

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.