Examples of using Record source in English and their translations into Serbian
{-}
-
Colloquial
-
Ecclesiastic
-
Computer
-
Latin
-
Cyrillic
Record Source.
Begin by thinking about your report's record source.
Set& Record Source.
Detail This section is printed once for every row in the record source.
Use a query as the record source for a form or report.
Record source fields only Displays only the Fields available for this view section.
The tables or queries that provide the underlying data are also known as the report's record source.
If the record source does not yet exist, do one of the following.
The next time that you open the report,Access will display the most recent data from your record source.
The record source must contain all of the rows and columns of data you want display on the report.
If the fields that you want to include all exist in a single table,use that table as the record source.
Make sure the Record Source property of the report is using the parameter query you defined earlier.
Creates a simple, tabular report containing all of the fields in the record source you selected in the Navigation Pane.
Click Yes to change the record source to a query, or No to leave the record source unchanged.
You can use the DLookup function to display the value of a field that isn't in the record source for your form or report.
After you choose your record source, you will usually find it is easiest to create your report by using the Report Wizard.
You must use this dialog boxto specify a relationship between the other table and the form or report's record source.
Make the Record Source property for the chart the same as the Record Source property for the form or report.
In the Navigation Pane,open the table or query that will be the record source for your labels by double-clicking it.
Note: Changing the record source of an open form or report causes an automatic requery of the underlying data.
After viewing the report, you can save it and then close both the report and the underlying table orquery that you used as a record source.
You can refer to fields that are in the record source of a form or report but aren't displayed on the form or report.
You can use the DLookup function to display the value of a field that isn't in the record source for your form or report.
If the form or report's Record Source property is a SELECT statement or a table name, you can toggle the Field List pane display between the following two states.
You can use the DCount function to count the number of records containing a particular field that isn't in the record source on which your form or report is based.
Limiting the number of records contained in a form's record source can enhance performance, especially when your application is running on a network.
You might want to use the DSum function when you need to display the sum of a set of values from a field that is not in the record source for your form or report.
If the form or report's Record Source property is empty, and you drag a field from the Field List pane to the form or report, Access automatically fills in the form or report's Record Source property for you.
If you need to maintain a running total in a control on a report, you can use the RunningSum property of that control,if the field on which it is based is included in the record source for the report.
Note: If you have set the form or report's Record Source property to a saved query, the Field List pane displays only the Fields available for this view section(there is no Show all tables option at the bottom of the Field List pane).