use Loop in swap data from one table to another.

[azhar2006]

using Query is much faster than VBA.
but if you insist.

Good evening, my dear friend. The code worked great, but I have a problem with the message. Can I specify the message how many records have been updated?

MsgBox "You are about to update " & intCounter & " records."
'We need to loop through all of the records
'that our query object found
    While rs.EOF = False

 

[arnelgp]

see the message.

 

[Gasman]

PMFJI, but arnel has to sleep sometime

Use MoveLast and then check the RecordCount
Do not forget to MoveFirst before your loop.

Edit: Seems he does not?

 

[azhar2006]

PMFJI, but arnel has to sleep sometime

Use MoveLast and then check the RecordCount
Do not forget to MoveFirst before your loop.

Edit: Seems he does not?

Haha, sorry, I don't know the time with @arnelgp , but I know that he is a good-hearted person. thank you all

 

[azhar2006]

see the message.

The message keeps telling me that one record has been updated even if I update the records. Sorry to bother you my dear friend

 

[arnelgp]

you are using VBA, so everytime you press that button it will update the record (again)
even if you already updated it.

 

[azhar2006]

Hello my dear friend arnelgp I have encountered this error when I update the logs. I don't know what the problem is, I replaced the name field with a number field and also the same problem.

 

[arnelgp]

bring your table tblmastr in design view and add Index (index name: Fullname) to field Fullname.