Share this Page URL
Help

Index > Index - Pg. 698

Index Do While...Loop statement, 161 enabling and disabling warning messages, 323 error handling, 137, 159, 164, 167, 172, 191 events and, 23 filtering reports, 354 For Each...Next statement, 160 For...Next statement, 160 handling unexpected behavior in forms, 298 If...Then...Else statement, 158 keywords, 149 line continuation character and string concatenation, 144 macros vs., 137, 458 (see also macros) Microsoft Office XP Web Components library, 406 object models, 178 (see also object models) Office Automation and, 187 (see also Office Automation) online help, 166 projects, 150, 620 running action queries, 320 running functions from macros, 478 running functions from toolbars, 481 running queries, 219 Scripting Edition (VBScript), 579 Select Case statement, 159 setting up Visual Basic Editor, 164 (see also Visual Basic Editor) standard and class modules, 145 switching between PivotCharts and PivotTables with, 404 table names and SQL statements, 310 turning controls on and off, 295 variables, 147 (see also variables, Visual Basic) Visual Basic for Applications library, 141 While...Wend statement, 163 With...End With statement, 163 writing code in Access projects, 534 Visual Basic .NET Step by Step, 190 Visual Basic Editor Code window, 145 debugging tools (see debugging tools, Visual Basic) Immediate window, 146, 157 macros and, 139 (see also macros) opening, 147 Options Explicit setting, 154 Properties window, 179 setting up, 164 switching between Access and, 143 writing code for button Click events, 23 Visual FoxPro, 109 698 SharePoint Team sites, 538 split databases and, 45 Web Components (see Office Web Components) World Wide Web Consortium (W3C), 545, 566, 574 Web pages, 412 creating data access pages from, 420 (see also data access pages) exporting data as HTML, 413 (see also HTML (HyperText Markup Language)) Weekday function, 215 WHERE clause, 312, 313, 316, 590 Where keyword, 217, 220 While...Wend statement, 163 width report, 351 report field, 340 Width property, 256 windows tiling, horizontally, 48 Visual Basic Editor, 166 Windows accounts, 501 Briefcase feature and replication, 637 Help And Support feature, 637 security for data access pages, 439 SharePoint Services (see SharePoint Services) Windows NT Authentication, 501 Windows XP Backup Utility, 617 WITH clause, 325 With...End With statement, 163, 180 Word, 584 Workbook object, 598 Workbooks collection, 598 Workgroup Administrator utility, 649 Workgroup Information File (WIF), 647 Workgroup Owner Information dialog box, 649 workgroups, 650 (see also SharePoint Services) Works, 135 Worksheet object, 598 Worksheets collection, 598 World Wide Web Consortium (W3C), 545, 566, 574 X XML (Extensible Markup Language), 564 applying transformations when importing, 570 constraining data by defining data types with XSD files, 565 creating XML documents with Notepad, 570 exporting forms as, 581 exporting tables as, 567 exporting XML documents with embedded XSD files, 575 HTML vs., 564, 566 importing XML documents, 109, 569 InfoPath and, 562 (see also InfoPath forms) presenting XML data with HTML and XSL stylesheets, 578 string display with CDATA constructs, 568 tags and parsers, 564 XSD (XML Schema Definition) files creating, by exporting, 568 defining data types with, 566 exporting XML documents with embedded, 575 importing XML documents with, 573 W warning messages, action query, 323 watches, Visual Basic, 172, 178 weak passwords, 662 Web browsers, 412, 419 (see also Internet Explorer) data access pages (see data access pages) online help (see online help) pages (see Web pages) SharePoint Services and Web Parts, 537