Search results

Hooray! I found the problem by commenting out all of the code in between and adding it back in line by line. Thanks for your help and sorry for the bother.

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'm not sure what I meant by "cleaner." It just seems inefficient to search in a form with the exact same data as a table instead of just searching directly in the table. I see the point about messing up data, though. I am trying to search in an address table which contains separate fields...

Oh no! That's so stupid! It's so much cleaner just to work directly with the table - why add an additional layer in between? Aargh. Thanks for the tip.

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...