General discussion

Locked

Walk through table in MS Access VBA

By hlc ·
I need to walk through the rows of a table and test each in a Select Case. I have looked at For Each but can't determine what the syntax would be.

I don't really write in VBA anymore and I'm stumped.

Thanks.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Walk through table in MS Access VBA

by Glen_McLeod In reply to Walk through table in MS ...

Don't use a For Each, open a recordset on your table and loop through it:

Do Until myRecordset.EOF
(your Select Case here)
Loop

Glen

Collapse -

Walk through table in MS Access VBA

by hlc In reply to Walk through table in MS ...

Thank you.

Collapse -

Walk through table in MS Access VBA

by hlc In reply to Walk through table in MS ...

This question was closed by the author

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums