"You are on Record 3 of 17"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

magmike - 07 Dec 2007 17:32 GMT

I have this code on a form to tell me how many records are in the form
="Looking at " & Count([CallID]) & " Calls Scheduled in this Query"
(displayed above my navigational buttons)

And I have this code, to tell me how many records (or calls) are in
this form for this contact:
=DCount("[CallID]","CallTableQ","[Company] = [Combo26]") & " calls
scheduled for this prospect"

but how can show which record in the set it is (i.e. On Record # of
#)?

Thanks in advance!
magmike

Reply to this Message

geppo - 07 Dec 2007 17:40 GMT

> I have this code on a form to tell me how many records are in the form

="Looking at " & Count([CallID]) & " Calls Scheduled in this Query of" &
RecordsetClone.RecordCount & "
Records"

> (displayed above my navigational buttons)
>
> And I have this code, to tell me how many records (or calls) are in
> this form for this contact:

=DCount("[CallID]","CallTableQ","[Company] = [Combo26]") & " calls
scheduled for this prospect Of " & RecordsetClone.RecordCount & "
Records"

> but how can show which record in the set it is (i.e. On Record # of
> #)?
>
> Thanks in advance!
> magmike

Signature

Ciao
Geppo

Reply to this Message

magmike - 07 Dec 2007 17:46 GMT

> > I have this code on a form to tell me how many records are in the form
>
[quoted text clipped - 20 lines]
> Ciao
> Geppo

This just shows me On Record 86 of 86. regardless of which record i am
on. I trying to figure out how to the the sequence number this record
is of 86.

Reply to this Message

Klatuu - 07 Dec 2007 18:10 GMT

Record numbers have no real meaning in Access. The record number you see in
the record navigtor in Access is a "relative number", that is, it shows the
position in the current recordset. If you add records or delete records, or
reorder the records, the previous record number will probably not be
associated with the same record.

Signature

Dave Hargis, Microsoft Access MVP

> > > I have this code on a form to tell me how many records are in the form
> >
[quoted text clipped - 24 lines]
> on. I trying to figure out how to the the sequence number this record
> is of 86.

Reply to this Message

magmike - 07 Dec 2007 19:38 GMT

> Record numbers have no real meaning in Access. The record number you see in
> the record navigtor in Access is a "relative number", that is, it shows the
[quoted text clipped - 34 lines]
>
> - Show quoted text -

That is fine with me, since I am just trying to replicate that
navigator bar. How would I do that?

Reply to this Message

Klatuu - 07 Dec 2007 19:46 GMT

Use the AbsolutePosition property of the recorset.

"You are On Record " & Me.Recordset.AbsolutePosition & " Of " &
Me.Recordset.RecordCount

Signature

Dave Hargis, Microsoft Access MVP

> > Record numbers have no real meaning in Access. The record number you see in
> > the record navigtor in Access is a "relative number", that is, it shows the
[quoted text clipped - 37 lines]
> That is fine with me, since I am just trying to replicate that
> navigator bar. How would I do that?

Reply to this Message

fredg - 07 Dec 2007 19:51 GMT

> I have this code on a form to tell me how many records are in the form
> ="Looking at " & Count([CallID]) & " Calls Scheduled in this Query"
[quoted text clipped - 10 lines]
> Thanks in advance!
> magmike

Use an unbound text control.
Code the Form's Current event:

Me.[ControlName] = "Record " & Me.CurrentRecord & " of " &
Me.RecordsetClone.RecordCount

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

magmike - 07 Dec 2007 21:35 GMT

> > I have this code on a form to tell me how many records are in the form
> > ="Looking at " & Count([CallID]) & " Calls Scheduled in this Query"
[quoted text clipped - 21 lines]
> Please respond only to this newsgroup.
> I do not reply to personal e-mail

Thanks!

Reply to this Message