"You are on Record 3 of 17"

[magmike]

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

 

[geppo]

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"

 

[magmike]

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

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.

 

[Klatuu]

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.
--
Dave Hargis, Microsoft Access MVP

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

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.

 

[magmike]

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.
--
Dave Hargis, Microsoft Access MVP

Ciao magmike wrote:
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

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.- Hide quoted text -

- Show quoted text -

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

 

[Klatuu]

Use the AbsolutePosition property of the recorset.

"You are On Record " & Me.Recordset.AbsolutePosition & " Of " &
Me.Recordset.RecordCount
--
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
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.
--
Dave Hargis, Microsoft Access MVP

Ciao magmike wrote:
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
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.- Hide quoted text -

- Show quoted text -

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

 

[fredg]

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

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

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

 

[magmike]

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

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

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

Thanks!