arrays in Access

[ravikode]

Hi,
I have a table which has around 10000 rows. I want to access each row at a time and do some validations. Is there a concept of cursor(like in oracle and sybase) in Access2002. I need an example for that.

Thanks
Ravi

 

[Dugantrain]

ok, I've never really used arrays, so there' probably another way; what I do for record-by-record validation is to use VBA to grab a DAO or ADO recordset and then loop through this recordset, performing your validation procedures on every loop:

Public Function fValidate_Recordset()
Dim db as DAO.Database
Dim rs as DAO.Recordset
Set db=CurrentDB
Set rs=db.OpenRecordset("SELECT * FROM YOUR_TABLE")
'You now have a DAO Recordset that you can manipulate
'Loop through it and perform some actions
Do While Not RS.EOF
If RS!Validation_Field=Something Then
  'Perform An Action 
  RS.MoveNext
Else
  'Perform Another Action
  RS.MoveNext
End If
Loop
Set rs=Nothing
Set db=nothing
End Function

I don't know your VBA experience; if you want to try taking this route, describe what specifically you're trying to do and maybe we can help more.

 

[drjekyll325]

Don't forget to open the recordset as Forward Only if you intend to only loop through it once.

 

[ravikode]

thanks for your help