April 2, 200817 yr Hello, I published my db to the web and I am having the following problem. When viewing a list of expenses (list view) and on the left-hand side you can click, "Next Range of Records" and it takes you to page 2 to view that listing. I'd like to create my own button for this feature, however, I am only able to pick next record. When I read up on next page, that is only for reports. And this layout of the db is not a report. I will be taking away the side status bar for the user b/c I don't want them to have that much access. Any other suggestions? Thank you in advance, Mary
April 16, 200817 yr Author SOLUTION... [color:blue]Increment next range of records Let (incrementby = If (Get(FoundCount) > 25 and Get (LayoutViewState) = 1 ; 25 ; 1) ; If ((Get(RecordNumber) + incrementby > Get (FoundCount) ; Get (FoundCount) - incrementby ; Get (RecordNumber) + incrementby)) [color:blue]Decrement previous range of records Let (decrementby = If (Get(FoundCount) > 25 and Get (LayoutViewState) = 1 ; 25; 1) ; If ((Get(RecordNumber) + decrementby) > 1 ; Get (RecordNumber) + decrementby ; 1))
Create an account or sign in to comment