Top "Recordset" questions

how to read one field from one record

I know I'm over thinking this, but I want to check a single value/field within a single record. For …

ms-access vba ms-access-2010 recordset

Rowset does not support scrolling backward

I am trying to query a MySQL database with the below code: 'declare the variables Dim Connection Dim Recordset Dim …

sql vbscript recordset rowset

Deep Copy or Clone an ADODB recordset in VBA

I have been searching for a way of duplicating or copying a recordset in VBA. And by that I mean, …

vba excel adodb recordset

Returning more than 1000 rows in classic asp adodb.recordset

My code in asp classic, doing a mssql database query: rs.pagesize = 1000 ' this should enable paging rs.maxrecords = 0 ' 0 = …

asp-classic ado recordset

recordset.find using variable VBA ADODB

I am getting pretty desperate trying to get this trivial search to work: rst2.Find "ID = '" & messID & "…

ms-access vba find recordset

Using "SELECT SCOPE_IDENTITY()" in ADODB Recordset

Using a VBA script in Excel, I'm trying to insert a new row into a table and then get back …

excel sql-server-2008 adodb recordset vba

Classic ASP: RecordSet Field giving no value

I'm not really an ASP developer, so a little bit lost. I have the following data access code: sSQL = "SELECT …

asp-classic vbscript field ado recordset

Creating Route53 Record Sets via Shell Script

As a part of my shell script, I am trying to create record sets in AWS Route53. However, using variables …

shell amazon-web-services aws-cli amazon-route53 recordset

ADO Recordset Not Staying Open in VBA - "Operation is not allowed when the object is closed"

I don't really understand what has happened here. I'm using Excel VBA to connect to a SQL Server Express database …

vba excel ado recordset

ListView Control loads very slowly

What is the fastest way to fill ListView from query when it has over 15000 lists with 9 subitems. it is taking …

listview ms-access vba recordset