number of "top" records in a continuous form (1 Viewer)

smig

Registered User.
Local time
Today, 14:46
Joined
Nov 25, 2009
Messages
2,209
how can I know the number of "top" (hidden) records in a continuous form, when I scroll the records ?
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 20:46
Joined
May 7, 2009
Messages
19,175
you need to determine Manually the "positions" of each "row" of
your continuous form.
the sample uses subform, the concept is the same with
single continuous form.
 

Attachments

  • determine_records.accdb
    512 KB · Views: 202

smig

Registered User.
Local time
Today, 14:46
Joined
Nov 25, 2009
Messages
2,209
you need to determine Manually the "positions" of each "row" of
your continuous form.
the sample uses subform, the concept is the same with
single continuous form.
Thank you

actually for now I realy needed the Me.CurrentSectionTop :)

but your answer pointed me also to what I asked for.
As I know the Detail.Height the Me.CurrentSectionTop and the current record number it's easy to calculate how many records are to the top of the form and how many are hidden over it.

What is the difference between
Me.CurrentRecord and Me.SelTop ?
Both show the current record number
 

June7

AWF VIP
Local time
Today, 04:46
Joined
Mar 9, 2014
Messages
5,425
SelTop along with SelLeft, SelWidth, SelHeight can be used to specify a rectangle of selected data - these properties can be set with code. CurrentRecord is read only.
 

Users who are viewing this thread

Top Bottom