Hi
While I have dabbled with OpenOffice a little from time to time, I have generally not used it to create anything until now.
I am trying to move some personal accounts data into OpenOffice. I tried MS Access 2003/2007 as well as most of my data is in Excel at present.
In MS Access I can create tabbed pages but in OpenOffice 2.4 I can find no way to get tabbed pages. So essntially I want a master detail relationship - multiple subforms displayed one one page.
Does OpenOffice have that capability? I am trying to recall if versions before 2.4 did or not?
Also 2.4 seems very awkward to work with - Once I create one form, save and then edit and try to add a Subform its not as easy as MS Access is.
My real question is however about tabbed pages - can you do them in Openoffice?
Tabbed Pages
- DrewJensen
- Volunteer
- Posts: 1734
- Joined: Sat Oct 06, 2007 9:01 pm
- Location: Cumberland, MD - USA
Re: Tabbed Pages
Easy question first...then we will make it convoluted...not really.
No tabbed page form controls - there are tabbed page dialogs, but not forms.
(Might as well tell you now too. There is another glaring difference (omission?) - you can not use the value of a control as the input to another control or as the parameter to a query without a script...arrgh...curse cuse...so nothing like SELECT * FROM TABLE WHERE COLUMN = [CONTROL_NAME] )
As for adding sub-forms to an existing form - I disagree that it is more difficult, it's different for sure..but once you do it, once, you see it is pretty simple. Also there is a fundamental difference from what a form is under MS Access and what a form is under OO.o Base. That last statement probably merits a separate post somewhere, here or the wiki.
OK - so how to add sub form - ah, had a nice little post to show that, with step by step screenshots...can I find it right now..no...
BRB
No tabbed page form controls - there are tabbed page dialogs, but not forms.
(Might as well tell you now too. There is another glaring difference (omission?) - you can not use the value of a control as the input to another control or as the parameter to a query without a script...arrgh...curse cuse...so nothing like SELECT * FROM TABLE WHERE COLUMN = [CONTROL_NAME] )
As for adding sub-forms to an existing form - I disagree that it is more difficult, it's different for sure..but once you do it, once, you see it is pretty simple. Also there is a fundamental difference from what a form is under MS Access and what a form is under OO.o Base. That last statement probably merits a separate post somewhere, here or the wiki.
OK - so how to add sub form - ah, had a nice little post to show that, with step by step screenshots...can I find it right now..no...
BRB
Former member of The Document Foundation
Former member of Apache OpenOffice PMC
LibreOffice on Ubuntu 18.04
Former member of Apache OpenOffice PMC
LibreOffice on Ubuntu 18.04