In the DefaultSort property box, type the name of the field or fields you want to sort on. Separate multiple field names with a comma. If you want to sort in ascending or descending order, you can follow each name with a space and the keyword ASC or DESC, respectively. For example, type OrderDate DESC, OrderID ASC. If you don't specify the order, Microsoft Access sorts in ascending order.

If the control you want to sort on is bound to an expression (expression: Any combination of mathematical or logical operators, constants, functions, and names of fields, controls, and properties that evaluates to a single value. Expressions can perform calculations, manipulate characters, or test data.), you must type the alias of the control as displayed in its ControlSource property. For example, if the ControlSource property of the control you want to sort on is set to GroupOfExtendedPrice: ExtendedPrice, type GroupOfExtendedPrice in the DefaultSort property box.

You attempted to type an expression (expression: Any combination of mathematical or logical operators, constants, functions, and names of fields, controls, and properties that evaluates to a single value. Expressions can perform calculations, manipulate characters, or test data.) that includes the name of a field that is not in the data definition (data definition: The fields in underlying tables and queries, and the expressions, that make up the record source for a data access page.) of the page. Any field that you reference in an expression on a data access page must be in that page's data definition. To add a field to the page's data definition, drag the field from the field list (field list: A window that lists all the fields in the underlying record source or database object, except in data access page Design view. In data access page Design view, it lists all the record sources and their fields in the underlying database.) to the data access page. If you don't want to show the values (value: The text, date, number, or logical input that completes a condition that a field must meet for searching or filtering. For example, the field Author with the condition equals must include a value, such as John, to be complete.) in the field on the page, you can hide or delete the control bound to the field. However, even if you delete the control, a field referenced in an expression remains part of the page's data definition.

You've bound a control on a data access page to a calculated field (calculated field: A field, defined in a query, that displays the result of an expression rather than displaying stored data. The value is recalculated each time a value in the expression changes.) that uses a function that isn't supported on data access pages.

To select multiple controls, you must have Microsoft Internet Explorer 5.5 or later installed on your computer.

Check the version of Microsoft Internet Explorer that is installed on your computer. If you don't have Internet Explorer version 5.5 or later, you will not be able to select and work with multiple controls, or see some properties and toolbars.

• In the regional settings of Microsoft Windows Control Panel, your location is set to a region that uses a character other than a period (.) as a decimal separator. The settings for properties in data access pages require that the decimal separator be a period for all languages. Either change the region or set the decimal symbol to a period in Windows Control Panel regional settings.

• The value (value: The text, date, number, or logical input that completes a condition that a field must meet for searching or filtering. For example, the field Author with the condition equals must include a value, such as John, to be complete.) you typed in the property sheet does not match the data type (data type: The characteristic of a field that determines what type of data it can hold. Data types include Boolean, Integer, Long, Currency, Single, Double, Date, String, and Variant (default).) of the property. For example, the Width property of a section can be set to any number, but if you type a string such as Narrow, you will get the "Invalid argument" message.

• The Command Button Wizard is not available on a stand-alone data access page — a page that you open without having a database open. This wizard also is not available if the page isn't bound to a table or query (query: A question about the data stored in your tables, or a request to perform an action on the data. A query can bring together data from multiple tables to serve as the source of data for a form, report, or data access page.).

• The List Box Wizard and the Combo Box Wizard aren't available on stand-alone data access pages. The wizards also are not available when the page is connected to a database other than the one that's currently open.

If you are entering a value (value: The text, date, number, or logical input that completes a condition that a field must meet for searching or filtering. For example, the field Author with the condition equals must include a value, such as John, to be complete.) in a property that has a drop-down list, select a value from the list. For information about valid values for properties that don't have drop-down lists, press F1 in the property box.

If you are entering an expression (expression: Any combination of mathematical or logical operators, constants, functions, and names of fields, controls, and properties that evaluates to a single value. Expressions can perform calculations, manipulate characters, or test data.) in the ControlSource property box, make sure:

• You precede the expression with an equal sign (=) or an alias for the expression. For example, both of the following are valid settings:

  =Quantity*UnitPrice
  								

  ExtendedPrice: Quantity*UnitPrice
  								

• The data access page is bound to a table, query (query: A question about the data stored in your tables, or a request to perform an action on the data. A query can bring together data from multiple tables to serve as the source of data for a form, report, or data access page.), or other record source (record source: The underlying source of data for a form, report, or data access page. In an Access database, it could be a table, query, or SQL statement. In an Access project, it could be a table, view, SQL statement, or stored procedure.) before you attempt to enter the expression. You can't use expressions on a data access page that isn't bound to data.
• The ID property of a calculated control (calculated control: A control that is used on a form, report, or data access page to display the result of an expression. The result is recalculated each time there is a change in any of the values on which the expression is based.) is set to a unique name. Don't use the name of one of the fields you used in the expression or the ID of another control on the data access page.

When you save a data access page in Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.), all supporting files — such as bullets, background textures, and graphics — are by default stored in a separate folder. If you do not want to use a separate folder, do the following:

1. Open the data access page in Design view.

2. On the Tools menu, click Options, and then click the General tab.

3. Click Web Options, and then click the Files tab.

4. Under File names and locations, clear the Organize supporting files in a folder check box.

When you save your file as a data access page in Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.), all supporting files — such as bullets, background textures, and graphics — are by default organized in a supporting folder. If you move or copy your data access page to another location, you must also move the supporting folder so that you maintain all links to your page.

When you save a data access page in Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.), a backup copy is not automatically created. To save a copy of a data access page, click Save As on the File menu. In the Save Data Access Page <object name> To box, type a new name for the data access page, and then click OK.

When you save your data access page in Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.), all supporting files — such as bullets, background textures, and graphics — are by default organized in a supporting folder. By default, the name of the supporting folder is the name of the data access page plus an underscore (_), a period (.), or a hyphen (-) and the word "files." The word "files" will appear in the language of the version of Microsoft Office that was used to save the file as a data access page. For example, suppose you use the Dutch language version of Office to save a file called Page1 as a data access page. The default name of the supporting folder would be Page1_bestanden.

 Note   If you save your data access page with a short file name (a maximum of eight characters, plus a three-character file extension) by clearing the Use long file names whenever possible check box in the Web Options dialog box, the supporting folder is the name of the data access page without the word "files."

The HTML (HTML: The standard markup language used for documents on the World Wide Web. HTML uses tags to indicate how Web browsers should display page elements such as text and graphics and how to respond to user actions.) file associated with the data access page has been renamed, moved, or deleted.

Although a data access page is a database object (database objects: An Access database contains objects such as tables, queries, forms, reports, pages, macros, and modules. An Access project contains objects such as forms, reports, pages, macros, and modules.), most of the information about a page is stored in a corresponding HTML file. You specify the name and location of this HTML file the first time you create a data access page. Microsoft Access keeps a shortcut in the Database window (Database window: The window that appears when you open an Access database or an Access project. It displays shortcuts for creating new database objects and opening existing objects.) to the corresponding HTML file's location in your file system. You can see the HTML file's location in the Database window by resting the pointer on the name of the page.

If the HTML file has been renamed or moved, you can restore the HTML file's original name, move the HTML file back to its original location, or change the shortcut maintained by Access to the new name or location. (Click Locate in the message box that appears when Access cannot locate the HTML file.)

Notes

• It's possible to have two or more pages in the same or different Microsoft Access databases (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose.) or Microsoft Access projects (Microsoft Access project: An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects such as tables and views.) pointing to the same HTML file. For example, you might have copied or imported the page. Although you might want to do this, it's a good idea to modify the page in Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.) in only one Access database or Access project at a time to avoid problems with sharing and to avoid possibly losing design changes.

• If the HTML file is deleted, you cannot recover the page unless you can retrieve the HTML file from a backup copy.

You might have the wrong browser settings   Although all browsers support the same language (HTML (HTML: The standard markup language used for documents on the World Wide Web. HTML uses tags to indicate how Web browsers should display page elements such as text and graphics and how to respond to user actions.)), there are some differences among browsers. Some support different versions of HTML and different HTML extensions (HTML extensions: A feature or setting that is an extension to the formal HTML specification. Extensions may not be supported by all Web browsers, but they may be used widely by Web authors. An example of an extension is marquee scrolling text.). Custom options can be set in browsers, such as the default text and background colors, and whether or not graphics are displayed. Consider testing your data access page in different browsers — some of which are available for downloading on the Web — and with different monitor settings, to see if all of your page elements appear.

You might have used the wrong picture format   If you link a graphic to a data access page, and the graphic format isn't supported by your browser, your graphics won't be visible. Make sure that the linked picture is in a graphic format that is compatible with your browser. The JPEG (JPEG: A graphics file format (.jpg extension in Microsoft Windows) supported by many Web browsers that was developed for compressing and storing photographic images. It's best used for graphics with many colors, such as scanned photos.) and GIF (GIF: A graphics file format (.gif extension in Windows) used to display indexed-color graphics on the World Wide Web. It supports up to 256 colors and uses lossless compression, meaning that no image data is lost when the file is compressed.) graphic formats are compatible with most browsers.

If your data access page looks different from what you expect, check the browser settings. Although all Web browsers support the same language (HTML (HTML: The standard markup language used for documents on the World Wide Web. HTML uses tags to indicate how Web browsers should display page elements such as text and graphics and how to respond to user actions.)), there are some differences among browsers. Some support different versions of HTML and different HTML extensions (HTML extensions: A feature or setting that is an extension to the formal HTML specification. Extensions may not be supported by all Web browsers, but they may be used widely by Web authors. An example of an extension is marquee scrolling text.). Custom options can be set in browsers, such as the default text and background colors, and whether or not graphics are displayed. Consider testing your page in different browsers — some of which are available for downloading on the Web — and with different monitor settings, to see whether all of your page elements appear.

Theme graphics are animated only when you view the data access page in a Web browser, not in Microsoft Access.

If a data access page is encoded (encoding: The byte (or sequence of bytes) representing each character in an HTML or plain text file. Unicode encoding supports all characters in all languages and is readable in Microsoft Internet Explorer 4.0 or later and Netscape Navigator 4.0 or later.) for a different language, Microsoft Access tries to determine the language. If Access displays the wrong characters for that language when you open the page in a browser, you can select the language that you think the page is encoded in. Some languages have more than one encoding, so try each encoding until you can read the text.

1. Open the data access page in Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.).

2. On the Tools menu, click Options, and then click the General tab.

3. Click Web Options, and then click the Encoding tab.

4. Under Save this document as, select the language that you think the page is encoded in.

When you save your data access page in Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.), all supporting files — such as bullets, background textures, and graphics — are by default organized in a supporting folder. By default, the name of the supporting folder is the name of the data access page plus an underscore (_), a period (.), or a hyphen (-) and the word "files." The word "files" will appear in the language of the version of Microsoft Office that was used to save the file as a data access page. For example, suppose you use the Dutch language version of Office to save a file called Page1 as a data access page. The default name of the supporting folder would be Page1_bestanden.

 Note   If you save your data access page with a short file name (a maximum of eight characters, plus a three-character file extension) by clearing the Use long file names whenever possible check box in the Web Options dialog box, the supporting folder is the name of the data access page without the word "files."

• You might not have the correct Web browser.

  To view or interact with a data access page, you must have Microsoft Internet Explorer 5.01 with Service Pack 2 (SP2) or later installed on your computer. A page can also contain additional controls, including spreadsheets, PivotTable lists, and charts.

• Another user might have exclusive access to the Microsoft Access database (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose.) or Microsoft SQL Server database (Microsoft SQL Server database: A database in Microsoft SQL Server, it consists of tables, views, indexes, stored procedures, functions, and triggers.) that the page is connected to.

  This situation can occur when a database administrator is maintaining an Access database or SQL Server database and needs to temporarily prevent users from accessing the database, or when someone is designing objects in a shared Access database. Wait a few minutes and try to view the page again, or contact your database administrator.

• The page, or a PivotTable list on the page, is connected to an unsupported OLE DB data source.

  An Access database or Microsoft SQL Server database is the only OLE DB data source you can connect to from a page. Either you or the author of the page needs to change the OLE DB connection to the page. To do so, in Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.), right-click the database icon in the field list (field list: A window that lists all the fields in the underlying record source or database object, except in data access page Design view. In data access page Design view, it lists all the record sources and their fields in the underlying database.), and then click Connection.

In the Open dialog box (File menu), when you select an Hypertext Markup Language (HTML: The standard markup language used for documents on the World Wide Web. HTML uses tags to indicate how Web browsers should display page elements such as text and graphics and how to respond to user actions.) (HTML) file (also called a Web page) and click Open or double-click the file, the file opens in the program that created the file. For example, if you attempt to open an HTML format file that was created in Microsoft Word, the file opens in Word — not in Microsoft Access as a data access page.

To open an HTML file that was created in another Office program as a data access page in Access, right-click the file in the Open dialog box, point to Open with, and then click Microsoft Access on the shortcut menu.

 Note   If the file type that you are trying to open hasn't previously been associated with another program, instead of pointing to the Open with dialog, click the Open with dialog, and select Microsoft Access from the list of programs.

The designer of the data access page removed the buttons for that page or group.

Possible reasons include:

• The data access page you are displaying might be a data-entry form. You can enter your data in the blank fields.

• The data access page contains a drop-down list that determines which records to display. From the drop-down list, select a group whose records you want to see on the page.

There are several kinds of fields that you can't edit in Page view (Page view: An Access window in which you can browse the contents of a data access page. Pages have the same functionality in Page view as in Microsoft Internet Explorer 5.0 or later.). The following fields might display values just as regular fields do, but if you try to enter data into them, nothing happens:

• AutoNumber fields   If a field has an AutoNumber data type in a Microsoft Access database (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose.) or a numeric data type with the Identity property set in a Microsoft Access project (Microsoft Access project: An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects such as tables and views.), Access automatically assigns a number to this field for each record you add. This type of field is often used as a record ID number or primary key (primary key: One or more fields (columns) whose values uniquely identify each record in a table. A primary key cannot allow Null values and must always have a unique index. A primary key is used to relate a table to foreign keys in other tables.). Access automatically fills in the field's value for you.
• Calculated fields   In an Access database, a calculated field (calculated field: A field, defined in a query, that displays the result of an expression rather than displaying stored data. The value is recalculated each time a value in the expression changes.) displays values that Access calculates. They are usually based on other fields in your tables, but calculated fields are not stored in tables.
• Read-only or disabled controls   If a control on a form has the ReadOnly property set to True or the Disabled property set to True, it is locked or disabled for data entry.
• Fields in a locked record   If you use an Access database in a multiuser environment and a record is locked by another user, you can't edit the data in the record until the other user is finished editing the record.
• Fields in a read-only form or a locked database   If the form you're using has the AllowEdits property set to No or if the underlying data is read-only or locked, you can't edit the data.
• Fields in a read-only group level on a data access page   A read-only group level (group level: The depth at which a group in a report or data access page is nested inside other groups. Groups are nested when a set of records is grouped by more than one field, expression, or group record source.) on a page is intended only to display data.
• A read-only PivotTable list   A PivotTable list might be intended only to display data, not to edit data.
• Fields in a table that doesn't support edits   If the underlying table does not have a primary key, or if the UniqueTable property of the corresponding group header section is not set to the name of the table, you can't edit data.

You might be having problems entering dates in a field with the Date/Time data type (Date/Time data type: An Access database data type that is used to hold date and time information.). If you are entering dates by using the slash mark (/) format, don't enter a trailing slash mark. For example, 1/3 is valid, but 1/3/ is not valid.

To view a data access page sent as an e-mail message, the mail recipient must read the e-mail message by using one of the following:

• Microsoft Outlook 2000 or later

• Microsoft Outlook Express 5.0 or later

• The combination of Microsoft Outlook 98 or later and Microsoft Internet Explorer 5.01 with Service Pack 2 (SP2) or later

• The combination of Outlook Express 5.0 or later and Microsoft Internet Explorer 5.01 with Service Pack 2 (SP2) or later

If you are using a corporate intranet, you can publish your pages from a Web site located in a trusted security zone. This will help alleviate problems caused by the recipient's Internet Explorer security settings and thus improve performance of your pages. For more information about security levels and security zones, see Internet Explorer Help. For any specific page security requirements at your site, see your system administrator.

When you try to move out of a field after changing data, Microsoft Access validates the data, making sure that the value (value: The text, date, number, or logical input that completes a condition that a field must meet for searching or filtering. For example, the field Author with the condition equals must include a value, such as John, to be complete.) you entered is allowed in that field. If the value isn't allowed, Access alerts you. In order to move off the field, you must either change the data to an acceptable value or undo your changes.

A value might not be allowed in a field for the following reasons:

• The value isn't compatible with the field's data type. If you enter a value that doesn't match the data type, Access attempts to convert the entry to the correct data type. However, some data can't be converted to other data types. For example, you can't store a name in a field with the Number data type in a Microsoft Access database (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose.) or the smallint data type in a Microsoft Access project (Microsoft Access project: An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects such as tables and views.).
• The data breaks a rule set in the ValidationRule property for the field.
• Data is required in the field, and you've tried to leave it blank.
• The validation macro specified for the BeforeUpdate property canceled the update.

Access also validates data when you move out of a record. Before it saves a record, Access makes sure that your changes don't break any validation rules (validation rule: A property that defines valid input values for a field or record in a table, or a control on a form. Access displays the message specified in the ValidationText property when the rule is violated.) set in the ValidationRule property for the record. Additionally, if the table you are editing has a primary key (primary key: One or more fields (columns) whose values uniquely identify each record in a table. A primary key cannot allow Null values and must always have a unique index. A primary key is used to relate a table to foreign keys in other tables.) or unique index (unique index: An index defined by setting a field's Indexed property to Yes (No Duplicates). A unique index will not allow duplicate entries in the indexed field. Setting a field as the primary key automatically defines the field as unique.), Access makes sure that the record you are editing doesn't have the same value for the fields as another record in the table. If the record can't be saved, you must either make any necessary corrections, or cancel your changes by clicking Undo or pressing ESC.