1*cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2*cdf0e10cSrcweir 3*cdf0e10cSrcweir 4*cdf0e10cSrcweir<!-- 5*cdf0e10cSrcweir *********************************************************************** 6*cdf0e10cSrcweir * 7*cdf0e10cSrcweir * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 8*cdf0e10cSrcweir * 9*cdf0e10cSrcweir * Copyright 2000, 2010 Oracle and/or its affiliates. 10*cdf0e10cSrcweir * 11*cdf0e10cSrcweir * OpenOffice.org - a multi-platform office productivity suite 12*cdf0e10cSrcweir * 13*cdf0e10cSrcweir * This file is part of OpenOffice.org. 14*cdf0e10cSrcweir * 15*cdf0e10cSrcweir * OpenOffice.org is free software: you can redistribute it and/or modify 16*cdf0e10cSrcweir * it under the terms of the GNU Lesser General Public License version 3 17*cdf0e10cSrcweir * only, as published by the Free Software Foundation. 18*cdf0e10cSrcweir * 19*cdf0e10cSrcweir * OpenOffice.org is distributed in the hope that it will be useful, 20*cdf0e10cSrcweir * but WITHOUT ANY WARRANTY; without even the implied warranty of 21*cdf0e10cSrcweir * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 22*cdf0e10cSrcweir * GNU Lesser General Public License version 3 for more details 23*cdf0e10cSrcweir * (a copy is included in the LICENSE file that accompanied this code). 24*cdf0e10cSrcweir * 25*cdf0e10cSrcweir * You should have received a copy of the GNU Lesser General Public License 26*cdf0e10cSrcweir * version 3 along with OpenOffice.org. If not, see 27*cdf0e10cSrcweir * <http://www.openoffice.org/license.html> 28*cdf0e10cSrcweir * for a copy of the LGPLv3 License. 29*cdf0e10cSrcweir * 30*cdf0e10cSrcweir ************************************************************************ 31*cdf0e10cSrcweir --> 32*cdf0e10cSrcweir 33*cdf0e10cSrcweir<helpdocument version="1.0"> 34*cdf0e10cSrcweir<meta> 35*cdf0e10cSrcweir<topic id="textsharedmain0213xml" indexer="include" status="PUBLISH"> 36*cdf0e10cSrcweir<title id="tit" xml-lang="en-US">Form Navigation Bar</title> 37*cdf0e10cSrcweir<filename>/text/shared/main0213.xhp</filename> 38*cdf0e10cSrcweir</topic> 39*cdf0e10cSrcweir<history> 40*cdf0e10cSrcweir<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> 41*cdf0e10cSrcweir<lastedited date="2006-12-04T14:57:36">UFI: changed name from Form Toolbar to Navigation bar; dedr: reviewed</lastedited> 42*cdf0e10cSrcweir</history> 43*cdf0e10cSrcweir</meta> 44*cdf0e10cSrcweir<body> 45*cdf0e10cSrcweir<section id="formular"> 46*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3157896"><bookmark_value>toolbars; Form Navigation bar</bookmark_value> 47*cdf0e10cSrcweir<bookmark_value>Navigation bar;forms</bookmark_value> 48*cdf0e10cSrcweir<bookmark_value>sorting; data in forms</bookmark_value> 49*cdf0e10cSrcweir<bookmark_value>data; sorting in forms</bookmark_value> 50*cdf0e10cSrcweir<bookmark_value>forms;sorting data</bookmark_value> 51*cdf0e10cSrcweir</bookmark><comment>MW changed "toolbars;..."</comment> 52*cdf0e10cSrcweir<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> 53*cdf0e10cSrcweir<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> 54*cdf0e10cSrcweir</section> 55*cdf0e10cSrcweir<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> 56*cdf0e10cSrcweir<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> 57*cdf0e10cSrcweir<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> 58*cdf0e10cSrcweir<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> 59*cdf0e10cSrcweir<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> 60*cdf0e10cSrcweir<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> 61*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:AbsoluteRecord" id="bm_id3131892" localize="false"/> 62*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:AbsoluteRecord" id="bm_id3151383" localize="false"/> 63*cdf0e10cSrcweir<paragraph role="heading" id="hd_id3153192" xml-lang="en-US" level="2" l10n="U" oldref="4">Absolute Record</paragraph> 64*cdf0e10cSrcweir<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> 65*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:FirstRecord" id="bm_id2556384" localize="false"/> 66*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:FirstRecord" id="bm_id3155414" localize="false"/> 67*cdf0e10cSrcweir<paragraph role="heading" id="hd_id3153573" xml-lang="en-US" level="2" l10n="U" oldref="6">First Record</paragraph> 68*cdf0e10cSrcweir<table id="tbl_id3147428"> 69*cdf0e10cSrcweir<tablerow> 70*cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 71*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3154013" xml-lang="en-US" l10n="E"> 72*cdf0e10cSrcweir<image id="img_id3150010" src="res/sc10616.png" width="0.222inch" height="0.222inch"><alt id="alt_id3150010" xml-lang="en-US">Icon</alt> 73*cdf0e10cSrcweir </image></paragraph> 74*cdf0e10cSrcweir</tablecell> 75*cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 76*cdf0e10cSrcweir<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> 77*cdf0e10cSrcweir</tablecell> 78*cdf0e10cSrcweir</tablerow> 79*cdf0e10cSrcweir</table> 80*cdf0e10cSrcweir 81*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:PrevRecord" id="bm_id2338439" localize="false"/> 82*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:PrevRecord" id="bm_id3153159" localize="false"/> 83*cdf0e10cSrcweir<paragraph role="heading" id="hd_id3154792" xml-lang="en-US" level="2" l10n="U" oldref="8">Previous Record</paragraph> 84*cdf0e10cSrcweir<table id="tbl_id3155417"> 85*cdf0e10cSrcweir<tablerow> 86*cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 87*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3145647" xml-lang="en-US" l10n="E"> 88*cdf0e10cSrcweir<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> 89*cdf0e10cSrcweir </image></paragraph> 90*cdf0e10cSrcweir</tablecell> 91*cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 92*cdf0e10cSrcweir<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> 93*cdf0e10cSrcweir</tablecell> 94*cdf0e10cSrcweir</tablerow> 95*cdf0e10cSrcweir</table> 96*cdf0e10cSrcweir 97*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:NextRecord" id="bm_id2894208" localize="false"/> 98*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:NextRecord" id="bm_id3146900" localize="false"/> 99*cdf0e10cSrcweir<paragraph role="heading" id="hd_id3149121" xml-lang="en-US" level="2" l10n="U" oldref="10">Next Record</paragraph> 100*cdf0e10cSrcweir<table id="tbl_id3153947"> 101*cdf0e10cSrcweir<tablerow> 102*cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 103*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3146913" xml-lang="en-US" l10n="E"> 104*cdf0e10cSrcweir<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> 105*cdf0e10cSrcweir </image></paragraph> 106*cdf0e10cSrcweir</tablecell> 107*cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 108*cdf0e10cSrcweir<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> 109*cdf0e10cSrcweir</tablecell> 110*cdf0e10cSrcweir</tablerow> 111*cdf0e10cSrcweir</table> 112*cdf0e10cSrcweir 113*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:LastRecord" id="bm_id8390976" localize="false"/> 114*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:LastRecord" id="bm_id3156056" localize="false"/> 115*cdf0e10cSrcweir<paragraph role="heading" id="hd_id3148997" xml-lang="en-US" level="2" l10n="U" oldref="12">Last Record</paragraph> 116*cdf0e10cSrcweir<table id="tbl_id3147341"> 117*cdf0e10cSrcweir<tablerow> 118*cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 119*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3155337" xml-lang="en-US" l10n="E"> 120*cdf0e10cSrcweir<image id="img_id3163808" src="res/sc10619.png" width="0.222inch" height="0.222inch"><alt id="alt_id3163808" xml-lang="en-US">Icon</alt> 121*cdf0e10cSrcweir </image></paragraph> 122*cdf0e10cSrcweir</tablecell> 123*cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 124*cdf0e10cSrcweir<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> 125*cdf0e10cSrcweir</tablecell> 126*cdf0e10cSrcweir</tablerow> 127*cdf0e10cSrcweir</table> 128*cdf0e10cSrcweir 129*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:RecSave" id="bm_id450354" localize="false"/> 130*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:RecSave" id="bm_id3153963" localize="false"/> 131*cdf0e10cSrcweir<paragraph role="heading" id="hd_id3145231" xml-lang="en-US" level="2" l10n="U" oldref="14">Save Record</paragraph> 132*cdf0e10cSrcweir<table id="tbl_id3155938"> 133*cdf0e10cSrcweir<tablerow> 134*cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 135*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3150647" xml-lang="en-US" l10n="E"> 136*cdf0e10cSrcweir<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> 137*cdf0e10cSrcweir </image></paragraph> 138*cdf0e10cSrcweir</tablecell> 139*cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 140*cdf0e10cSrcweir<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> 141*cdf0e10cSrcweir</tablecell> 142*cdf0e10cSrcweir</tablerow> 143*cdf0e10cSrcweir</table> 144*cdf0e10cSrcweir 145*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:RecUndo" id="bm_id5478424" localize="false"/> 146*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:RecUndo" id="bm_id3148422" localize="false"/> 147*cdf0e10cSrcweir<paragraph role="heading" id="hd_id3158446" xml-lang="en-US" level="2" l10n="U" oldref="16">Undo: Data entry</paragraph> 148*cdf0e10cSrcweir<table id="tbl_id3155111"> 149*cdf0e10cSrcweir<tablerow> 150*cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 151*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3166423" xml-lang="en-US" l10n="E"> 152*cdf0e10cSrcweir<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> 153*cdf0e10cSrcweir </image></paragraph> 154*cdf0e10cSrcweir</tablecell> 155*cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 156*cdf0e10cSrcweir<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> 157*cdf0e10cSrcweir</tablecell> 158*cdf0e10cSrcweir</tablerow> 159*cdf0e10cSrcweir</table> 160*cdf0e10cSrcweir 161*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:NewRecord" id="bm_id9891476" localize="false"/> 162*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:NewRecord" id="bm_id3154589" localize="false"/> 163*cdf0e10cSrcweir<paragraph role="heading" id="hd_id3149967" xml-lang="en-US" level="2" l10n="U" oldref="18">New Record</paragraph> 164*cdf0e10cSrcweir<table id="tbl_id3150826"> 165*cdf0e10cSrcweir<tablerow> 166*cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 167*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3149735" xml-lang="en-US" l10n="E"> 168*cdf0e10cSrcweir<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> 169*cdf0e10cSrcweir </image></paragraph> 170*cdf0e10cSrcweir</tablecell> 171*cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 172*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3148460" xml-lang="en-US" l10n="U" oldref="19"><ahelp hid=".uno:NewRecord">Creates a new record.</ahelp></paragraph> 173*cdf0e10cSrcweir</tablecell> 174*cdf0e10cSrcweir</tablerow> 175*cdf0e10cSrcweir</table> 176*cdf0e10cSrcweir 177*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:DeleteRecord" id="bm_id9404569" localize="false"/> 178*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:DeleteRecord" id="bm_id3152994" localize="false"/> 179*cdf0e10cSrcweir<paragraph role="heading" id="hd_id3153659" xml-lang="en-US" level="2" l10n="U" oldref="20">Delete Record</paragraph> 180*cdf0e10cSrcweir<table id="tbl_id3166432"> 181*cdf0e10cSrcweir<tablerow> 182*cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 183*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3145584" xml-lang="en-US" l10n="E"> 184*cdf0e10cSrcweir<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> 185*cdf0e10cSrcweir </image></paragraph> 186*cdf0e10cSrcweir</tablecell> 187*cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 188*cdf0e10cSrcweir<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> 189*cdf0e10cSrcweir</tablecell> 190*cdf0e10cSrcweir</tablerow> 191*cdf0e10cSrcweir</table> 192*cdf0e10cSrcweir<embed href="text/shared/02/12050000.xhp#aktualisieren"/> 193*cdf0e10cSrcweir<embed href="text/shared/02/12050000.xhp#syaktualisieren"/> 194*cdf0e10cSrcweir<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> 195*cdf0e10cSrcweir<embed href="text/shared/02/12100200.xhp#suchentext"/> 196*cdf0e10cSrcweir<embed href="text/shared/00/00000450.xhp#sydatensuchen"/> 197*cdf0e10cSrcweir<embed href="text/shared/02/12010000.xhp#aufsteigend"/> 198*cdf0e10cSrcweir<embed href="text/shared/02/12010000.xhp#syaufsteigend"/> 199*cdf0e10cSrcweir<embed href="text/shared/02/12020000.xhp#absteigend"/> 200*cdf0e10cSrcweir<embed href="text/shared/02/12020000.xhp#syabsteigend"/> 201*cdf0e10cSrcweir<embed href="text/shared/02/12030000.xhp#autofilter"/> 202*cdf0e10cSrcweir<embed href="text/shared/02/12030000.xhp#syautofilter"/> 203*cdf0e10cSrcweir<embed href="text/shared/02/12110000.xhp#formbasedfilters"/> 204*cdf0e10cSrcweir<embed href="text/shared/02/12110000.xhp#syformfilter"/> 205*cdf0e10cSrcweir<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> 206*cdf0e10cSrcweir<embed href="text/shared/02/12100100.xhp#sortierentext"/> 207*cdf0e10cSrcweir<embed href="text/shared/00/00000450.xhp#sysortieren"/> 208*cdf0e10cSrcweir<embed href="text/shared/02/12040000.xhp#filterentfernen"/> 209*cdf0e10cSrcweir<embed href="text/shared/02/12040000.xhp#syfilterentfernen"/> 210*cdf0e10cSrcweir<embed href="text/shared/02/12130000.xhp#datenquelletab"/> 211*cdf0e10cSrcweir<embed href="text/shared/02/12130000.xhp#sydatenquelletab"/> 212*cdf0e10cSrcweir<embed href="text/shared/02/12120000.xhp#filteranwenden"/> 213*cdf0e10cSrcweir<embed href="text/shared/02/12120000.xhp#syfilteranwenden"/> 214*cdf0e10cSrcweir</body> 215*cdf0e10cSrcweir</helpdocument> 216
