1<?xml version="1.0" encoding="UTF-8"?>
2
3
4<!--***********************************************************
5 *
6 * Licensed to the Apache Software Foundation (ASF) under one
7 * or more contributor license agreements.  See the NOTICE file
8 * distributed with this work for additional information
9 * regarding copyright ownership.  The ASF licenses this file
10 * to you under the Apache License, Version 2.0 (the
11 * "License"); you may not use this file except in compliance
12 * with the License.  You may obtain a copy of the License at
13 *
14 *   http://www.apache.org/licenses/LICENSE-2.0
15 *
16 * Unless required by applicable law or agreed to in writing,
17 * software distributed under the License is distributed on an
18 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
19 * KIND, either express or implied.  See the License for the
20 * specific language governing permissions and limitations
21 * under the License.
22 *
23 ***********************************************************-->
24
25
26
27<helpdocument version="1.0">
28<meta>
29<topic id="textsharedmain0213xml" indexer="include" status="PUBLISH">
30<title id="tit" xml-lang="en-US">Form Navigation Bar</title>
31<filename>/text/shared/main0213.xhp</filename>
32</topic>
33<history>
34<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
35<lastedited date="2006-12-04T14:57:36">UFI: changed name from Form Toolbar to Navigation bar; dedr: reviewed</lastedited>
36</history>
37</meta>
38<body>
39<section id="formular">
40<bookmark xml-lang="en-US" branch="index" id="bm_id3157896"><bookmark_value>toolbars; Form Navigation bar</bookmark_value>
41<bookmark_value>Navigation bar; forms</bookmark_value>
42<bookmark_value>sorting; data in forms</bookmark_value>
43<bookmark_value>data; sorting in forms</bookmark_value>
44<bookmark_value>forms; sorting data</bookmark_value>
45</bookmark><comment>MW changed "toolbars;..."</comment>
46<paragraph role="heading" id="hd_id3157896" xml-lang="en-US" level="1" l10n="CHG" oldref="1"><link href="text/shared/main0213.xhp" name="Form Navigation Bar">Form Navigation Bar</link></paragraph>
47<paragraph role="paragraph" id="par_id3154751" xml-lang="en-US" l10n="CHG" oldref="2">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>
48</section>
49<paragraph role="paragraph" id="par_id3157958" xml-lang="en-US" l10n="CHG" oldref="27">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>
50<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>
51<paragraph role="note" id="par_id3157910" xml-lang="en-US" l10n="CHG" oldref="3">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>
52<paragraph role="paragraph" id="par_id3153880" xml-lang="en-US" l10n="U" oldref="22">You can control the view of data with the sorting and filtering functions. Original tables are not changed.</paragraph>
53<paragraph role="paragraph" id="par_id3153062" xml-lang="en-US" l10n="U" oldref="23">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>
54<paragraph role="note" id="par_id3149810" xml-lang="en-US" l10n="U" oldref="24">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>
55<bookmark xml-lang="en-US" branch="hid/.uno:AbsoluteRecord" id="bm_id3131892" localize="false"/>
56<bookmark xml-lang="en-US" branch="hid/.uno:AbsoluteRecord" id="bm_id3151383" localize="false"/>
57<paragraph role="heading" id="hd_id3153192" xml-lang="en-US" level="2" l10n="U" oldref="4">Absolute Record</paragraph>
58<paragraph role="paragraph" id="par_id3146922" xml-lang="en-US" l10n="U" oldref="5"><ahelp hid=".uno:AbsoluteRecord">Shows the number of the current record. Enter a number to go to the corresponding record.</ahelp></paragraph>
59<bookmark xml-lang="en-US" branch="hid/.uno:FirstRecord" id="bm_id2556384" localize="false"/>
60<bookmark xml-lang="en-US" branch="hid/.uno:FirstRecord" id="bm_id3155414" localize="false"/>
61<paragraph role="heading" id="hd_id3153573" xml-lang="en-US" level="2" l10n="U" oldref="6">First Record</paragraph>
62<table id="tbl_id3147428">
63<tablerow>
64<tablecell colspan="" rowspan="">
65<paragraph role="paragraph" id="par_id3154013" xml-lang="en-US" l10n="E">
66<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>
67	</image></paragraph>
68</tablecell>
69<tablecell colspan="" rowspan="">
70<paragraph role="paragraph" id="par_id3155308" xml-lang="en-US" l10n="U" oldref="7"><ahelp hid=".uno:FirstRecord">Takes you to the first record.</ahelp></paragraph>
71</tablecell>
72</tablerow>
73</table>
74
75<bookmark xml-lang="en-US" branch="hid/.uno:PrevRecord" id="bm_id2338439" localize="false"/>
76<bookmark xml-lang="en-US" branch="hid/.uno:PrevRecord" id="bm_id3153159" localize="false"/>
77<paragraph role="heading" id="hd_id3154792" xml-lang="en-US" level="2" l10n="U" oldref="8">Previous Record</paragraph>
78<table id="tbl_id3155417">
79<tablerow>
80<tablecell colspan="" rowspan="">
81<paragraph role="paragraph" id="par_id3145647" xml-lang="en-US" l10n="E">
82<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>
83	</image></paragraph>
84</tablecell>
85<tablecell colspan="" rowspan="">
86<paragraph role="paragraph" id="par_id3157846" xml-lang="en-US" l10n="U" oldref="9"><ahelp hid=".uno:PrevRecord">Takes you to the previous record.</ahelp></paragraph>
87</tablecell>
88</tablerow>
89</table>
90
91<bookmark xml-lang="en-US" branch="hid/.uno:NextRecord" id="bm_id2894208" localize="false"/>
92<bookmark xml-lang="en-US" branch="hid/.uno:NextRecord" id="bm_id3146900" localize="false"/>
93<paragraph role="heading" id="hd_id3149121" xml-lang="en-US" level="2" l10n="U" oldref="10">Next Record</paragraph>
94<table id="tbl_id3153947">
95<tablerow>
96<tablecell colspan="" rowspan="">
97<paragraph role="paragraph" id="par_id3146913" xml-lang="en-US" l10n="E">
98<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>
99	</image></paragraph>
100</tablecell>
101<tablecell colspan="" rowspan="">
102<paragraph role="paragraph" id="par_id3148914" xml-lang="en-US" l10n="U" oldref="11"><ahelp hid=".uno:NextRecord">Takes you to the next record.</ahelp></paragraph>
103</tablecell>
104</tablerow>
105</table>
106
107<bookmark xml-lang="en-US" branch="hid/.uno:LastRecord" id="bm_id8390976" localize="false"/>
108<bookmark xml-lang="en-US" branch="hid/.uno:LastRecord" id="bm_id3156056" localize="false"/>
109<paragraph role="heading" id="hd_id3148997" xml-lang="en-US" level="2" l10n="U" oldref="12">Last Record</paragraph>
110<table id="tbl_id3147341">
111<tablerow>
112<tablecell colspan="" rowspan="">
113<paragraph role="paragraph" id="par_id3155337" xml-lang="en-US" l10n="E">
114<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>
115	</image></paragraph>
116</tablecell>
117<tablecell colspan="" rowspan="">
118<paragraph role="paragraph" id="par_id3151248" xml-lang="en-US" l10n="U" oldref="13"><ahelp hid=".uno:LastRecord">Takes you to the last record.</ahelp></paragraph>
119</tablecell>
120</tablerow>
121</table>
122
123<bookmark xml-lang="en-US" branch="hid/.uno:RecSave" id="bm_id450354" localize="false"/>
124<bookmark xml-lang="en-US" branch="hid/.uno:RecSave" id="bm_id3153963" localize="false"/>
125<paragraph role="heading" id="hd_id3145231" xml-lang="en-US" level="2" l10n="U" oldref="14">Save Record</paragraph>
126<table id="tbl_id3155938">
127<tablerow>
128<tablecell colspan="" rowspan="">
129<paragraph role="paragraph" id="par_id3150647" xml-lang="en-US" l10n="E">
130<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>
131	</image></paragraph>
132</tablecell>
133<tablecell colspan="" rowspan="">
134<paragraph role="paragraph" id="par_id3146808" xml-lang="en-US" l10n="U" oldref="15"><ahelp hid=".uno:RecSave">Saves a new data entry. The change is registered in the database.</ahelp></paragraph>
135</tablecell>
136</tablerow>
137</table>
138
139<bookmark xml-lang="en-US" branch="hid/.uno:RecUndo" id="bm_id5478424" localize="false"/>
140<bookmark xml-lang="en-US" branch="hid/.uno:RecUndo" id="bm_id3148422" localize="false"/>
141<paragraph role="heading" id="hd_id3158446" xml-lang="en-US" level="2" l10n="U" oldref="16">Undo: Data entry</paragraph>
142<table id="tbl_id3155111">
143<tablerow>
144<tablecell colspan="" rowspan="">
145<paragraph role="paragraph" id="par_id3166423" xml-lang="en-US" l10n="E">
146<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>
147	</image></paragraph>
148</tablecell>
149<tablecell colspan="" rowspan="">
150<paragraph role="paragraph" id="par_id3151276" xml-lang="en-US" l10n="U" oldref="17"><ahelp hid=".uno:RecUndo">Allows you to undo a data entry.</ahelp></paragraph>
151</tablecell>
152</tablerow>
153</table>
154
155<bookmark xml-lang="en-US" branch="hid/.uno:NewRecord" id="bm_id9891476" localize="false"/>
156<bookmark xml-lang="en-US" branch="hid/.uno:NewRecord" id="bm_id3154589" localize="false"/>
157<paragraph role="heading" id="hd_id3149967" xml-lang="en-US" level="2" l10n="U" oldref="18">New Record</paragraph>
158<table id="tbl_id3150826">
159<tablerow>
160<tablecell colspan="" rowspan="">
161<paragraph role="paragraph" id="par_id3149735" xml-lang="en-US" l10n="E">
162<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>
163	</image></paragraph>
164</tablecell>
165<tablecell colspan="" rowspan="">
166<paragraph role="paragraph" id="par_id3148460" xml-lang="en-US" l10n="U" oldref="19"><ahelp hid=".uno:NewRecord">Creates a new record.</ahelp></paragraph>
167</tablecell>
168</tablerow>
169</table>
170
171<bookmark xml-lang="en-US" branch="hid/.uno:DeleteRecord" id="bm_id9404569" localize="false"/>
172<bookmark xml-lang="en-US" branch="hid/.uno:DeleteRecord" id="bm_id3152994" localize="false"/>
173<paragraph role="heading" id="hd_id3153659" xml-lang="en-US" level="2" l10n="U" oldref="20">Delete Record</paragraph>
174<table id="tbl_id3166432">
175<tablerow>
176<tablecell colspan="" rowspan="">
177<paragraph role="paragraph" id="par_id3145584" xml-lang="en-US" l10n="E">
178<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>
179	</image></paragraph>
180</tablecell>
181<tablecell colspan="" rowspan="">
182<paragraph role="paragraph" id="par_id3148817" xml-lang="en-US" l10n="U" oldref="21"><ahelp hid=".uno:DeleteRecord">Deletes a record. A query needs to be confirmed before deleting.</ahelp></paragraph>
183</tablecell>
184</tablerow>
185</table>
186<embed href="text/shared/02/12050000.xhp#aktualisieren"/>
187<embed href="text/shared/02/12050000.xhp#syaktualisieren"/>
188<paragraph role="heading" id="hd_id3156448" xml-lang="en-US" level="2" l10n="U" oldref="25"><link href="text/shared/02/12100200.xhp" name="Find Record">Find Record</link></paragraph>
189<embed href="text/shared/02/12100200.xhp#suchentext"/>
190<embed href="text/shared/00/00000450.xhp#sydatensuchen"/>
191<embed href="text/shared/02/12010000.xhp#aufsteigend"/>
192<embed href="text/shared/02/12010000.xhp#syaufsteigend"/>
193<embed href="text/shared/02/12020000.xhp#absteigend"/>
194<embed href="text/shared/02/12020000.xhp#syabsteigend"/>
195<embed href="text/shared/02/12030000.xhp#autofilter"/>
196<embed href="text/shared/02/12030000.xhp#syautofilter"/>
197<embed href="text/shared/02/12110000.xhp#formbasedfilters"/>
198<embed href="text/shared/02/12110000.xhp#syformfilter"/>
199<paragraph role="heading" id="hd_id3148599" xml-lang="en-US" level="2" l10n="U" oldref="26"><link href="text/shared/02/12100100.xhp" name="Sort">Sort</link></paragraph>
200<embed href="text/shared/02/12100100.xhp#sortierentext"/>
201<embed href="text/shared/00/00000450.xhp#sysortieren"/>
202<embed href="text/shared/02/12040000.xhp#filterentfernen"/>
203<embed href="text/shared/02/12040000.xhp#syfilterentfernen"/>
204<embed href="text/shared/02/12130000.xhp#datenquelletab"/>
205<embed href="text/shared/02/12130000.xhp#sydatenquelletab"/>
206<embed href="text/shared/02/12120000.xhp#filteranwenden"/>
207<embed href="text/shared/02/12120000.xhp#syfilteranwenden"/>
208</body>
209</helpdocument>
210