MS Access and VBA question [ADO]

[blackknight]

---

mga master, ask lang unta ko kung unsaon nako pag compare ang first and second record in MS Access using excel VBA (ADO).

example:

First Record: 200
Second Record: 230

ako nahan mahitabo ky

If First Record = Second Record then
.....Code
End if

ako blema lang siguro ky wala ko kahibaw unsaon pag increment sa record number using VBA.

dli man mo work kung First Record = First Record + 1 ky ang value man sa first record iya e-increment and not the record number.

tabang mga master....

[papasilo]

VBA here,

Dli kayu ko ka kuha sa imong problem, bali variable imo pasabot? Diba naa namn auto-increment na variable
kana diay imong gamiton?

Or kani

Add a field isSave = [Yes/No]

btn_save:
Me.Refresh

Me.isSave = True
Me.RecordNumber = dmax("RecordNumber","yourTable","isSave=True") + 1

[rbrallos]

murag maayo ni i store nimo ug array ang records