Page 1 of 1

Set the number of rows per view in data sheet form

Posted: Sat Aug 15, 2020 3:22 pm
by sergio trajano
Hello!

I want that my form in data sheet mode shows me exactly 12 registers (rows) each time, so I can see a unique full year each time (from register january to register december).

Is it possible? How do I set my form in data sheet mode so it shows me only 12 records at once?

Thanks for any help.

Re: Set the number of rows per view in data sheet form

Posted: Sat Aug 15, 2020 7:53 pm
by Villeroy
I think I know what you want from MS Access forms.

Code: Select all

-----------------------------
[Date]  [Time]  [Item v]
[Name]  [Amount]
----------------------------
[Date]  [Time]  [Item v]
[Name]  [Amount]
----------------------------
[Date]  [Time]  [Item v]
[Name]  [Amount]
----------------------------
[Date]  [Time]  [Item v]
[Name]  [Amount]
-----------------------------
[Date]  [Time]  [Item v]
[Name]  [Amount]
----------------------------
[Date]  [Time]  [Item v]
[Name]  [Amount]
========================================
[<< First] [< Previous Block] [Next Block >] [Last >>]
May be possible with a lot of coding. Never tried. Too much trouble.
What you can have is a table control to navigate and select records, together with one block of detailed form controls for the currently selected record.

AND if you install the report builder extension (or LibreOffice) then you get this layout with reports but not with input forms