• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 25. Converting Access Objects to... > Saving Tables as Data Entry Pages

Saving Tables as Data Entry Pages

Saving a table as a page is the simplest Save As DAP operation. For example, do the following to save the Suppliers table as a Suppliers.htm page:

1.
In the Tables page of Northwind.mdb’s Database window, right-click the Suppliers table and choose Save As to open the Save As dialog.

2.
Change Copy of Suppliers to Suppliers, and select Data Access Page (see Figure 25.1). Click OK to open the New Data Access Page dialog.

Figure 25.1. Name the page for the table, and choose Data Access Page in the Save As dialog.


3.
Accept Suppliers.htm as the file name, and click OK to create the file in the current folder.

4.
After a second or two, the Suppliers page opens in Page view with a caption, data-entry, standard page navigation section (see Figure 25.2).

Figure 25.2. Page view of a table saved as a page is a reasonably close rendition of datasheet view, considering the limitations of HTML. The Suppliers datasheet uses default formatting, which displays a plain-vanilla page.


Opening HTML elements;table cell values> a page in IE 6+ or Page view generates an ADO Recordset object of the updateable snapshot type over the entire table. Specially formatted text boxes (HTML <TEXTAREA> elements) contain cell values of the table.

Following are the default display and editing characteristics of a table saved as a page:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint