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,

CurrentRecord is a form property to tell you which record number is active

warm regards,
crystal

Dates, Holidays, Weekends, Calendar Row & Column, occurrence of DOW in month, Workday Hours, Fiscal Year
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=590&title=dates-holidays-wkendsworkday-hrs-fiscal-yr

~ have an awesome day ~

On 9/22/2015 4:07 PM, Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals] wrote:

What is me.CurrentRecord? How is that specified?

With Warm Regards,

Arthur D. Lorenzini

IT System Manager

Cheyenne River Housing Authority

Wk.(605)964-4265 Ext. 130

Fax (605)964-1070

"Anyone who claimed that old age had brought them patience was either lying or senile."

From: "crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, September 22, 2015 3:16 PM
Subject: 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