getting number of records in the form

Hi all,

what function or code i should write in order to get the number of
records/rows in the form application?

thread [ Fr, 21 Dezember 2007 18:09 ] [ ID #1892053 ]

Re: getting number of records in the form

I think the answer you want is:
Me.RecordSetClone.MoveLast
{TheCount] = Me.RecordSetClone.RecordCount

thread wrote:
>Hi all,
>
>what function or code i should write in order to get the number of
>records/rows in the form application?

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-ac cess/200712/1

u12102 [ Fr, 21 Dezember 2007 20:32 ] [ ID #1892066 ]

Re: getting number of records in the form

thread wrote:
> Hi all,
>
> what function or code i should write in order to get the number of
> records/rows in the form application?

MsgBox Me.RecordsetClone.RecordCount

No, no, no
http://www.youtube.com/watch?v=Bc6iOt-LZic

Salad [ Fr, 21 Dezember 2007 20:35 ] [ ID #1892067 ]

Datenbanken » comp.databases.ms-access » getting number of records in the form

Vorheriges Thema: Getting a single column to only show one record.
Nächstes Thema: linking multiple mdb files