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.
Set the number of rows per view in data sheet form
-
- Posts: 1
- Joined: Sat Aug 15, 2020 3:17 pm
Set the number of rows per view in data sheet form
openoffice 4.17 on windows
Re: Set the number of rows per view in data sheet form
I think I know what you want from MS Access forms.
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
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 >>]
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
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice