- + -

Icon - +

Icon AutoFilter - + AutoFilter diff --git a/source/text/shared/02/12050000.xhp b/source/text/shared/02/12050000.xhp index 61b1c236aa..1e79559179 100644 --- a/source/text/shared/02/12050000.xhp +++ b/source/text/shared/02/12050000.xhp @@ -1,6 +1,4 @@ - - - @@ -32,18 +29,17 @@

-Refresh +

Refresh

Refreshes the displayed data. In a multi-user environment, refreshing the data ensures that it remains current.

- + -

Icon - +

Icon Refresh - + Refresh diff --git a/source/text/shared/02/12100100.xhp b/source/text/shared/02/12100100.xhp index 37947e6763..c46963aed7 100644 --- a/source/text/shared/02/12100100.xhp +++ b/source/text/shared/02/12100100.xhp @@ -30,7 +30,7 @@

-Sort Order +

Sort Order

Specifies the sort criteria for the data display.

@@ -38,14 +38,14 @@

While the functions Sort in Ascending Order and Sort in Descending Order sort by one criterion only, you can combine several criteria in the Sort Order dialog. You can remove a sorting that has been performed with the Reset Filter/Sorting icon. -Sorting +

Sorting

Use this area to enter sorting criteria. If you enter additional sorting criteria under and then, the data matching the content of the higher-order criterion is ordered according to the next criterion. If you sort the field name "First name" in ascending order and the field name "Last name" in descending order, all records will be sorted in ascending order by first name, and then within the first names, in descending order by last name. -Field name +

Field name

Specifies the data field name whose content will determine the sort order. -Order +

Order

Specifies the sort order (either ascending or descending). -and then +

and then

Specifies additional subordinate sort criteria from the other fields. diff --git a/source/text/shared/02/12110000.xhp b/source/text/shared/02/12110000.xhp index da597b6771..46f7932f0c 100644 --- a/source/text/shared/02/12110000.xhp +++ b/source/text/shared/02/12110000.xhp @@ -30,17 +30,17 @@

-Form-based Filters +

Form-based Filters

Prompts the database server to filter the visible data by specified criteria.

Unlike the normal search, which is activated by the Find Record icon on the Form bar, you can search more quickly by using the form-based filter. Usually a quick database server is charged with the search. Also, you can enter more complex search conditions.

- -

Icon + +

Icon Form Filter - + Form-based Filters diff --git a/source/text/shared/02/12120000.xhp b/source/text/shared/02/12120000.xhp index fd56ba479b..364410a83a 100644 --- a/source/text/shared/02/12120000.xhp +++ b/source/text/shared/02/12120000.xhp @@ -30,14 +30,14 @@

-Apply Filter +

Apply Filter

Switches between the filtered and unfiltered view of the table.

Icon +

Icon Form Filter Apply Filter diff --git a/source/text/shared/02/12130000.xhp b/source/text/shared/02/12130000.xhp index 828b8eae2b..655d185219 100644 --- a/source/text/shared/02/12130000.xhp +++ b/source/text/shared/02/12130000.xhp @@ -32,16 +32,16 @@ data sources; as tables -Data source as table +

Data source as table

Activates an additional table view when in the form view. When the Data source as table function is activated, you see the table in an area above the form.

- -

Icon + +

Icon - + Data source as table diff --git a/source/text/shared/main0213.xhp b/source/text/shared/main0213.xhp index 6445ffff0b..7c8e2370c1 100644 --- a/source/text/shared/main0213.xhp +++ b/source/text/shared/main0213.xhp @@ -1,192 +1,206 @@ - - - +* 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 . +--> - - -Form Navigation Bar -/text/shared/main0213.xhp - - -Sun Microsystems, Inc. - - - + + + Form Navigation Bar + /text/shared/main0213.xhp + + + Sun Microsystems, Inc. + + + toolbars; Form Navigation bar Navigation bar;forms sorting; data in forms data; sorting in forms forms;sorting data MW changed "toolbars;..." -Form Navigation Bar -The Form Navigation 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. -You can use the Form Navigation 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 Form Navigation bar also contains sort, filter, and search functions for data records. -You can use the Navigation bar icon on the More Controls bar to add a Navigation bar to a form. -The Navigation bar is only visible for forms connected to a database. In the Design view of a form, the Navigation bar is not available. See also Table Data bar. -You can control the view of data with the sorting and filtering functions. Original tables are not changed. -The current sort order or filter is saved with the current document. If a filter is set, the Apply Filter icon on the Navigation bar is activated. Sorting and filtering features in the document can also be configured in the Form Properties dialog. (Choose Form Properties - Data - properties Sort and Filter). -If an SQL statement is the basis for a form (see Form Properties - tab Data - Data Source), 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. - -Absolute Record -Shows the number of the current record. Enter a number to go to the corresponding record. - -First Record -

- - - -

Icon - - - -Takes you to the first record. - - -

Form Navigation Bar

+ The Form Navigation 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. + You can use the Form Navigation 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 Form Navigation bar also contains sort, filter, and search functions for data records. + You can use the Navigation bar icon on the More Controls bar to add a Navigation bar to a form. + The Navigation bar is only visible for forms connected to a database. In the Design view of a form, the Navigation bar is not available. See also Table Data bar. + You can control the view of data with the sorting and filtering functions. Original tables are not changed. + The current sort order or filter is saved with the current document. If a filter is set, the Apply Filter icon on the Navigation bar is activated. Sorting and filtering features in the document can also be configured in the Form Properties dialog. (Choose Form Properties - Data - properties Sort and Filter). + If an SQL statement is the basis for a form (see Form Properties - tab Data - Data Source), 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. - -Previous Record - - - - -