Jump to content

Show record number


Wayne0412
 Share

This topic is 4358 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Howdy,

Can any one tell me how to get the total number of records on a form?

I want the main page to have a text line that shows the Total Records in the database.

I have found the Insert "Record Number Symbol", but, correct me if I'm wrong, that represents the current number being browsed, not the total number of records?

Cheers

Link to comment
Share on other sites

Howdy,

Can any one tell me how to get the total number of records on a form?

I want the main page to have a text line that shows the Total Records in the database.

I have found the Insert "Record Number Symbol", but, correct me if I'm wrong, that represents the current number being browsed, not the total number of records?

Cheers

On my layouts I use the result of a Custom Function I call "Record Number": "#" & " " & Get ( RecordNumber ) & " " & "of" & " " & Get ( FoundCount ) . No Parameters.Also Do Not Store. I place this field under a set of symbols, one each for First Record, Previous Record, Next Record and Last Record. I make these arrow symbols buttons and attach the appropriate navigation step to them. It works well.

RW

Link to comment
Share on other sites

On my layouts I use the result of a Custom Function I call "Record Number": "#" & " " & Get ( RecordNumber ) & " " & "of" & " " & Get ( FoundCount ) . No Parameters.Also Do Not Store. I place this field under a set of symbols, one each for First Record, Previous Record, Next Record and Last Record. I make these arrow symbols buttons and attach the appropriate navigation step to them. It works well.

RW

There is no option in custom functions for Do Not Store.

So this is confusing. You refer to a custom function; but it sounds like simply a standard calc field.

Link to comment
Share on other sites

There is no option in custom functions for Do Not Store.

So this is confusing. You refer to a custom function; but it sounds like simply a standard calc field.

Yes, I should have been more clear. It is a calc field that calls a custom function. I use the CF because this element is used on dozens of layouts and it's simply quicker than typing out the calc dozens of times. "Do not store" refers to the calc field and not the CF. "No parameters" refers to the CF definition.

RW

Link to comment
Share on other sites

This topic is 4358 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.