Peter Lars Jensen Posted July 11, 2001 Share Posted July 11, 2001 Hi there, I have been working on a database where I removed the Status Area and instead of the conventional "record-browser" implemented my own navigation - so far four buttons doing "First Record", "Previous Record", "Next Record" and "Last Record. Piece of cake. Now I would like to add the following text information: Record Number, Total (found) Records and Total Records. Example: a) Browsing my records. Looking at record number 22 out of all 398 records: 22 of 398 - 398 : Searching my records. Found 114 out of all 398 records. Looking at record number 22 of all found 114 records: 22 of 114 - 398 Can this be done? Any help would be appreciated Link to comment Share on other sites More sharing options...
Chuck Posted July 11, 2001 Share Posted July 11, 2001 You can do this with the status functions. Create a calculation field with the following calc: code: Status( CurrentRecordNumber ) & " of " & Status( CurrentFoundCount ) & " - " & Status( CurrentRecordCount ) Make sure that you make the calculation unstored. To do this, while in the calc dialog, click on Storage Options and click on "Do not store calculation results -- calculate only when needed". This will ensure that this field is updated correctly when it needs to be displayed. Chuck Link to comment Share on other sites More sharing options...
Peter Lars Jensen Posted July 11, 2001 Author Share Posted July 11, 2001 Thanks a lot! That did the trick :-) Link to comment Share on other sites More sharing options...
rhakka Posted July 13, 2001 Share Posted July 13, 2001 man... if you only knew how many hours i smacked my head against the desk trying to figure that one out : thank you! Link to comment Share on other sites More sharing options...
rhakka Posted July 14, 2001 Share Posted July 14, 2001 I tried that once and it failed to display the correct results.. perhaps because the calculation was stored? why would that screw it up though? shouldn't it still always accurately reflect the correct, current information? Link to comment Share on other sites More sharing options...
Kurt Knippel Posted July 14, 2001 Share Posted July 14, 2001 quote: Originally posted by rhakka: I tried that once and it failed to display the correct results.. perhaps because the calculation was stored? why would that screw it up though? shouldn't it still always accurately reflect the correct, current information? Stored calcs only refresh when the value in a FIELD changes. Since this particular calc does not reference any fields that can change it is effectively frozen as soon as it is displayed. Worse, it will be different for every record. Making it unstored is the only way to get it to work correctly. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8345 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 accountSign in
Already have an account? Sign in here.
Sign In Now