| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Correct VBA for DO WHILE i.e. X=X AND NOT RS.EOF
2003/2007
Attempting to: CASE #1 Do While TranNumMem = TransactionsRS!TranNum AND NOT RS.EOF ' xxxxxxx ' xxxxxxx rs.movenext Loop The clause TranNumMem = TransactionsRS!TranNum works but the AND NOT RS.EOF is not working I worked around with: CASE #2 Do While TranNumMem = TransactionsRS!TranNum ' xxxxxxx ' xxxxxxx rs.movenext If RS.EOF Then Exit Do Loop How could I make CASE #1 work?? TIA EagleOne |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Correct #N/A Value | Excel Worksheet Functions | |||
| If correct, add 1 | Excel Worksheet Functions | |||
| I will never, ever get this correct ... | Excel Programming | |||
| I will never, ever get this correct ... | Excel Programming | |||
| I will never, ever get this correct ... | Excel Programming | |||
Threaded Mode
