Counter

Topic

New Reply

I want to update my counter (using the caption of a label) on a form when I get to an evan hundred records. I am incrementing a counter for each record processed.

I’ve done this before but can’t remember the function or where I used it.

Can someone prod my memory please. ..

Reply | Quote

Replies

I want to update my counter (using the caption of a label) on a form when I get to an evan hundred records. I am incrementing a counter for each record processed.

I’ve done this before but can’t remember the function or where I used it.

Can someone prod my memory please. ..

I’ve tried –
If mod intCounter 100 then
me.lblCounter.caption = “Record ” & intcount
end if

But it still updates for each loop, not once for every hundred.

Can anyone see the problem with this line?

Reply | Quote

Change the line

If mod intCounter 100 then

to

If intCounter Mod 100 = 0 Then

Reply | Quote

Change the line

If mod intCounter 100 then

to

If intCounter Mod 100 = 0 Then

That’s better, Thanks Hans

Reply | Quote