Waite Group's Visual Basic 6 Database How-To

Jason T. Roff, Waite Group Press

ISBN:1571691529, Edition: , 1998-08

Price: $39.99

Table of Contents:

• Introduction
  
  
• Chapter 1: - Accessing a Database with Bound Controls
  How do I...
  • 1.1 Browse a recordset using bound controls?
  • 1.2 Validate data entered into bound controls?
  • 1.3 Allow users to undo changes they've made in bound controls?
  • 1.4 Add and delete records using bound controls?
  • 1.5 Create and use bound lists?
  • 1.6 Display many detail records for a single master record?
  • 1.7 Change data in data-bound grid cells from code?
  • 1.8 Gracefully handle database errors?
• Chapter 2: - Accessing a Database with Data Access Objects
  How do I...
  • 2.1 Browse and update a recordset with Data Access Objects?
  • 2.2 Validate data entered into Data Access Objects?
  • 2.3 Allow users to undo changes they've made in Data Access Objects?
  • 2.4 Add and delete records by using Data Access Objects?
  • 2.5 Use unbound controls to update fields in Data Access Objects?
  • 2.6 Find records by using index values in Data Access Objects?
  • 2.7 Determine how many records are in a dynaset- or snapshot-type recordset?
  • 2.8 Handle Data Access Object errors?
  • 2.9 Access Excel worksheets by using Data Access Objects?
• Chapter 3: - Creating Queries with SQL
  How Do I...
  • 3.1 Create recordsets by selecting records from single tables?
  • 3.2 Select unique field values in a SQL query?
  • 3.3 Use variables and Visual Basic functions in a SQL query?
  • 3.4 Use wildcards and ranges of values in a SQL query?
  • 3.5 Define and use a parameter query?
  • 3.6 Create recordsets by joining fields from multiple tables?
  • 3.7 Find records in a table without corresponding entries in a related table?
  • 3.8 Retrieve information such as counts, averages, and sums and display it by binding it to a Data control?
  • 3.9 Create a recordset consisting of records with duplicate values?
  • 3.10 Use Visual Basic functions within a SQL statement?
  • 3.11 Make bulk updates to database records?
  • 3.12 Create and delete tables?
  • 3.13 Append and delete records?
  • 3.14 Create a new table with data from existing tables?
  • 3.15 Modify a table's structure?
  • 3.16 Create a crosstab query?
• Chapter 4: - Designing and Implementing a Database
  How Do I...
  • Create a new database?
  • Define tables and fields?
  • Define the primary key and other indexes?
  • Define relations between tables?
  • Use the Jet database engine ...
• Chapter 5: - Microsoft Access Database
  How do I...
  • 5.1 Determine the number of records in a table and the table's creation and last-modified dates?
  • 5.2 Attach a table from another database file?
  • 5.3 Import a text file?
  • 5.4 Save graphics in a database file?
  • 5.5 Make sure that an operation involving multiple tables is not left partially completed?
  • 5.6 Compact a database or repair a corrupted database?
  • 5.7 Use parameter queries stored in Microsoft Access databases?
• Chapter 6: - Connecting to an ODBC Server
  How do I...
  • 6.1 Use the ODBC Administrator to maintain data sources?
  • 6.2 Use ODBC with the Visual Basic Data control?
  • 6.3 Create an ODBC-accessible data source by using RegisterDatabase?
  • 6.4 Prevent the login dialog box from being displayed when I open an ODBC database?
  • 6.5 Determine what services an ODBC server provides?
  • 6.6 Use ODBCDirect to connect to database servers?
• Chapter 7: - SQL Server Databases and Remote Data Objects
  
  • How do I...
  • 7.1 Browse a SQL Server database by using the RemoteData control?
  • 7.2 Add and delete records in a SQL Server database by using the RemoteData control?
  • 7.3 Connect to a SQL Server database by using Remote Data Objects?
  • 7.4 Browse records in a SQL Server database by using Remote Data Objects?
  • 7.5 Add, update, and delete records in a SQL Server database by using Remote Data Objects?
  • 7.6 Execute a SQL Server stored procedure by using Remote Data Objects?
  • 7.7 Execute a parameterized SQL Server stored procedure with Remote Data Objects?
  • 7.8 Handle Remote Data Objects errors?
• Chapter 8: - Using ActiveX Data Objects
  How Do I...
  • 8.1 Browse a SQL Server database with the ADO Data control?
  • 8.2 Create and delete records in a SQL Server database using the ADO Data control?
  • 8.3 Retrieve results from a SQL Server using ActiveX Data Objects?
  • 8.4 Alter data using ActiveX Data Objects?
  • 8.5 Perform a transaction using ActiveX Data Objects?
  • 8.6 Execute a SQL Server stored procedure using ActiveX Data Objects?
  • 8.7 Execute a parameterized SQL Server stored procedure with ActiveX Data Objects?
  • 8.8 Create and modify SQL Server objects with ActiveX Data Objects?
  • 8.9 Execute batch updates with ActiveX Data Objects?
  • 8.10 Make remote updates to data with ActiveX Data Objects?
  • 8.11 Build a middle-tier business object using ActiveX Data Objects?
  • 8.12 Incorporate a business object into Microsoft Transaction Server?
  • 8.13 Handle ActiveX Data Objects errors?
• Chapter 9: - Microsoft Data Report
  How do I...
  • 9.1 Create a report using Microsoft Data Report Designer?
  • 9.2 Add Calculated Fields to a Microsoft Data Report?
  • 9.3 Select if the Microsoft Data Report will be displayed, printed, or exported using Visual Basic code?
  • 9.4 Display a report based on criteria I choose using a Microsoft Data Report?
  • 9.5 Determine which records will be printed using Crystal Reports?
  • 9.6 Create subtotals and other calculated fields using Crystal Reports?
  • 9.7 Control the order in which records will be printed using Crystal Reports?
  • 9.8 Print labels using Crystal Reports?
  • 9.9 Create and print form letters with Crystal Reports?
  • 9.10 Print field data without extra spaces between the fields with Crystal Reports?
  • 9.11 Prevent blank lines from being printed when a field contains no data using Crystal Reports?
  • 9.12 Create cross-tab reports with Crystal Reports?
  • 9.13 Generate reports using user-entered variables with Crystal Reports?
• Chapter 10: - Security and Multiuser Access
  How do I...
  • 10.1 Open a database so that others can't access it while the user is working with it?
  • 10.2 Open a table so that others can't access it while the user is working with it?
  • 10.3 Work with locked records?
  • 10.4 Work with secured Microsoft Access database files?
  • 10.5 Assign permissions for database objects?
  • 10.6 Change ownership of database objects?
  • 10.7 Change or delete database passwords?
  • 10.8 Use a single password for data access for all users?
  • 10.9 Add new users to a system database?
  • 10.10 Define new groups in a system database?
  • 10.11 Add users to groups and delete users from groups?
  • 10.12 Track user activity in a database?
  • 10.13 Create and use an encrypted database?
• Chapter 11: - The Windows Registry and State Information
  How do I...
  • 11.1 Enter and retrieve Windows Registry entries from Visual Basic?
  • 11.2 Put data access-related information into an application's section of the Registry?
  • 11.3 Determine which database and report-related files need to be distributed with my applications?
  • 11.4 Tune the Jet database engine through Windows Registry entries?
  • 11.5 Tune the ODBC engine using Windows Registry entries?
• Chapter 12: - ActiveX and Automation
  How do I...
  • 12.1 Use ActiveX Automation to edit pictures, documents, and spreadsheets embedded in an application's database?
  • 12.2 Provide access to database files through a private class module?
  • 12.3 Publish my ActiveX private class so that others can use it?
  • 12.4 Provide controlled access to an encrypted, password-protected database using an ActiveX EXE server?
  • 12.5 Use Microsoft Access as an ActiveX server to print reports from Visual Basic?
  • 12.6 Use Microsoft Access queries containing user-defined functions from Visual Basic?
  • 12.7 Convert database data to a spreadsheet form that can be used to edit and analyze data?
  • 12.8 Include an editable report writer in a Visual Basic application?
  • 12.9 Work with the Windows Registry for my ActiveX classes?
  • 12.10 Create my own custom data control?
  • 12.11 Create my own data bound control?
  • 12.12 Use the DataRepeater control with custom Data Bound controls?
• ActiveX Overview
  • COM Has Its Roots in OOP
  • ActiveX and Visual Basic 6
  • Building and Using Code Components
• Chapter 13: - Advanced Database Techniques
  How do I...
  • 13.1 Search for database records by using a Soundex algorithm?
  • 13.2 Back up selected database objects at a set schedule?
  • 13.3 Replicate a database by using the Jet engine?
  • 13.4 Omit specified objects from replicas?
  • 13.5 Create a nonreplicated version of a replicated database?
  
  
• Appendix A: - SQL Reference
  • SQL Statement Classifications
  • Data Definition Language
    • The CREATE Command
    • The ALTER Command
    • Using the CONSTRAINT Clause
    • The DROP Command
  • Data Manipulation Language
    • The SELECT Command
    • Joins
    • The INSERT Command
    • The UPDATE Command
    • The DELETE Command
    • Comments
• Appendix B: - Data Access Object Reference
  • Containers Collection, Container Object
  • Databases Collection, Database Object
  • Documents Collection, Document Object
  • DBEngine Object
  • Errors Collection, Error Object
  • Fields Collection, Field Object
  • Groups Collection, Group Object
  • Parameters Collection, Parameter Object
  • Recordsets Collection, Recordset Object
  • TableDefs Collection, TableDef Object
  • Workspaces Collection, Workspace Object
  • Users Collection, User Object
• Appendix C: - Remote Data Object Reference
  • rdoColumns Collection, rdoColumn Object
  • rdoConnections Collection, rdoConnection Object
  • rdoEngine Object
  • rdoEnvironments Collection, rdoEnvironment Object
  • rdoErrors Collection, rdoError Object
  • rdoParameters Collection, rdoParameter Object
  • rdoQueries Collection, rdoQuery Object
  • rdoResultsets Collection, rdoResultset Object
  • rdoTables Collection, rdoTable Object
• Appendix D: - ActiveX Data Objects Reference
  • Command Object
  • Connection Object
  • Errors Collection, Error Object
  • Fields Collection, Field Object
  • Parameters Collection, Parameter Object
  • Properties Collection, Property Object
  • Recordset Object
• Appendix E: - A Short Introduction to Visual Basic Objects
  • Object Overview
  • Your Own Object
  • Collections of Objects
    • Adding an Item to a Collection Object
    • Removing an Item from a Collection Object
    • Accessing Items in a Collection Object