Flylib.com
List of Try It Outs
Previous page
Table of content
Introduction
Try It Out
Chapter 2: The Basics of Writing and Testing VBA Code
Try it Out-Create a Database to Use with Examples in the Chapter
Try It Out-Creating the VerifyCreditAvail Procedure
Try It Out-Calling VerifyCreditAvail from Another Procedure
Try It Out-Create New Procedure for frmTest Using Code Builder
Try It Out-Creating the CalculateSalesTax Function
Try It Out-Declaring a Public Variable
Try It Out-Creating TestIfStatement Procedure
Try It Out-Create the TestCaseStatement Procedure
Try It Out-Creating a For
…
Next Loop
Try It Out-Setting and Using Breakpoints
Try It Out-Using the Locals Window
Try It Out-Adding a Watch
Try It Out-Creating an Error Handler
Try It Out-Creating a Generic Error Handler
Chapter 3: Programming Applications Using Objects
Try It Out-Using Properties, Methods, and Events
Try It Out-Using the Forms Collection and Form Object
Try It Out-Using the Screen Object
Try It Out-Using the Printers Collection and Printer Object
Chapter 4: Creating Your Own Objects
Try It Out-Creating the Properties for the Car Class
Try It Out-Creating the Methods for the Car Class
Try It Out-Creating an Event for the Car Class
Try It Out-Using the Properties, Methods, and Events of the Car Class
Try It Out-Adding New Property for frmCarDetails Form
Try It Out-Adding New Method for the frmCarDetails Form
Chapter 5: Interacting with Data Using ADO and SQL
Try It Out-Building a Contacts Form Bound to a Recordset
Try It Out-Building an Unbound Contacts Form Using a Disconnected Recordset
Try It Out-Sorting Records for the Unbound Contacts Form
Try It Out-Modify the Unbound Contacts Form to Use SQL
Chapter 6: Building Interactive Forms
Try It Out-Building a Switchboard Form
Try It Out-Populating Combo and List Boxes
Try It Out-Adding Data Validation to the frmPayments Form
Chapter 7: Importing, Linking, and Exporting Using External Data Sources
Try It Out-Importing Data from the Sample Northwind Database
Try It Out-Importing Data from a Text File
Chapter 8: Using Access with Web Services and SharePoint Lists
Try It Out-Adding a Reference to a Web Service
Try It Out-Consuming the GetPlaceFacts Method
Try It Out-Importing Lists Using the Wizard
Try It Out-Programmatically Linking a List Using DoCmd Object
Try It Out-Programmatically Linking a List Using a TableDef Object
Chapter 9: Creating Reports and Web-Enabled Output
Try It Out-Creating a Report Programmatically
Try It Out-Exporting the tblComplaints Table to HTML
Chapter 10: Building SQL Server Applications with Access Projects
Try It Out-Creating an Access Project Using a New SQL Server Database
Try It Out-Creating a New SQL Server Table
Try It Out-Creating a New SQL Server Stored Procedure
Try It Out-Creating a New View
Chapter 11: Advanced Access Programming
Try It Out-Using the Microsoft Office Object Library to Create a Custom Command Bar
Try It Out-Using an External DLL to Get System Information
Try It Out-Controlling an Excel Spreadsheet from Access
Try It Out-Creating Word Letters from Access
Try It Out-Sending an Outlook E-mail from Access
Try It Out-Creating and Using a Code Library
Chapter 12: Finishing the Application
Try It Out-Using the Database Splitter Wizard to Separate Database Tables from the User Interface
Try It Out-Using the Performance Analyzer
Chapter 13: Case Study 1-Project Tracker Application
Try It Out-Building the ProjectTrackerDb Database
Try It Out-Building the frmProjects and frmContacts Forms
Try It Out-Building the clsProjects Class
Try It Out-Building the clsContacts Class
Try It Out-Building the modBusinessLogic and modDatabaseLogic Modules
Try It Out-Writing Code for the frmProjects Form
Try It Out-Writing Code for the frmContacts Form
Chapter 14: Case Study 2-Customer Service Application
Try It Out-Building the CustomerServiceSQL Database
Try It Out-Building the frmSearch and frmCustomers Forms
Try It Out-Building the clsCustomer Class
Try It Out-Building the modBusinessLogic and modDatabaseLogic Modules
Try It Out-Writing Code for the frmSearch
Try It Out-Writing Code for the frmCustomers
Previous page
Table of content
Beginning Access 2007 VBA
ISBN: 0470046848
EAN: 2147483647
Year: 2004
Pages: 143
Authors:
Denise M. Gosnell
BUY ON AMAZON
Interprocess Communications in Linux: The Nooks and Crannies
Real and Effective User and Group IDs
Introduction
Key Terms and Concepts
IPC System Calls: A Synopsis
D.2. Sample Program for Profiling
Software Configuration Management
Configuration Identification
Configuration Change Management
Appendix D Problem Change Report
Appendix E Test Plan
Appendix P Project Statement of Work
SQL Hacks
Hack 2. Connect to SQL from a Program
Hack 10. Convert Subqueries to JOINs
Hack 15. Search for Keywords Without LIKE
Hack 27. Identify Overlapping Ranges
Hack 99. Dont Run Out of Disk Space
Practical Intrusion Analysis: Prevention and Detection for the Twenty-First Century: Prevention and Detection for the Twenty-First Century
IDS and IPS Internals
Incident Response
Laws, Standards, and Organizations
Security Business Issues
The Future of Intrusion Detection and Prevention
Wireless Hacks: Tips & Tools for Building, Extending, and Securing Your Network
Hack 42. Secure Your Linux Network with WPA
Hack 78. Advertise Bonjour Services in Linux
Hack 85. Pringles Can Waveguide
Hack 98. Align Antennas at Long Distances
Section A.6. Bluetooth: Cable Replacement for Devices
VBScript in a Nutshell, 2nd Edition
VBScripts History and Uses
Using the Component
Section A.8. Error Handling
Section C.1. Arithmetic Operators
Section C.2. String Operator
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies