M
misha
if you use DAO, the record set is only populate to show
the requested record. This means that if you request the
first record, the record set will only hold the first
record, if you request the second record, the record set
will be populated with the second record, etc. that's why
you get "1 / 1, 2 / 2, ... "
to populate the entire record set, move to the last and
then back to the first record:
if Not Formulaire.EOF then
Formulaire.MoveLast
Formulaire.MoveFirst
End if
this should populate the entire record.
also consider to use the AbsolutePosition instead of the
current record to show where you are:
Formulaire.AbsolutePosition & " / " &
Formulaire.RecordsetClone.RecordCount
hope this helps
the requested record. This means that if you request the
first record, the record set will only hold the first
record, if you request the second record, the record set
will be populated with the second record, etc. that's why
you get "1 / 1, 2 / 2, ... "
to populate the entire record set, move to the last and
then back to the first record:
if Not Formulaire.EOF then
Formulaire.MoveLast
Formulaire.MoveFirst
End if
this should populate the entire record.
also consider to use the AbsolutePosition instead of the
current record to show where you are:
Formulaire.AbsolutePosition & " / " &
Formulaire.RecordsetClone.RecordCount
hope this helps