Hi,
I have a TableControl which is based on a query sourcing data from a number of tables and also contains some calculated fields rendering the control read only.
As such the Nav Bar refuses to work. Could I use a filter table as a workaround? Or would a View be an alternative ? Any other options?
Thank you, keep safe
[Solved] Filter/Navigation bar Question
[Solved] Filter/Navigation bar Question
Last edited by gkick on Sat May 23, 2020 8:10 am, edited 1 time in total.
Libre Office 6.4.6 on Windows 10 HSQL 2.51 backend
-
- Volunteer
- Posts: 1549
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: Filter/Navigationbar Question
The Nav Bar should work for Table Controls displaying data from a read only source. Of course, the options relating to data manipulation will be disabled.
Try adding another Navigation control to your existing form.
If that fails it could be an issue with that form so try creating a new one.
If the table control is on a SubForm be sure to select Parent Form for the Navigation bar option on the Data tab on the Form Properties dialog.
Try adding another Navigation control to your existing form.
If that fails it could be an issue with that form so try creating a new one.
If the table control is on a SubForm be sure to select Parent Form for the Navigation bar option on the Data tab on the Form Properties dialog.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Re: Filter/Navigationbar Question
@UnklDonald418
Thank you, checked out the forms hierarchy, no prob, added another bar, same prob
created a blank form, added the tablecontrol and navbar , all worked with the exception of a concatenated field aka "Terms" ||' days' which does not like the auto filter,
muchas gracias
Thank you, checked out the forms hierarchy, no prob, added another bar, same prob
created a blank form, added the tablecontrol and navbar , all worked with the exception of a concatenated field aka "Terms" ||' days' which does not like the auto filter,
muchas gracias
Libre Office 6.4.6 on Windows 10 HSQL 2.51 backend