HOW CAN I RETURN IN A DATA BASE???

[vivis]

HI! I DID A SCRIPT THAT OPEN AN ACCES DATABASE AND I CAN READ THE INFORMATION IN THE DATABASE, WITH " .MOVENEXT" BUT I WANT TO KNOW HOW CAN I RETURN TO THE BEGINNING OF THE DATA ONCE I READ THE LAST FIELD. I TRIED TO USE THE ".CURSORLOCATION" BUT IT FAILED. SO I REALLY APRECIATE IF SOMEONE COULD HELP ME. THANX A LOT!!!

 

[bstocker]

I'm not sure if this is what you need..

You can be sure to include an ORDER BY statement in your Sql sting:

theSql = "Select * FROM TABLE ORDER BY ID"

by default Access creates a primary key that is an auto number so the oldest record would appear. You can sort your records ascending or descending by adding ASC (ascending) or DESC (descending):

theSql = "Select * FROM TABLE ORDER BY ID ASC"
theSql = "Select * FROM TABLE ORDER BY ID DESC"

Hope this helped.. I'm not sure I unstood your question.

 

[MrGreed]

You want to use:

ObjRec.moveFirst <-- begining of recordset
ObjRec.moveLast <-- end of recordset
ObjRec.movePrevious <-- move to previous record


Here is a link that will explain the above methods.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthmovefirst.asp

&quot;did you just say Minkey?, yes that's what I said.&quot;

MrGreed