ACCESS FEED: Re: [MS_AccessPros] Record count from a continous form

Selasa, 22 September 2015

Re: [MS_AccessPros] Record count from a continous form

Hi Art,

not much time now but I added a feature in one of my databases to display the count of the current record out of the total records

make a textbox control:
Name --> CountRecords

'~~~~~~~~~~~~~~~~~~~~~~~~~
Private Sub Form_Current()
'5-15-07
   If Not IsEmpty(Me.CurrentRecord) Then
      Me.CountRecords = [CurrentRecord] & " of " & Format(Recordset.RecordCount, "#,##0")
   Else
      Me.CountRecords = " "
   End If

End Sub

'~~~~~~~~~~~~~~~~~~~~~~~~~

looking at it now, it doesn't make a lot of sense as stuff is obviously missing! The trick is to use VBA to get it. I did this in an old version of my contact database -- not the current one though!

warm regards,
crystal

~ have an awesome day ~

On 9/22/2015 10:32 AM, dbalorenzini@yahoo.com [MS_Access_Professionals] wrote:

I am trying to fill a text field called txtCurrentRec and txtRecTotal. I am trying to display the following:

txtRecordCount:="Unit HotList: " & txtCurrentRec & " of " & txtRecTotal & " units"

Record 1 of 20 records based on the counts contain on frmHuDUnits which is a continuous form. I know its a little vague but any ideas?

Thank you,

Art Lorenzini

Sioux Falls, SD