Afrikaans   Arabic   Armenian   Azeri - Latin   Azeri   Bosnian   Catalan   Chinese - Simplified   Chinese - Traditional   Croatian   Czech   Danish   Dutch   English - United States   Farsi   Finnish   French   Gagauz   Georgian   German   Greek   Haitian Creole   Hebrew   Hindi   Hungarian   Indonesian   Italian   Japanese   Kirghiz - Cyrillic   Kirghiz   Klingon   Korean   Macedonian   Malaysian   Norwegian   Polish   Portuguese - Brazilian   Portuguese - Iberian   Romanian   Serbian - Latin   Serbian   Slovak   Spanish   Swedish   Tajik - Cyrillic   Tajik   Tamil   Tatar   Thai   Turkish   Uzbek - Cyrillic   Uzbek - Latin   Vietnamese   Yiddish  

Home




TSI Form/Report to Data Access Page Wizard - Trigeminal Software, Inc. (English)

TSI Form/Report to Data Access Page Wizard
(9.0.5931)

Data Access Pages are a new feature in Access 2000/2002. From the help (in a topic by the name of Data Access Pages: What they are and how they work):

"A data access page is a special type of Web page designed for viewing and working with data from an Internet or intranet data that is stored in a Microsoft Access database or a Microsoft SQL Server database. The data access page may also include data from other sources, such as Microsoft Excel."

Some of the hardest things to overcome (aside from licensing issues) in trying to learn and use Data Access Pages are that you must

  • learn an entirely new designer for Pages that only superficially matches the designer for forms and reports, and which many people are having a lot of difficulty using without the familiar features like Undo, Multi-Select, etc.
  • get used to the Microsoft Script Editor (MSE) instead of the Visual Basic Environment (VBE)
  • pick up an entirely new set of intrinsic controls with different properties, methods, and events than those of Access forms and reports.
  • start using VBScript or JavaScript behind the pages instead of the VBA behind forms and reports
Perhaps most difficult is that you cannot leverage any of your existing knowledge of forms and reports in the above list of things to do; heck, you can't even leverage all of the existing forms and reports you have already!

Luckily, senior Trigeminal Software, Inc. developer Julianne Lee and I * have created the TSI Form/Report to Data Access Page Wizard, which converts existing forms and reports in an Access 2000/2002 database to Data Access Pages. It will preserve as much of the layout and formatting as it can, and it will insert the code in the form/report event procedures behind the DAP (commented out), to help you move on to the step of converting that code to VBScript (resources with examples are contained in the readme file).

This wizard is localized into every language into which Access itself is localized, by using the Office UI Language for your Access installation. Those languages are:

  • Afrikaans (1078)
  • Arabic (1025)
  • Armenian (1067)
  • Azeri - Latin (1068)
  • Azeri (2092)
  • Basque (1069)
  • Bosnian (4122)
  • Bulgarian (1026)
  • Byelorussian (1059)
  • Catalan (1027)
  • Chinese - Simplified (2052)
  • Chinese - Traditional (1028)
  • Croatian (1050)
  • Czech (1029)
  • Danish (1030)
  • Dutch (1043)
  • English - United States (1033)
  • Estonian (1061)
  • Farsi (1065)
  • Finnish (1035)
  • French - Canada (3084)
  • French (1036)
  • Gagauz (32799)
  • Georgian (1079)
  • German (1031)
  • Greek (1032)
  • Haitian Creole (15372)
  • Hebrew (1037)
  • Hindi (1081)
  • Hungarian (1038)
  • Indonesian (1057)
  • Italian (1040)
  • Japanese (1041)
  • Kirghiz - Cyrillic (32832)
  • Kirghiz (1088)
  • Klingon (1554)
  • Korean (1042)
  • Latvian (1062)
  • Lithuanian (1063)
  • Macedonian (1071)
  • Malaysian (1086)
  • Norwegian (1044)
  • Polish (1045)
  • Portuguese - Brazilian (1046)
  • Portuguese - Iberian (2070)
  • Romanian (1048)
  • Russian (1049)
  • Serbian - Latin (2074)
  • Serbian (3098)
  • Slovak (1051)
  • Slovenian (1060)
  • Spanish (3082)
  • Swedish (1053)
  • Tagalog (1124)
  • Tajik - Cyrillic (32808)
  • Tajik (1064)
  • Tamil (1097)
  • Tatar (1092)
  • Thai (1054)
  • Turkish (1055)
  • Ukrainian (1058)
  • Uzbek - Cyrillic (2115)
  • Uzbek - Latin (1091)
  • Vietnamese (1066)
  • Yiddish (1085)

To download, simply follow this link to frmrpt2dap.zip. Once you have the zip file on your local machine, the frmrpt2dap_readme.asp file enclosed within it will detail how to install the add-in and let you know all the nuances of what it does (like how tab control support works!)

Send all bugs, questions, suggestions, complaints, and comments to frmrpt2dap@trigeminal.com.


Michael Kaplan
Julianne Lee

Trigeminal Software, Inc.


*In the strict interests of accuracy, it must be admitted that it's mostly Julianne's hard work in this wizard; Michael just did the international support, about 30% of the tab control work, and a few other odds and ends.





P.S. For additional (consulting) help with Data Access Pages in Access 2000/2002 (especially related to manipulating the TriEdit or Office Web Components object models either at design time in Access/VBA or runtime from VBScript behind the page) send mail to dataaccesspages@trigeminal.com with a description of what kind of help you are looking for.


Home


Last Updated  04/22/07 10:28 PM

Problems with this site? Please contact the webmaster@trigeminal.com
with your comments, questions, or suggestions.