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

Chapter 25. Converting Access Objects to... > In the Real World—Enhancing Data Acc...

In the Real World—Enhancing Data Access Page Design

Much of the content of this chapter concentrates on the lack of support by DAP for common Access form and report designs and control objects. Observations about Save As DAP features that work as expected might be classified as damnation by faint praise. There are workarounds for unsupported objects—such as subforms and subreports—but most workarounds aren’t elegant, require VBScript programming expertise, and often need additional HTML code. In most cases, what you see in Access isn’t what you get in pages without a considerable amount of work on your part. Bear in mind, however, that creating a datasheet-style data entry Web page, for example, isn’t a piece of cake in any authoring tool. This is especially true if you need to implement the equivalent of the Undo, Sort..., and Filter... buttons of the navigation control.

Third-party Access developers have the opportunity to improve on the basic functionality of the Save as DAP feature. For example, Michael Kaplan and Julianne Lee of Trigeminal Software, Inc. (TSI) developed a Form/Report to Data Access Page Wizard that overcomes many Save As DAP limitations. For example, the TSI Wizard handles most subforms and subreports, which open in an inline frame (<IFRAME>), and generates working drop-down lists (see Figure 25.31). The TSI Wizard is an Access add-in library (FrmRpt2Dap.mde) that you can download from http://www.trigeminal.com/frmrpt2dap.asp. Installation instructions are at http://www.trigeminal.com/frmrpt2dap_readme.asp. Data25.mdb in the \Seua11\Chaptr25 folder of the accompanying CD-ROM includes the Orders and Orders Subform pages generated by the TSI Wizard. The pages have minor design modifications, and the VBScript in the Orders.htm page has been altered to enable opening the subform directly from the Orders Subform.htm file.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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