helpcontent2/source/text/shared/main0213.xhp

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