use Loop in swap data from one table to another.

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