xref: /trunk/main/helpcontent2/source/text/shared/main0213.xhp (revision b1db92d383447409f83a216f123ce3285732e472)
1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?>
2cdf0e10cSrcweir
3226a8927SAndrew Rist<!--***********************************************************
4cdf0e10cSrcweir *
5226a8927SAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one
6226a8927SAndrew Rist * or more contributor license agreements.  See the NOTICE file
7226a8927SAndrew Rist * distributed with this work for additional information
8226a8927SAndrew Rist * regarding copyright ownership.  The ASF licenses this file
9226a8927SAndrew Rist * to you under the Apache License, Version 2.0 (the
10226a8927SAndrew Rist * "License"); you may not use this file except in compliance
11226a8927SAndrew Rist * with the License.  You may obtain a copy of the License at
12cdf0e10cSrcweir *
13226a8927SAndrew Rist *   http://www.apache.org/licenses/LICENSE-2.0
14cdf0e10cSrcweir *
15226a8927SAndrew Rist * Unless required by applicable law or agreed to in writing,
16226a8927SAndrew Rist * software distributed under the License is distributed on an
17226a8927SAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
18226a8927SAndrew Rist * KIND, either express or implied.  See the License for the
19226a8927SAndrew Rist * specific language governing permissions and limitations
20226a8927SAndrew Rist * under the License.
21cdf0e10cSrcweir *
22226a8927SAndrew Rist ***********************************************************-->
23226a8927SAndrew Rist
24cdf0e10cSrcweir<helpdocument version="1.0">
25cdf0e10cSrcweir<meta>
26cdf0e10cSrcweir<topic id="textsharedmain0213xml" indexer="include" status="PUBLISH">
27cdf0e10cSrcweir<title id="tit" xml-lang="en-US">Form Navigation Bar</title>
28cdf0e10cSrcweir<filename>/text/shared/main0213.xhp</filename>
29cdf0e10cSrcweir</topic>
308c7e84bbSmseidel<comment>changed name from Form Toolbar to Navigation bar</comment>
31cdf0e10cSrcweir</meta>
32cdf0e10cSrcweir<body>
33cdf0e10cSrcweir<section id="formular">
3488cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3157896">
3588cae784Smseidel<bookmark_value>Toolbars; Form Navigation bar</bookmark_value>
36cdf0e10cSrcweir<bookmark_value>Navigation bar; forms</bookmark_value>
37cdf0e10cSrcweir<bookmark_value>sorting; data in forms</bookmark_value>
38cdf0e10cSrcweir<bookmark_value>data; sorting in forms</bookmark_value>
39cdf0e10cSrcweir<bookmark_value>forms; sorting data</bookmark_value>
40cdf0e10cSrcweir</bookmark><comment>MW changed "toolbars;..."</comment>
41*b1db92d3Smseidel<paragraph role="heading" id="hd_id3157896" xml-lang="en-US" level="1" l10n="CHG"><link href="text/shared/main0213.xhp" name="Form Navigation Bar">Form Navigation Bar</link></paragraph>
42*b1db92d3Smseidel<paragraph role="paragraph" id="par_id3154751" xml-lang="en-US" l10n="CHG">The <emph>Form Navigation</emph> bar contains icons to edit a database table or to control the data view. The bar is displayed at the bottom of a document that contains fields that are linked to a database.</paragraph>
43cdf0e10cSrcweir</section>
44*b1db92d3Smseidel<paragraph role="paragraph" id="par_id3157958" xml-lang="en-US" l10n="CHG">You can use the <emph>Form Navigation</emph> bar to move within records as well as to insert and to delete records. If data is saved in a form, the changes are transferred to the database. The <emph>Form Navigation</emph> bar also contains sort, filter, and search functions for data records.</paragraph>
45cdf0e10cSrcweir<paragraph role="tip" id="par_idN10717" xml-lang="en-US" l10n="NEW">You can use the Navigation bar icon on the <link href="text/shared/02/01170000.xhp">More Controls </link> bar to add a Navigation bar to a form.</paragraph>
46*b1db92d3Smseidel<paragraph role="note" id="par_id3157910" xml-lang="en-US" l10n="CHG">The Navigation bar is only visible for forms connected to a database. In the <link href="text/shared/explorer/database/04030000.xhp" name="Design view">Design view</link> of a form, the Navigation bar is not available. See also <link href="text/shared/main0212.xhp" name="Database Bar">Table Data bar</link>.</paragraph>
47*b1db92d3Smseidel<paragraph role="paragraph" id="par_id3153880" xml-lang="en-US" l10n="U">You can control the view of data with the sorting and filtering functions. Original tables are not changed.</paragraph>
48*b1db92d3Smseidel<paragraph role="paragraph" id="par_id3153062" xml-lang="en-US" l10n="U">The current sort order or filter is saved with the current document. If a filter is set, the <emph>Apply Filter</emph> icon on the <emph>Navigation</emph> bar is activated. Sorting and filtering features in the document can also be configured in the <emph>Form Properties</emph> dialog. (Choose <emph>Form Properties - Data</emph> - properties <link href="text/shared/02/01170203.xhp" name="Sort"><emph>Sort</emph></link> and <link href="text/shared/02/01170203.xhp" name="Filter"><emph>Filter</emph></link>).</paragraph>
49*b1db92d3Smseidel<paragraph role="note" id="par_id3149810" xml-lang="en-US" l10n="U">If an SQL statement is the basis for a form (see <emph>Form Properties</emph> - tab <emph>Data</emph> - <link href="text/shared/02/01170203.xhp" name="Data Source"><emph>Data Source</emph></link>), then the filter and sort functions are only available when the SQL statement refers to only one table and is not written in the native SQL mode.</paragraph>
50cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:AbsoluteRecord" id="bm_id3131892" localize="false"/>
51cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:AbsoluteRecord" id="bm_id3151383" localize="false"/>
52*b1db92d3Smseidel<paragraph role="heading" id="hd_id3153192" xml-lang="en-US" level="2" l10n="U">Absolute Record</paragraph>
53*b1db92d3Smseidel<paragraph role="paragraph" id="par_id3146922" xml-lang="en-US" l10n="U"><ahelp hid=".uno:AbsoluteRecord">Shows the number of the current record. Enter a number to go to the corresponding record.</ahelp></paragraph>
54cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:FirstRecord" id="bm_id2556384" localize="false"/>
55cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:FirstRecord" id="bm_id3155414" localize="false"/>
56*b1db92d3Smseidel<paragraph role="heading" id="hd_id3153573" xml-lang="en-US" level="2" l10n="U">First Record</paragraph>
57cdf0e10cSrcweir<table id="tbl_id3147428">
58cdf0e10cSrcweir<tablerow>
59cdf0e10cSrcweir<tablecell colspan="" rowspan="">
60cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3154013" xml-lang="en-US" l10n="E">
619a5e7177SMatthias Seidel<image id="img_id3150010" src="res/commandimagelist/sc_firstrecord.png" width="0.222inch" height="0.222inch"><alt id="alt_id3150010" xml-lang="en-US">Icon</alt>
62cdf0e10cSrcweir</image></paragraph>
63cdf0e10cSrcweir</tablecell>
64cdf0e10cSrcweir<tablecell colspan="" rowspan="">
65*b1db92d3Smseidel<paragraph role="paragraph" id="par_id3155308" xml-lang="en-US" l10n="U"><ahelp hid=".uno:FirstRecord">Takes you to the first record.</ahelp></paragraph>
66cdf0e10cSrcweir</tablecell>
67cdf0e10cSrcweir</tablerow>
68cdf0e10cSrcweir</table>
69cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:PrevRecord" id="bm_id2338439" localize="false"/>
70cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:PrevRecord" id="bm_id3153159" localize="false"/>
71*b1db92d3Smseidel<paragraph role="heading" id="hd_id3154792" xml-lang="en-US" level="2" l10n="U">Previous Record</paragraph>
72cdf0e10cSrcweir<table id="tbl_id3155417">
73cdf0e10cSrcweir<tablerow>
74cdf0e10cSrcweir<tablecell colspan="" rowspan="">
75cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3145647" xml-lang="en-US" l10n="E">
76cdf0e10cSrcweir<image id="img_id3147394" src="res/commandimagelist/sc_prevrecord.png" width="0.222inch" height="0.222inch"><alt id="alt_id3147394" xml-lang="en-US">Icon</alt>
77cdf0e10cSrcweir</image></paragraph>
78cdf0e10cSrcweir</tablecell>
79cdf0e10cSrcweir<tablecell colspan="" rowspan="">
80*b1db92d3Smseidel<paragraph role="paragraph" id="par_id3157846" xml-lang="en-US" l10n="U"><ahelp hid=".uno:PrevRecord">Takes you to the previous record.</ahelp></paragraph>
81cdf0e10cSrcweir</tablecell>
82cdf0e10cSrcweir</tablerow>
83cdf0e10cSrcweir</table>
84cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:NextRecord" id="bm_id2894208" localize="false"/>
85cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:NextRecord" id="bm_id3146900" localize="false"/>
86*b1db92d3Smseidel<paragraph role="heading" id="hd_id3149121" xml-lang="en-US" level="2" l10n="U">Next Record</paragraph>
87cdf0e10cSrcweir<table id="tbl_id3153947">
88cdf0e10cSrcweir<tablerow>
89cdf0e10cSrcweir<tablecell colspan="" rowspan="">
90cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3146913" xml-lang="en-US" l10n="E">
91cdf0e10cSrcweir<image id="img_id3150753" src="res/commandimagelist/sc_nextrecord.png" width="0.222inch" height="0.222inch"><alt id="alt_id3150753" xml-lang="en-US">Icon</alt>
92cdf0e10cSrcweir</image></paragraph>
93cdf0e10cSrcweir</tablecell>
94cdf0e10cSrcweir<tablecell colspan="" rowspan="">
95*b1db92d3Smseidel<paragraph role="paragraph" id="par_id3148914" xml-lang="en-US" l10n="U"><ahelp hid=".uno:NextRecord">Takes you to the next record.</ahelp></paragraph>
96cdf0e10cSrcweir</tablecell>
97cdf0e10cSrcweir</tablerow>
98cdf0e10cSrcweir</table>
99cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:LastRecord" id="bm_id8390976" localize="false"/>
100cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:LastRecord" id="bm_id3156056" localize="false"/>
101*b1db92d3Smseidel<paragraph role="heading" id="hd_id3148997" xml-lang="en-US" level="2" l10n="U">Last Record</paragraph>
102cdf0e10cSrcweir<table id="tbl_id3147341">
103cdf0e10cSrcweir<tablerow>
104cdf0e10cSrcweir<tablecell colspan="" rowspan="">
105cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3155337" xml-lang="en-US" l10n="E">
1069a5e7177SMatthias Seidel<image id="img_id3163808" src="res/commandimagelist/sc_lastrecord.png" width="0.222inch" height="0.222inch"><alt id="alt_id3163808" xml-lang="en-US">Icon</alt>
107cdf0e10cSrcweir</image></paragraph>
108cdf0e10cSrcweir</tablecell>
109cdf0e10cSrcweir<tablecell colspan="" rowspan="">
110*b1db92d3Smseidel<paragraph role="paragraph" id="par_id3151248" xml-lang="en-US" l10n="U"><ahelp hid=".uno:LastRecord">Takes you to the last record.</ahelp></paragraph>
111cdf0e10cSrcweir</tablecell>
112cdf0e10cSrcweir</tablerow>
113cdf0e10cSrcweir</table>
114cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:RecSave" id="bm_id450354" localize="false"/>
115cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:RecSave" id="bm_id3153963" localize="false"/>
116*b1db92d3Smseidel<paragraph role="heading" id="hd_id3145231" xml-lang="en-US" level="2" l10n="U">Save Record</paragraph>
117cdf0e10cSrcweir<table id="tbl_id3155938">
118cdf0e10cSrcweir<tablerow>
119cdf0e10cSrcweir<tablecell colspan="" rowspan="">
120cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3150647" xml-lang="en-US" l10n="E">
121cdf0e10cSrcweir<image id="img_id3150941" src="res/commandimagelist/sc_recsave.png" width="0.222inch" height="0.222inch"><alt id="alt_id3150941" xml-lang="en-US">Icon</alt>
122cdf0e10cSrcweir</image></paragraph>
123cdf0e10cSrcweir</tablecell>
124cdf0e10cSrcweir<tablecell colspan="" rowspan="">
125*b1db92d3Smseidel<paragraph role="paragraph" id="par_id3146808" xml-lang="en-US" l10n="U"><ahelp hid=".uno:RecSave">Saves a new data entry. The change is registered in the database.</ahelp></paragraph>
126cdf0e10cSrcweir</tablecell>
127cdf0e10cSrcweir</tablerow>
128cdf0e10cSrcweir</table>
129cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:RecUndo" id="bm_id5478424" localize="false"/>
130cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:RecUndo" id="bm_id3148422" localize="false"/>
131*b1db92d3Smseidel<paragraph role="heading" id="hd_id3158446" xml-lang="en-US" level="2" l10n="U">Undo: Data entry</paragraph>
132cdf0e10cSrcweir<table id="tbl_id3155111">
133cdf0e10cSrcweir<tablerow>
134cdf0e10cSrcweir<tablecell colspan="" rowspan="">
135cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3166423" xml-lang="en-US" l10n="E">
136cdf0e10cSrcweir<image id="img_id3156138" src="res/commandimagelist/sc_recundo.png" width="0.222inch" height="0.222inch"><alt id="alt_id3156138" xml-lang="en-US">Icon</alt>
137cdf0e10cSrcweir</image></paragraph>
138cdf0e10cSrcweir</tablecell>
139cdf0e10cSrcweir<tablecell colspan="" rowspan="">
140*b1db92d3Smseidel<paragraph role="paragraph" id="par_id3151276" xml-lang="en-US" l10n="U"><ahelp hid=".uno:RecUndo">Allows you to undo a data entry.</ahelp></paragraph>
141cdf0e10cSrcweir</tablecell>
142cdf0e10cSrcweir</tablerow>
143cdf0e10cSrcweir</table>
144cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:NewRecord" id="bm_id9891476" localize="false"/>
145cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:NewRecord" id="bm_id3154589" localize="false"/>
146*b1db92d3Smseidel<paragraph role="heading" id="hd_id3149967" xml-lang="en-US" level="2" l10n="U">New Record</paragraph>
147cdf0e10cSrcweir<table id="tbl_id3150826">
148cdf0e10cSrcweir<tablerow>
149cdf0e10cSrcweir<tablecell colspan="" rowspan="">
150cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3149735" xml-lang="en-US" l10n="E">
151cdf0e10cSrcweir<image id="img_id3155578" src="res/commandimagelist/sc_newrecord.png" width="0.222inch" height="0.222inch"><alt id="alt_id3155578" xml-lang="en-US">Icon</alt>
152cdf0e10cSrcweir</image></paragraph>
153cdf0e10cSrcweir</tablecell>
154cdf0e10cSrcweir<tablecell colspan="" rowspan="">
155*b1db92d3Smseidel<paragraph role="paragraph" id="par_id3148460" xml-lang="en-US" l10n="U"><ahelp hid=".uno:NewRecord">Creates a new record.</ahelp></paragraph>
156cdf0e10cSrcweir</tablecell>
157cdf0e10cSrcweir</tablerow>
158cdf0e10cSrcweir</table>
159cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:DeleteRecord" id="bm_id9404569" localize="false"/>
160cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:DeleteRecord" id="bm_id3152994" localize="false"/>
161*b1db92d3Smseidel<paragraph role="heading" id="hd_id3153659" xml-lang="en-US" level="2" l10n="U">Delete Record</paragraph>
162cdf0e10cSrcweir<table id="tbl_id3166432">
163cdf0e10cSrcweir<tablerow>
164cdf0e10cSrcweir<tablecell colspan="" rowspan="">
165cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3145584" xml-lang="en-US" l10n="E">
166cdf0e10cSrcweir<image id="img_id3166434" src="res/commandimagelist/sc_deleterecord.png" width="0.222inch" height="0.222inch"><alt id="alt_id3166434" xml-lang="en-US">Icon</alt>
167cdf0e10cSrcweir</image></paragraph>
168cdf0e10cSrcweir</tablecell>
169cdf0e10cSrcweir<tablecell colspan="" rowspan="">
170*b1db92d3Smseidel<paragraph role="paragraph" id="par_id3148817" xml-lang="en-US" l10n="U"><ahelp hid=".uno:DeleteRecord">Deletes a record. A query needs to be confirmed before deleting.</ahelp></paragraph>
171cdf0e10cSrcweir</tablecell>
172cdf0e10cSrcweir</tablerow>
173cdf0e10cSrcweir</table>
174cdf0e10cSrcweir<embed href="text/shared/02/12050000.xhp#aktualisieren"/>
175cdf0e10cSrcweir<embed href="text/shared/02/12050000.xhp#syaktualisieren"/>
176*b1db92d3Smseidel<paragraph role="heading" id="hd_id3156448" xml-lang="en-US" level="2" l10n="U"><link href="text/shared/02/12100200.xhp" name="Find Record">Find Record</link></paragraph>
177cdf0e10cSrcweir<embed href="text/shared/02/12100200.xhp#suchentext"/>
178cdf0e10cSrcweir<embed href="text/shared/00/00000450.xhp#sydatensuchen"/>
179cdf0e10cSrcweir<embed href="text/shared/02/12010000.xhp#aufsteigend"/>
180cdf0e10cSrcweir<embed href="text/shared/02/12010000.xhp#syaufsteigend"/>
181cdf0e10cSrcweir<embed href="text/shared/02/12020000.xhp#absteigend"/>
182cdf0e10cSrcweir<embed href="text/shared/02/12020000.xhp#syabsteigend"/>
183cdf0e10cSrcweir<embed href="text/shared/02/12030000.xhp#autofilter"/>
184cdf0e10cSrcweir<embed href="text/shared/02/12030000.xhp#syautofilter"/>
185cdf0e10cSrcweir<embed href="text/shared/02/12110000.xhp#formbasedfilters"/>
186cdf0e10cSrcweir<embed href="text/shared/02/12110000.xhp#syformfilter"/>
187*b1db92d3Smseidel<paragraph role="heading" id="hd_id3148599" xml-lang="en-US" level="2" l10n="U"><link href="text/shared/02/12100100.xhp" name="Sort">Sort</link></paragraph>
188cdf0e10cSrcweir<embed href="text/shared/02/12100100.xhp#sortierentext"/>
189cdf0e10cSrcweir<embed href="text/shared/00/00000450.xhp#sysortieren"/>
190cdf0e10cSrcweir<embed href="text/shared/02/12040000.xhp#filterentfernen"/>
191cdf0e10cSrcweir<embed href="text/shared/02/12040000.xhp#syfilterentfernen"/>
192cdf0e10cSrcweir<embed href="text/shared/02/12130000.xhp#datenquelletab"/>
193cdf0e10cSrcweir<embed href="text/shared/02/12130000.xhp#sydatenquelletab"/>
194cdf0e10cSrcweir<embed href="text/shared/02/12120000.xhp#filteranwenden"/>
195cdf0e10cSrcweir<embed href="text/shared/02/12120000.xhp#syfilteranwenden"/>
196cdf0e10cSrcweir</body>
197cdf0e10cSrcweir</helpdocument>
198