Table Format

users
#1

I once opened the table in one of my data bases and it popped up in a format I have not been able to duplicate. The upper half of the screen was the table in the form of a spread sheet but the lower half had the items of each row in a little table with the items under each other. I have been unable to duplicate this format, which I really liked. Any suggestions?

Sylvain

#2

I once opened the table in one of my data bases and it popped up in a format I have not been able to duplicate. The upper half of the screen was the table in the form of a spread sheet but the lower half had the items of each row in a little table with the items under each other. I have been unable to duplicate this format, which I really liked. Any suggestions?

With any form open hit the F4 key...that should do it

//drew

#3

Thank you, but I meant my computer screen, not a screen on which the table was projected.

Sylvain

#4

Thank you, but I meant my computer screen, not a screen on which the table
was projected.

Howdy Sylvain

Right and that is what I was speaking to - albeit, too briefly I
suppose.

By-default, with a writer document window the F4 key will open the data
source window, docked, in the top of the document window frame. This is
often referred to as the 'beamer'...a name for whatever reason I just
always liked..

OK - if you have a form definition within an ODB file, when that window
is open (this is just a special case of a writer document window) and
you hit F4 the beamer is displayed - however, as this is now attached to
a Base embedded form it behaves differently.

The record set linked to from the CURRENTLY FOCUSED DATA CONTROL on the
form is displayed in a grid view in the beamer. (important to remember
the bit about the focused control, the forum can have multiple record
sets open at a time)

This is just another live view to the record set, if you can update this
record set in the form you can do so in the beamer. If you use filters
to limit the result set in the beamer it also limits the records in the
form detail control.

I assumed that was what you where talking about.

Best wishes,

//drew

#5

Am 04.03.2012 19:12, drew jensen wrote:

I once opened the table in one of my data bases and it popped up in a format I have not been able to duplicate. The upper half of the screen was the table in the form of a spread sheet but the lower half had the items of each row in a little table with the items under each other. I have been unable to duplicate this format, which I really liked. Any suggestions?

With any form open hit the F4 key...that should do it

//drew

Sylvain

If Sylvain wants the additional grid view, that is accessible from the last button on the navigation tool bar or using a hyperlink button with URL ".uno:ViewFormAsGrid".

#6

Hi Drew,

Thank you for your long explanatory message, but I seem to miss something essential. Whenever I press the F4 key no matter where I am in Libre Office Base or Writer I get a set of four windows presuming that I have a projector on and giving me options on how to connect to it! I even tried the letter F key followed by the 4 one. No cigar! I don't know what this focused data control is about. I am puzzled but appreciate the trouble you are taking to help me.

Sylvain

#7

Are you on a laptop? Your function keys may have as default actions the control of laptop display functions and other provisions. (These are usually signified by a variety of symbols.)

Usually, there is a way to obtain the F4 key function. If the legend is in blue, look for a blue Fn key down in the bottom row of the keyboard. Hold that key depressed and then press the F4 key, then release them both.

- Dennis

#8

Am 05.03.2012 02:43, Dennis E. Hamilton wrote:

Are you on a laptop? Your function keys may have as default actions the control of laptop display functions and other provisions. (These are usually signified by a variety of symbols.)

Usually, there is a way to obtain the F4 key function. If the legend is in blue, look for a blue Fn key down in the bottom row of the keyboard. Hold that key depressed and then press the F4 key, then release them both.

  - Dennis

The F4 shortcut is the wrong answer because F4 calls the datasource window with tables and queries of the embedded form's database.
Command .uno:ViewFormAsGrid is accessible from the navigation tool bar's last button.

#9

Hello,

after a crash LO3.4 writer recovers documents, however it seems not to use the
regularly saved corrections.

However, looking up /tmp/.../0.odt I can find the very last corrections stored
and can manually recover from there.

Is this a flaw or a bad configuration at my system?

Walther

#10

Am 05.03.2012 02:43, Dennis E. Hamilton wrote:
> Are you on a laptop? Your function keys may have as default actions the control of laptop display functions and other provisions. (These are usually signified by a variety of symbols.)
>
> Usually, there is a way to obtain the F4 key function. If the legend is in blue, look for a blue Fn key down in the bottom row of the keyboard. Hold that key depressed and then press the F4 key, then release them both.
>
> - Dennis

The F4 shortcut is the wrong answer because F4 calls the datasource
window with tables and queries of the embedded form's database.
Command .uno:ViewFormAsGrid is accessible from the navigation tool bar's
last button.

your right - it was the wrong answer.

//drew

#11

I don't think that I have that last button on. I either have the wrong toolbar on or I have to add a button to it, but I don't know what button. Thanks for your help.

Sylvain

#12

Am 05.03.2012 18:30, Sylvain Bromberber wrote:

I don't think that I have that last button on. I either have the wrong
toolbar on or I have to add a button to it, but I don't know what
button. Thanks for your help.

Sylvain

The toolbar with all the buttons to let the form user interact with the loaded form by navigation, delete, save, reset, filter, sort. The last button is the one which opens the additional grid view.
The navigation bar may have been disabled in the form properties.

Download this: http://user.services.openoffice.org/en/forum/download/file.php?id=11250
and open any of the forms. The navigation bar refers to the records of the respective main form.

#13

Still no success. None of the buttons seem to do what you say. I then tried to modify the toolbar by adding buttons but none of the buttons made available under modification seem to do the job. Can you give me the name of the button or describe it? Thank you for your help!
Sylvain

#14

I downloaded that file but none of the buttons were buttons that I already had. None of the buttons opened or made available anything like uno: View Form As Grid or anything like it.

Sylvain

#15

Screenshot

#16

That picture was very helpful! However I still can't do it. I cannot get that Form Navigation tool bar to show up, as in your picture, or that icon to be added to any toolbar. I click on "Form Navigation" for toolbars when in a form and the option is available, and it is checked but nothing like the toolbar on your picture appears, nor does that icon seem available anywhere. Puzzle!

Sylvain.

#17

Am 06.03.2012 16:00, Sylvain Bromberber wrote:

That picture was very helpful! However I still can't do it. I cannot get
that Form Navigation tool bar to show up, as in your picture, or that
icon to be added to any toolbar. I click on "Form Navigation" for
toolbars when in a form and the option is available, and it is checked
but nothing like the toolbar on your picture appears, nor does that icon
seem available anywhere. Puzzle!

As already mentioned, the designer of the form can disable the toolbar. By default it is enabled. Open the form in edit mode, get the form properties and enable the navigation bar on the "Data" tab. In my forms the toolbar always refers to the main form since I set that property to "Parent Form" for all subforms of the main form.

#18

No data tab under properties of the form under Forms after I have opened in edit mode! The main Table has no properties options at all. Your instruction are absolutely clear. I don't see what I am missing.

#19

Hi Sylvain,
I don´t think that you are missing anything - sometimes an expert forgets that what is obvious for him is not necessarily obvious for others.
Provided that I got your problem try this:
> open your form in edit view => click empty area in the form (= set focus on form)
> find button 'Form' (on my PC screen it is the fourth button from up on a vertical toolbar to the left)
> that 'Form'-button opens the main form's properties
> click 'Data' tab => find 'Navigation bar'
OK?
Pertti Rönnberg

#20

Hi Pertti,

All that worked as you described. I found 'Navigation bar'. It was already marked "yes"! But no visible navigation bar with the icon on your example! Picking "Parent form" instead of yes made no difference. What is going on? Let me say again how much I appreciate the time and thought you put in helping me.

Sylvain