Search results

I'm having trouble compiling a "Do While..." loop. I've tried to simplify the code as much as possible. Do While (True) 'do a lot of stuff If (strCurrentRecord = strLastRecord) Then Exit Do Loop When I compile the code, I get a "Loop without Do" error at the Loop. At first, I...

I have a table with an autonumber field as a unique identifier. I recently ran Compact & Repair, which, as I understand it, resets the autonumber to one greater than the highest autonumber already in the table. I have run Compact & Repair often in the past without difficulty, but this time, it...

I can't figure out how to access data in a field in a table. To access data in a control on a form I would just use: variable = Forms![formName]![controlName].Text But when I try to use that syntax on data in a table, I get an "Object required" error. Any suggestions would be greatly...