|
-
Sep 29th, 2015, 08:18 PM
#1
Thread Starter
Fanatic Member
BOF/EOF Error using GetRows() with 1 record
Using ADO within Excel (2013) VBA to extract records from an Access file. For some reason I get a BOF/EOF error when using GetRows() if only one record (i.e. RecordCount = 1) is in the recordset. I've dug around and found nothing about a limitation of GetRows() in case of 1 record only. I can certainly test for Recordcount=1 and copy the field values in a loop into the array rather than use GetRows() but that seems like a goofy workaround. Am I doing someone wrong?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|