Home Page Icon
Home Page
Table of Contents for
Index
Close
Index
by F. Scott Barker
F. Scott Barker's Microsoft® Access 2000 Power Programming
Copyright
About the Author
Acknowledgments
Tell Us What You Think!
INTRODUCTION
THE ROOT OF POWER PROGRAMMING
MACROS ARE FOR WEENIES; CODE IS COOL!
UNDERSTANDING WHERE MACROS END AND CODE BEGINS
LOOKING AT MACRO-TO-CODE CHANGES
CONVERTING EXISTING MACROS TO VBA CODE
SUMMARY
CODING IN ACCESS 2000 WITH VBA
GETTING STARTED WITH PROGRAMMING
GETTING STARTED WITH VBA
PROGRAMMING WITH OBJECTS
USING PROPERTIES AND METHODS
USING COLLECTIONS
CUSTOMIZING A FORM
CODING CLASS MODULES
SUMMARY
MAKING THE CHOICE: MDB OR ADP, DAO OR ADO
USING MICROSOFT DATABASE VERSUS ACCESS DATABASE PROJECT
USING DATA ACCESS OBJECTS VERSUS ACTIVEX DATA OBJECTS
SUMMARY
LOOKING AT THE ACCESS COLLECTIONS
CREATING CUSTOM COLLECTIONS
COMPARING CUSTOM COLLECTIONS TO ARRAYS
ACCESSING THE ACCESS OBJECT MODEL
PROGRAMMING MULTIPLE COPIES OF THE SAME FORM
SUMMARY
WORKING WITH DATA ACCESS OBJECTS
UNDERSTANDING DATA ACCESS OBJECTS
CREATING A DATABASE WITH DAO
INCREASING SPEED WITH TRANSACTIONS
USING CUSTOM PROPERTIES
SUMMARY
INTRODUCING ACTIVEX DATA OBJECTS
LOOKING AT THE OBJECT MODELS
REFERENCING THE TYPE LIBRARIES
OPENING A CONNECTION TO A DATABASE
CREATING A RECORDSET WITH ADO
WORKING WITH QUERIES USING ADO
WORKING WITH TABLES USING ADO
SUMMARY
HANDLING YOUR ERRORS IN ACCESS WITH VBA
ACCESS ERROR MESSAGING
DIFFERENT WAYS OF USING ERROR HANDLING
EXAMINING ACCESS'S RUNTIME ERROR HANDLING
WORKING WITH THE ERR AND ERROR OBJECTS
WORKING WITH THE ERRORS COLLECTION
CREATING USER-DEFINED ERRORS
TRACKING ERRORS BY USING A CUSTOM ERROR LOG
CREATING A CENTRALIZED ERROR-HANDLING ROUTINE
A LAST LOOK AT ERROR-HANDLING ISSUES
SUMMARY
MANIPULATING AND PRESENTING DATA
USING QUERIES TO GET THE MOST OUT OF YOUR DATA
UNDERSTANDING WHERE QUERIES ARE USED IN ACCESS
USING SELECT QUERIES: POWER IN THE QUERY DESIGN GRID
WORKING WITH ACTION QUERIES: FOUNDATIONS FOR POWER
USING ADVANCED QUERY OPERATIONS
ADDING MORE POWER WITH VBA
WORKING WITH QUERIES TO FEED REPORTS AND FORMS
SOLVING PROBLEMS WITH QUERIES
EXAMINING THE ARCHITECTURE OF THE QUERY RESOLUTION PROCESS
DISCOVERING JET OPTIMIZATION METHODS
UNDERSTANDING OPTIMIZATION TECHNIQUES
USING UNCONVENTIONAL OPTIMIZATION TECHNIQUES
USING THE ANALYZER WIZARDS
SUMMARY
CREATING POWERFUL FORMS
INCREASING THE PERFORMANCE OF YOUR FORMS
USING ACCESS 2000'S NEW FORM FEATURES
TAKING ADVANTAGE OF OTHER FORM FEATURES
REUSING FORMS TO PERFORM STANDARD TASKS WITH THE OPENARGS AND TAG PROPERTIES
INCREASING TABBED FORM PERFORMANCE
SUMMARY
EXPANDING THE POWER OF YOUR FORMS WITH CONTROLS
SETTING UP A FIELD'S LOOKUP PROPERTIES FOR USE ON FORMS
TAPPING INTO THE POWER OF COMBO BOXES
WORKING WITH THE NATIVE ACCESS TAB CONTROL
MORPHING ACCESS CONTROLS
PROGRAMMING FOR POWER WITH MULTISELECT LISTBOX CONTROLS
USING THE SUBFORM/SUBREPORT WIZARD FOR RELIEF
GIVING SPREADSHEET-TYPE CURSOR MOVEMENTS TO CONTROLS
MANIPULATING CONTROLS THROUGH CODE
SUMMARY
CREATING POWERFUL REPORTS
USING THE SAME REPORT FOR SUMMARY, DETAIL, AND SUMMARY/DETAIL REPORTS
USING QUERY BY FORM TO CREATE DYNAMIC GROUPINGS FOR THE SAME REPORT
THE ELUSIVE FEATURE: CREATING SNAKING REPORTS
USING DYNAMIC COLUMNS TO CREATE A REPORT OFF A CROSSTAB QUERY
CHOOSING MULTIPLE TOPICS TO PRINT BY USING THE MULTISELECT LIST BOX
CREATING A WIZARD-LIKE INTERFACE FOR SELECTING GROUP-BY ITEMS
FORMATTING REPORTS DYNAMICALLY
SUMMARY
WORKING WITH DATA PAGES
WHY DATA ACCESS PAGES?
SAVING TIME WITH THE DATA ACCESS PAGE WIZARDS
CREATING AND ENHANCING SIMPLE DATA ACCESS PAGES
GROUPING DATA ACCESS PAGES: REPORTS FOR THE WEB
FINDING ADDITIONAL RESOURCES
SUMMARY
EXTENDING ACCESS WITH INTEROPERABILITY
DRIVING OFFICE APPLICATIONS WITH AUTOMATION AND DDE
UNDERSTANDING AUTOMATION
EXAMINING THE OFFICE PRODUCTS' OBJECT MODELS
USING AUTOMATION
RUNNING OTHER APPLICATIONS FROM ACCESS WITH AUTOMATION
USING AUTOMATION TO DRIVE ACCESS FROM MICROSOFT PROJECT
USING AUTOMATION TO DRIVE OUTLOOK FROM ACCESS
DRIVING OTHER APPLICATIONS WITH DDE
SUMMARY
PROGRAMMING FOR POWER WITH ACTIVEX CONTROLS
UNDERSTANDING THE ACTIVEX WINDOWS COMMON CONTROLS
TAKING A CLOSER LOOK AT THE IMAGELIST CONTROL
EMULATING THE WINDOWS 95 EXPLORER WITH THE LISTVIEW CONTROL
DISPLAYING A TASK'S PROGRESS WITH THE PROGRESSBAR CONTROL
SIZING TEXT BOXES AT RUNTIME WITH THE SLIDER CONTROL
TELLING IT LIKE IT IS WITH THE MICROSOFT RICH TEXTBOX CONTROL
CREATING STATUS BARS FOR INDIVIDUAL FORMS WITH THE STATUSBAR CONTROL
Setting Status Bar Properties at Runtime
DOCKING TOOLBARS ON FORMS USING THE TOOLBAR CONTROL
VIEWING DATA FILE MANAGER STYLE WITH THE TREEVIEW CONTROL
SUMMARY
USING API CALLS TO EXTEND THE POWER OF ACCESS
UNDERSTANDING DYNAMIC LINK LIBRARIES
EXAMINING THE SYNTAX FOR API CALLS
FINDING API DECLARATIONS
VIEWING THE POSSIBLE API CALLS
CONSIDERING SOME ISSUES WHEN USING API CALLS
LOOKING AT SOME EXAMPLES OF API CALLS
DISPLAYING PERTINENT FOLDERS FROM WITHIN YOUR APPLICATION
USING THE OPEN FILE DIALOG API CALL
SUMMARY
EXTENDING YOUR VBA LIBRARY POWER WITH CLASS MODULES AND COLLECTIONS
LOOKING AT THE FIRST SCENARIO
MANAGING MULTIPLE INSTANCES OF THE SAME FORM
SUMMARY
CREATING YOUR OWN WIZARDS AND ADD-INS
UNDERSTANDING ACCESS WIZARDS, BUILDERS, AND ADD-INS
LOOKING AT THE WIZARDS AND ADD-IN REGISTRY ENTRIES
CREATING YOUR OWN ADD-INS
USING ACCESS CODE LIBRARIES
SUMMARY
MANIPULATING THE REGISTRY WITH VBA
LOOKING AT THE HISTORY OF THE WINDOW'S REGISTRY
USING VBA'S REGISTRY COMMANDS
PERFORMING TASKS WITH THE REGISTRY API CALLS
SUMMARY
USING ACCESS WITH THE INTERNET
LOOKING AT ACCESS'S HYPERLINK FEATURES
LOOKING AT ACCESS'S HYPERLINK OPTIONS
IMPORTING AND EXPORTING ACCESS OBJECTS TO HTML DOCUMENTS THE EASY WAY
PUBLISHING TO OTHER WEB FILE FORMATS
SUMMARY
ADDING THE PROFESSIONAL LOOK AND DISTRIBUTING APPLICATIONS
PROGRAMMING OFFICE COMMAND BARS AND THE OFFICE ASSISTANT
USING COMMAND BARS
WORKING WITH COMMAND BARS THROUGH VBA
WORKING WITH THE OFFICE ASSISTANT
LOOKING AT THE FILESEARCH OBJECT
SUMMARY
SECURING YOUR APPLICATION
UNDERSTANDING THE PURPOSE OF SECURING YOUR APPLICATION
UNDERSTANDING SECURITY IN ACCESS 2000
LOOKING AT THE SECURITY USER INTERFACE
USING TOOLS TO MAKE LIFE WITH ACCESS SECURITY EASIER
AVOIDING COMMON PITFALLS FOUND IN ACCESS SECURITY
MANAGING SECURITY THROUGH CODE
USING THE SECURED SAMPLE DATABASE: CHAP21S.MDB
SUMMARY
MANAGING DATABASES
HANDLING MULTIUSER SITUATIONS
LOOKING AT MULTIUSER TERMINOLOGY
UNDERSTANDING ACCESS MULTIUSER HANDLING
ONE OR TWO DATABASE CONTAINERS: KNOWING WHERE TO PUT THE PIECES
LOOKING AT THE BUILT-IN LOCKING MODES
WORKING IN VBA WITH UNBOUND FORMS
CODING FOR MULTIUSER ERROR HANDLING
GETTING A LIST OF LOGGED-IN USERS WITH ADO
SUMMARY
WELCOME TO THE WORLD OF DATABASE REPLICATION
UNDERSTANDING DATABASE REPLICATION CONCEPTS
UNDERSTANDING THE JET REPLICATION TOOLS
CONVERTING A DATABASE TO A REPLICA
SYNCHRONIZING REPLICAS
UNDERSTANDING REPLICA SET TOPOLOGIES
AUTOMATING STAR AND HUB SYNCHRONIZATION
DISTRIBUTING REPLICABLE APPLICATIONS
REPLICATING BACK-END AND FRONT-END APPLICATIONS
DEALING WITH REPLICATION CONFLICTS
UNDERSTANDING REPLICATION SYNCHRONIZERS
UPGRADING REPLICA SETS FROM ACCESS 97 TO ACCESS 2000
SECURING REPLICATED APPLICATIONS
USING MDE FILES WITH REPLICATED DATABASES
CREATING SUCCESSFUL REPLICATION APPLICATIONS
SUMMARY
MOVING WORKGROUP APPLICATIONS TO CLIENT/SERVER
UNDERSTANDING CLIENT/SERVER
FACTORING FOR MIGRATION TO CLIENT/SERVER
PLANNING FOR CLIENT/SERVER
KNOWING WHAT TO WATCH FOR IN APPLICATION DEVELOPMENT
CONVERTING EXISTING APPLICATIONS
DISTRIBUTING A CLIENT/SERVER SOLUTION
KEEPING CERTAIN ISSUES IN MIND WITH ACCESS AND SQL SERVER
SUMMARY
DEVELOPING SQL SERVER PROJECTS USING ADPS
PROJECT FILE ARCHITECTURE
WORKING WITH PROJECTS
BUILDING A CLIENT/SERVER APPLICATION
WORKING WITH VIEWS
WORKING WITH STORED PROCEDURES
SUMMARY
ADDING FINISHING TOUCHES
STARTUP CHECKING SYSTEM ROUTINES USING DAO
PERFORMING STARTUP SYSTEM CHECKS
USING CUSTOM DATABASE PROPERTIES
NOTIFYING AND LOGGING USERS OUT OF AN APPLICATION
TESTING THE CONNECTIONS OF LINKED TABLES AT STARTUP
LINKING AND UNLINKING TABLES THROUGH VBA
TESTING AND REPAIRING CORRUPTED JET BACK-END DATABASES
CHECKING AND NOTIFYING USERS OF A NEW VERSION
SUMMARY
STARTUP CHECKING SYSTEM ROUTINES USING ADO
PERFORMING STARTUP SYSTEM CHECKS
SETTING AND RETRIEVING SYSTEM SETTINGS WITH ADO
TESTING THE CONNECTIONS OF LINKED TABLES AT STARTUP
LINKING TABLES THROUGH VBA AND ADO
TESTING AND REPAIRING CORRUPTED JET BACK-END DATABASES
REPLICATING CODE TABLES USING ADO
SUMMARY
CREATING MAINTENANCE ROUTINES
CREATING AN EXPORT DIALOG TO EXPORT AN APPLICATION'S TABLES
COMPACTING AND REPAIRING THE BACK END ON DEMAND
CREATING A GENERIC CODE TABLE EDITOR
REPLICATING TABLES FROM BACK END TO FRONT END FOR BETTER PERFORMANCE
SUMMARY
APPENDIXES
DEBUGGING CODE IN ACCESS 2000
SETTING THE CORRECT MODULE OPTIONS FOR MAXIMUM DEBUGGING POWER
TAKING ADVANTAGE OF THE IMMEDIATE WINDOW
STOPPING PROGRAM EXECUTION
DEBUGGING ONE STEP AT A TIME
VIEWING THE ORDER OF PROCEDURE CALLS
WATCHING EXPRESSIONS DURING PROGRAM EXECUTION
CONTROLLING CODE WITH CONDITIONAL COMPILATION COMMANDS
SUMMARY
GETTING STARTED WITH ACTIVEX CONTROLS
WORKING WITH ACTIVEX CONTROLS
COUNTING THE DAYS WITH THE CALENDAR CONTROL
USING A STANDARD INTERFACE WITH THE COMMON DIALOG ACTIVEX CONTROL
SUMMARY
ACCESS 2000 AND JET 4 ERRORS
LESZYNSKI NAMING CONVENTIONS FOR MICROSOFT ACCESS®
NAMING CONVENTIONS: A PRIMER
ACCESS OBJECT TYPES
STRUCTURING OBJECT NAMES
CREATING DATABASE OBJECT BASE NAMES
NAMING CONVENTIONS FOR DATABASE OBJECTS
CREATING VBA OBJECT BASE NAMES
NAMING CONVENTIONS FOR VBA OBJECTS
CREATING YOUR OWN TAGS
VBA CODING CONVENTIONS
STANDARDIZED ABBREVIATIONS
STANDARDIZED TERMINOLOGY
ADDITIONAL INFORMATION ABOUT LNC
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
ADDITIONAL INFORMATION ABOUT LNC
Index
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset