MovePrevious

pgriffin · Post by **pgriffin** » Wed Aug 23, 2006 7:00 pm

I've gone stupid (yet again)....

shouldn't MovePrevious be as simple as this?

Sub MovePrevRec
RecordSet.MovePrevious
End Sub

vbr>MovePrevRec

As long as I have created "RecordSet", which I am CERTAIN I have, why would MacroScheduler tell me this is "not allowed in this context" or various other errors.....

I am successfully using MoveFirst, MoveNext but can't seem to use MovePrevious....

I'm working on it, but will take any input....

Post by **Marcus Tettmar** » Wed Aug 23, 2006 8:02 pm

I believe the default cursor type in an ADO query is a forward only cursor. You may have to change the way you open the ADO connection.

Found this - it may help:
http://tutorials.aspfaq.com/8000xxxxx-e ... rrors.html

hvdberg · Post by **hvdberg** » Wed Aug 23, 2006 8:09 pm

Actually, it's not Macro Scheduler that is telling you this, it's ADO or DAO that is telling you this. Depending on the type of recordset that is created, MovePrevious may or may not be available.

There are 4 types of recordsets: Table, DynaSet, Snapshot, Forward-only

Check out http://msdn.microsoft.com/library/defau ... ma0501.asp for a more elaborate discussion on this. It (among other things) states that a forward only type recordset is

the default when you create a recordset in an ODBC workspace

HTH,
Henk

pgriffin · Post by **pgriffin** » Wed Aug 23, 2006 8:40 pm

Thanks for the input, guys. I finally went with a "conditional" MoveNext. I believe you are each correct that the cursor is ForwardOnly.

lesson learned, problem solved....

next problem, please...