why close the recordset?

FAQ

Profile

why close the recordset?

Database Help (Home) -> Visual Basic -> DAO

Next: sql query

Author

Message

evagelos

External

Since: Oct 05, 2003
Posts: 1

(Msg. 1) Posted: Fri Oct 10, 2003 3:22 am Post subject: why close the recordset? Archived from groups: microsoft>public>vb>database>dao (more info?)

i have this code: With Data1.Database.OpenRecordset("stock") ..MoveFirst Do Until .EOF List1.AddItem .Fields("DESCRIBE").Value List2.AddItem .Fields("CODE_STOCK").Value .MoveNext Loop ListRefresh1 End With should i put before end with .close or not? why? So far i have notnotice any problems >> Stay informed about: why close the recordset?

Display posts from previous:

Related Topics:

Test for empty field in a DAO Recordset - Can anyone help me to determine when an integer field contains nothing? It seems to be different than a null variable and I can't remember how to do this simple thing. I'm using a DAO 3.6 Recordset If the Integer field [IDNumber] is blank or empty I..

DAO 3.6 record locking - Hi, Is it possible to programmatically lock a single record in a VB application using DAO 3.6? I would like to lock users' records when they log on to the app. Later I can check if a user's record is locked to see if they are logged in or not. (I....

Fixes for VB4 or DAO 3.0 - I've got VB4 (32-bit) and it seems to use DAO 3.0. Is there a service pack for either of these that I can use? I'm having issues with DAO and > 2GB of RAM on the machine, and don't want to have to move to a newer version of VB if I can help it, just t...

Jet error - I've just started getting this error message on a seemingly random basis. 'The Microsoft Jet database engine does not recognize 'CID' as a valid field name or expression.' CID is a text field, and it is a valid column name. The line of code that..

DAO reference / Access 2007 - while using an Access 2007 .accdb file I can access the dao. object very easily. the following code in VBA works well : Function getrecordcount(strTableName As String) As Long Dim dbCurrent As DAO.Database Set db = CurrentDb Dim rstRecords A...

	Database Help (Home) -> Visual Basic -> DAO	All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum