Absolute Position

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top