Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to test if recordset is open???

Status
Not open for further replies.
JoshT

JoshT

IS-IT--Management
Apr 9, 2002
1
US
I'm opening recordsets only under certain conditions. Of course when I try to close them, I get an error if they were never open. How can I test if a recordset is open? (or closing a recordset that was never open would work)
 
Status
Not open for further replies.

Similar threads

btamsgn
  • Locked
  • Question
how to create a crosstab query 1
Replies
1
Views
2K
dhookom
dhookom
btamsgn
  • Locked
  • Question
How to arrange the values in column heading based on column STT
Replies
10
Views
2K
combo
combo
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
337
mikrom
mikrom
breezett93
  • Locked
  • Question
Field is being rounded in the export process
Replies
17
Views
829
strongm
strongm
accesshelp1
  • Locked
  • Question
How can I remove parenthesis and everything that comes after it? 1
Replies
3
Views
610
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top