diff options
Diffstat (limited to 'helpcontent2/source/text/shared/main0213.xhp')
| -rw-r--r-- | helpcontent2/source/text/shared/main0213.xhp | 212 |
1 files changed, 212 insertions, 0 deletions
diff --git a/helpcontent2/source/text/shared/main0213.xhp b/helpcontent2/source/text/shared/main0213.xhp new file mode 100644 index 0000000000..ad50aded7f --- /dev/null +++ b/helpcontent2/source/text/shared/main0213.xhp @@ -0,0 +1,212 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- +* This file is part of the LibreOffice project. +* +* This Source Code Form is subject to the terms of the Mozilla Public +* License, v. 2.0. If a copy of the MPL was not distributed with this +* file, You can obtain one at http://mozilla.org/MPL/2.0/. +* +* This file incorporates work covered by the following license notice: +* +* Licensed to the Apache Software Foundation (ASF) under one or more +* contributor license agreements. See the NOTICE file distributed +* with this work for additional information regarding copyright +* ownership. The ASF licenses this file to you under the Apache +* License, Version 2.0 (the "License"); you may not use this file +* except in compliance with the License. You may obtain a copy of +* the License at http://www.apache.org/licenses/LICENSE-2.0 . +--> +<helpdocument version="1.0"> + <meta> + <topic id="textsharedmain0213xml" indexer="include" status="PUBLISH"> + <title id="tit" xml-lang="en-US">Form Navigation Bar</title> + <filename>/text/shared/main0213.xhp</filename> + </topic> + <history> + <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> + </history> + </meta> + <body> +<bookmark xml-lang="en-US" branch="index" id="bm_id3157896"><bookmark_value>toolbars; Form Navigation bar</bookmark_value> +<bookmark_value>Navigation bar;forms</bookmark_value> +<bookmark_value>sorting; data in forms</bookmark_value> +<bookmark_value>data; sorting in forms</bookmark_value> +<bookmark_value>forms;sorting data</bookmark_value> +</bookmark> +<bookmark branch="hid/.uno:AvailableToolbars?Toolbar:string=formsnavigationbar" id="bm_id681690936494658" localize="false"/> + + + <section id="formnavigationbar"> + <h1 id="hd_id3157896"><link href="text/shared/main0213.xhp">Form Navigation Bar</link></h1> + <paragraph role="paragraph" id="par_id3154751" xml-lang="en-US">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> + </section> + + <paragraph role="paragraph" id="par_id3157958" xml-lang="en-US">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> + <tip id="par_idN10717">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.</tip> + <note id="par_id3157910">The Navigation bar is only visible for forms connected to a database. In the <link href="text/sdatabase/04030000.xhp">Design view</link> of a form, the Navigation bar is not available. See also <link href="text/shared/main0212.xhp">Table Data bar</link>.</note> + <paragraph role="paragraph" id="par_id3153880" xml-lang="en-US">You can control the view of data with the sorting and filtering functions. Original tables are not changed.</paragraph> + <paragraph role="paragraph" id="par_id3153062" xml-lang="en-US">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"><emph>Sort</emph></link> and <link href="text/shared/02/01170203.xhp"><emph>Filter</emph></link>).</paragraph> + <note id="par_id3149810">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"><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.</note> + + <h2 id="hd_id3156448"><link href="text/shared/02/12100200.xhp">Find Record</link></h2> + <embed href="text/shared/02/12100200.xhp#suchentext"/> + <embed href="text/shared/00/00000450.xhp#syfind_record"/> + + <bookmark xml-lang="en-US" branch="hid/.uno:AbsoluteRecord" id="bm_id3131892" localize="false"/> + <h2 id="hd_id3153192">Absolute Record</h2> + <paragraph role="paragraph" id="par_id3146922" xml-lang="en-US"><ahelp hid=".uno:AbsoluteRecord">Shows the number of the current record. Enter a number to go to the corresponding record.</ahelp></paragraph> + + <bookmark xml-lang="en-US" branch="hid/.uno:FirstRecord" id="bm_id2556384" localize="false"/> + <h2 id="hd_id3153573">First Record</h2> + <table id="tbl_id3147428"> + <tablerow> + <tablecell> + <paragraph role="paragraph" id="par_id3154013" xml-lang="en-US"><image id="img_id3150010" src="cmd/lc_firstrecord.svg" width="1cm" height="1cm"><alt id="alt_id3150010" xml-lang="en-US">Icon First Record</alt></image></paragraph> + </tablecell> + <tablecell> + <paragraph role="paragraph" id="par_id3155308" xml-lang="en-US"><ahelp hid=".uno:FirstRecord">Takes you to the first record.</ahelp></paragraph> + </tablecell> + </tablerow> + </table> + + <bookmark xml-lang="en-US" branch="hid/.uno:PrevRecord" id="bm_id2338439" localize="false"/> + <h2 id="hd_id3154792">Previous Record</h2> + <table id="tbl_id3155417"> + <tablerow> + <tablecell> + <paragraph role="paragraph" id="par_id3145647" xml-lang="en-US"> + <image id="img_id3147394" src="cmd/lc_prevrecord.svg" width="1cm" height="1cm"><alt id="alt_id3147394" xml-lang="en-US">Icon Previous Record</alt> + </image></paragraph> + </tablecell> + <tablecell> + <paragraph role="paragraph" id="par_id3157846" xml-lang="en-US"><ahelp hid=".uno:PrevRecord">Takes you to the previous record.</ahelp></paragraph> + </tablecell> + </tablerow> + </table> + + <bookmark xml-lang="en-US" branch="hid/.uno:NextRecord" id="bm_id2894208" localize="false"/> + <h2 id="hd_id3149121">Next Record</h2> + <table id="tbl_id3153947"> + <tablerow> + <tablecell> + <paragraph role="paragraph" id="par_id3146913" xml-lang="en-US"> + <image id="img_id3150753" src="cmd/lc_nextrecord.svg" width="1cm" height="1cm"><alt id="alt_id3150753" xml-lang="en-US">Icon Next Record</alt></image></paragraph> + </tablecell> + <tablecell> + <paragraph role="paragraph" id="par_id3148914" xml-lang="en-US"><ahelp hid=".uno:NextRecord">Takes you to the next record.</ahelp></paragraph> + </tablecell> + </tablerow> + </table> + + <bookmark xml-lang="en-US" branch="hid/.uno:LastRecord" id="bm_id8390976" localize="false"/> + <h2 id="hd_id3148997">Last Record</h2> + <table id="tbl_id3147341"> + <tablerow> + <tablecell> + <paragraph role="paragraph" id="par_id3155337" xml-lang="en-US"> + <image id="img_id3163808" src="cmd/lc_lastrecord.svg" width="1cm" height="1cm"><alt id="alt_id3163808" xml-lang="en-US">Icon Last Record</alt></image></paragraph> + </tablecell> + <tablecell> + <paragraph role="paragraph" id="par_id3151248" xml-lang="en-US"><ahelp hid=".uno:LastRecord">Takes you to the last record.</ahelp></paragraph> + </tablecell> + </tablerow> + </table> + + <bookmark xml-lang="en-US" branch="hid/.uno:NewRecord" id="bm_id9891476" localize="false"/> + <h2 id="hd_id3149967">New Record</h2> + <table id="tbl_id3150826"> + <tablerow> + <tablecell> + <paragraph role="paragraph" id="par_id3149735" xml-lang="en-US"> + <image id="img_id3155578" src="cmd/lc_newrecord.svg" width="1cm" height="1cm"><alt id="alt_id3155578" xml-lang="en-US">Icon New Record</alt></image></paragraph> + </tablecell> + <tablecell> + <paragraph role="paragraph" id="par_id3148460" xml-lang="en-US"><ahelp hid=".uno:NewRecord">Creates a new record.</ahelp></paragraph> + </tablecell> + </tablerow> + </table> + + <bookmark xml-lang="en-US" branch="hid/.uno:RecSave" id="bm_id450354" localize="false"/> + <h2 id="hd_id3145231">Save Record</h2> + <table id="tbl_id3155938"> + <tablerow> + <tablecell> + <paragraph role="paragraph" id="par_id3150647" xml-lang="en-US"> + <image id="img_id3150941" src="cmd/lc_recsave.svg" width="1cm" height="1cm"><alt id="alt_id3150941" xml-lang="en-US">Icon</alt></image></paragraph> + </tablecell> + <tablecell> + <paragraph role="paragraph" id="par_id3146808" xml-lang="en-US"><ahelp hid=".uno:RecSave">Saves a new data entry. The change is registered in the database.</ahelp></paragraph> + </tablecell> + </tablerow> + </table> + + <bookmark xml-lang="en-US" branch="hid/.uno:RecUndo" id="bm_id5478424" localize="false"/> + <h2 id="hd_id3158446">Undo: Data entry</h2> + <table id="tbl_id3155111"> + <tablerow> + <tablecell> + <paragraph role="paragraph" id="par_id3166423" xml-lang="en-US"> + <image id="img_id3156138" src="cmd/lc_recundo.png" width="1cm" height="1cm"><alt id="alt_id3156138" xml-lang="en-US">Icon Undo Data Entry</alt></image></paragraph> + </tablecell> + <tablecell> + <paragraph role="paragraph" id="par_id3151276" xml-lang="en-US"><ahelp hid=".uno:RecUndo">Allows you to undo a data entry.</ahelp></paragraph> + </tablecell> + </tablerow> + </table> + + <bookmark xml-lang="en-US" branch="hid/.uno:DeleteRecord" id="bm_id9404569" localize="false"/> + <h2 id="hd_id3153659">Delete Record</h2> + <table id="tbl_id3166432"> + <tablerow> + <tablecell> + <paragraph role="paragraph" id="par_id3145584" xml-lang="en-US"> + <image id="img_id3166434" src="cmd/lc_deleterecord.svg" width="1cm" height="1cm"><alt id="alt_id3166434" xml-lang="en-US">Icon Delete Record</alt></image></paragraph> + </tablecell> + <tablecell> + <paragraph role="paragraph" id="par_id3148817" xml-lang="en-US"><ahelp hid=".uno:DeleteRecord">Deletes a record. A query needs to be confirmed before deleting.</ahelp></paragraph> + </tablecell> + </tablerow> + </table> + <embed href="text/shared/02/12050000.xhp#refresh"/> + <embed href="text/shared/02/12050000.xhp#syrefresh"/> + + <bookmark xml-lang="en-US" branch="hid/.uno:RefreshFormControl" id="bm_id31647005174461" localize="false"/> + <h2 id="hd_id161647003427601">Refresh Control</h2> +<table id="tab_id21647005853278"> + <tablerow> + <tablecell> + <paragraph role="paragraph" id="par_id861647005853278"><image src="cmd/lc_refreshformcontrol.svg" id="img_id901647005853278" width="1cm" height="1cm"><alt id="alt_id581647005853278">Icon Refresh Control</alt></image></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id811647005853278" role="paragraph">Refresh current control</paragraph> + </tablecell> + </tablerow> +</table> + + <h2 id="hd_id3148599"><link href="text/shared/02/12100100.xhp">Sort</link></h2> + <embed href="text/shared/02/12100100.xhp#sortierentext"/> + <embed href="text/shared/00/00000450.xhp#sysort_order"/> + + <embed href="text/shared/02/12010000.xhp#sortascending"/> + <embed href="text/scalc/00/00000412.xhp#sortascending"/> + + <embed href="text/shared/02/12020000.xhp#sortdescending"/> + <embed href="text/scalc/00/00000412.xhp#sortdescending"/> + + <embed href="text/shared/02/12030000.xhp#autofilter"/> + <embed href="text/shared/02/12030000.xhp#syautofilter"/> + + <embed href="text/shared/02/12120000.xhp#apply_filter"/> + <embed href="text/shared/02/12120000.xhp#syapply_filter"/> + + <embed href="text/shared/02/12110000.xhp#formbasedfilters"/> + + <embed href="text/shared/02/12110000.xhp#syformfilter"/> + + <embed href="text/shared/02/12040000.xhp#reset_filter"/> + <embed href="text/shared/02/12040000.xhp#syreset_filter"/> + + <embed href="text/shared/02/12130000.xhp#data_source_as_table"/> + <embed href="text/shared/02/12130000.xhp#sydata_source_as_table"/> +</body> +</helpdocument> |