Access 2003 Programming By Example With Vba, Xml, And Asp

by Korol, Julitta

ISBN13: 9781556222238

ISBN10: 1556222238

Format: Paperback

Pub. Date: 2005-04-15

Publisher(s): Wordware

Other versions by this Author

List Price: ~~$41.95~~

Rent Book

Select for Price

Add to Cart

There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Buy from our Marketplace starting at $44.20

Summary

This book is designed to take Microsoft Access users to the next step in programming. Its five parts cover an intro-duction to VBA programming, manipulating databases with ADO, using DDL, event programming, and using ASP and XML. With more than 300 hands-on examples and 11 custom projects, users can quickly build the toolset required for developing their own database solutions.

Acknowledgments

xiv

Introduction

Part I --- Introduction to Access 2003 VBA Programming

Procedures and Modules

(9)

Procedure Types

(1)

Module Types

(2)

Events, Event Properties, and Event Procedures

(5)

Why Use Events?

(1)

Walking Through an Event Procedure

(4)

Compiling Your Procedures

(1)

Chapter Summary

(1)

The Visual Basic Editor (VBE)

(16)

Understanding the Project Explorer Window

(1)

Understanding the Properties Window

(1)

Understanding the Code Window

(2)

Other Windows in the VBE

(1)

On-the-Fly Syntax and Programming Assistance

(6)

List Properties/Methods

(1)

Parameter Info

(1)

List Constants

(1)

Quick Info

(1)

Complete Word

(1)

Indent/Outdent

(1)

Comment Block/Uncomment Block

(1)

Using the Object Browser

(2)

Using the VBA Object Library

(1)

Using the Immediate Window

(2)

Chapter Summary

(1)

Variables, Data Types, and Constants

(24)

What Is a Variable?

(1)

What Are Data Types?

(1)

Creating Variables

(1)

Declaring Variables

(2)

Specifying the Data Type of a Variable

(2)

Using Type Declaration Characters

(1)

Assigning Values to Variables

(2)

Forcing Declaration of Variables

(2)

Understanding the Scope and Lifetime of Variables

(3)

Procedure-Level (Local) Variables

(1)

Module-Level Variables

(1)

Public Variables

(1)

Understanding and Using Static Variables

(2)

Declaring and Using Object Variables

(2)

Finding a Variable Definition

(1)

What Type Is This Variable?

(1)

Using Constants in VBA Procedures

(1)

Intrinsic Constants

(2)

Chapter Summary

(1)

Passing Arguments to Procedures and Functions

(24)

Writing a Function Procedure

(2)

Specifying the Data Type for a Function's Result

(2)

Passing Arguments by Reference and by Value

(1)

Using Optional Arguments

(2)

Using the Is Missing Function

(1)

Built-in Functions

(1)

Using the MsgBox Function

(8)

Returning Values from the MsgBox Function

(1)

Using the InputBox Function

(2)

Converting Data Types

(2)

Using Master Procedures and Subprocedures

(4)

Chapter Summary

(1)

Decision Making with VBA

(15)

If...Then Statement

(1)

Multi-Line If...Then Statement

(2)

Decisions Based on More Than One Condition

(1)

If...Then...Else Statement

(2)

If...Then...ElseIf Statement

(1)

Nested If...Then Statements

(1)

Select Case Statement

(5)

Using Is with the Case Clause

(1)

Specifying a Range of Values in a Case Clause

(2)

Specifying Multiple Expressions in a Case Clause

(1)

Chapter Summary

(1)

Repeating Actions in VBA

(11)

Using the Do...While Loop

(2)

Another Approach to the Do...While Loop

(1)

Using the Do...Until Loop

(1)

Another Approach to the Do...Until Loop

(1)

For...Next Loop

(2)

For...Each...Next Loop

(1)

Exiting Loops Early

(1)

Nested Loops

(2)

Chapter Summary

101

(1)

Working with Arrays

102

(17)

Declaring Arrays

104

(1)

Array Upper and Lower Bounds

105

(1)

Using Arrays in VBA Procedures

105

(2)

Arrays and Looping Statements

107

(3)

Using a Two-Dimensional Array

110

(1)

Static and Dynamic Arrays

111

(2)

Array Functions

113

(3)

The Array Function

113

(1)

The IsArray Function

113

(1)

The Erase Function

114

(1)

The LBound and UBound Functions

115

(1)

Errors in Arrays

116

(1)

Parameter Arrays

117

(1)

Chapter Summary

118

(1)

Custom Collections and Class Modules

119

(23)

Terminology

119

(1)

Working with Collections

120

(3)

Declaring a Custom Collection

121

(1)

Adding Objects to a Custom Collection

121

(2)

Removing Objects from a Custom Collection

123

(1)

Creating Custom Objects

123

(7)

Creating a Class

124

(1)

Variable Declarations

124

(1)

Defining the Properties for the Class

125

(1)

Creating the Property Get Procedures

126

(1)

Creating the Property Let Procedures

127

(1)

Creating the Class Methods

128

(1)

Creating an Instance of a Class

129

(1)

Event Procedures in the Class Module

130

(1)

Creating the User Interface

130

(9)

Watching the Execution of Your VBA Procedures

139

(2)

Chapter Summary

141

(1)

Debugging VBA Procedures and Handling Errors

142

(29)

Testing VBA Procedures

143

(1)

Stopping a Procedure

143

(13)

Using Breakpoints

144

(5)

Removing Breakpoints

149

(1)

Using the Immediate Window in Break Mode

149

(1)

Using the Stop Statement

150

(1)

Adding Watch Expressions

151

(3)

Removing Watch Expressions

154

(1)

Using Quick Watch

154

(2)

Using the Locals Window and the Call Stack Dialog Box

156

(2)

Stepping Through VBA Procedures

158

(2)

Stepping Over a Procedure

159

(1)

Stepping Out of a Procedure

160

(1)

Running a Procedure to Cursor

160

(1)

Setting the Next Statement

160

(1)

Showing the Next Statement

161

(1)

Stopping and Resetting VBA Procedures

161

(1)

Understanding and Using Conditional Compilation

161

(2)

Navigating with Bookmarks

163

(1)

Trapping Errors

164

(3)

Generating Errors to Test Error Handling

167

(1)

Chapter Summary

168

(3)

Part II --- Creating and Manipulating Databases with ADO

Accessing Data Using ADO

171

(23)

ADO Object Model

172

(1)

Establishing a Connection with the Data

173

(3)

Opening a Microsoft Jet Database in Read/Write Mode

176

(1)

Opening a Microsoft Jet Database in Read-Only Mode

177

(1)

Opening a Microsoft Jet Database Secured with a Password

178

(1)

Opening a Microsoft Jet Database with User-Level Security

179

(2)

Opening a Microsoft Excel Spreadsheet

181

(1)

Opening a dBASE File Using MSDASQL Provider

182

(2)

Opening a Text File Using ADO

184

(1)

Connecting to the Current Access Database

185

(1)

Creating a New Access Database

186

(1)

Copying a Database

187

(1)

Connecting to an SQL Server

188

(2)

Database Errors

190

(2)

Compacting a Database

192

(1)

Chapter Summary

193

(1)

Creating and Accessing Tables and Fields with ADO

194

(18)

Creating a Microsoft Access Table

195

(3)

Copying a Table

198

(1)

Deleting a Database Table

199

(1)

Adding New Fields to an Existing Table

200

(1)

Removing a Field from a Table

201

(1)

Retrieving Table Properties

202

(1)

Retrieving Field Properties

203

(1)

Linking a Microsoft Access Table

204

(1)

Linking a Microsoft Excel Spreadsheet

205

(2)

Listing Database Tables

207

(1)

Changing the AutoNumber

208

(1)

Listing Tables and Fields

209

(1)

Listing Data Types

210

(1)

Chapter Summary

211

(1)

Setting Up Indexes and Table Relationships with ADO

212

(9)

Creating a Primary Key

212

(1)

Creating a Single-Field Index

213

(2)

Adding a Multiple-Field Index to a Table

215

(1)

Listing Indexes in a Table

216

(1)

Deleting Table Indexes

217

(1)

Creating Table Relationships

218

(2)

Chapter Summary

220

(1)

ADO Techniques for Finding and Reading Records

221

(28)

Introduction to ADO Recordsets

221

(8)

Cursor Types

222

(2)

Lock Types

224

(1)

Cursor Location

225

(1)

The Options Parameter

226

(3)

Opening a Recordset

229

(7)

Opening a Recordset Based on a Table or Query

230

(3)

Opening a Recordset Based on an SQL Statement

233

(1)

Opening a Recordset Based on Criteria

234

(1)

Opening a Recordset Directly

235

(1)

Moving Around in a Recordset

236

(1)

Finding the Record Position

236

(1)

Reading Data from a Field

237

(1)

Returning a Recordset as a String

238

(2)

Finding Records Using the Find Method

240

(1)

Finding Records Using the Seek Method

241

(2)

Finding a Record Based on Multiple Conditions

243

(1)

Using Bookmarks

244

(2)

Using Bookmarks to Filter a Recordset

246

(1)

Using the GetRows Method to Fill the Recordset

247

(1)

Chapter Summary

248

(1)

Working with Records

249

(15)

Adding a New Record

249

(1)

Modifying a Record

250

(1)

Canceling Changes to the Data

251

(1)

Editing Multiple Records

251

(2)

Deleting a Record

253

(1)

Copying Records to an Excel Spreadsheet

254

(2)

Copying Records to a Word Document

256

(3)

Copying Records to a Text File

259

(1)

Filtering Records with an SQL Clause

260

(1)

Filtering Records Using the Filter Property

261

(1)

Sorting Records

262

(1)

Chapter Summary

263

(1)

Creating and Running Queries with ADO

264

(23)

Creating a Select Query Manually

264

(4)

Creating a Select Query from a VBA Procedure

268

(3)

Executing a Select Query

271

(3)

Creating a Parameter Query

274

(1)

Executing a Parameter Query

275

(2)

Creating a Pass-Through Query

277

(3)

Executing a Pass-Through Query

280

(1)

Executing an Update Query

281

(2)

Modifying a Stored Query

283

(2)

Listing Queries in a Database

285

(1)

Deleting a Stored Query

285

(1)

Chapter Summary

286

(1)

Using Advanced ADO Features

287

(47)

Fabricating a Recordset

287

(3)

Disconnected Recordsets

290

(2)

Saving a Recordset to Disk

292

(13)

Cloning a Recordset

305

(5)

Introduction to Data Shaping

310

(20)

Writing a Simple Shape statement

311

(1)

Working with Data Shaping

312

(4)

Writing a Complex Shape Statement

316

(1)

Shaped Recordsets with Multiple Children

317

(3)

Shaped Recordsets with Grandchildren

320

(10)

Transaction Processing

330

(3)

Creating a Simple Transaction

330

(3)

Chapter Summary

333

(1)

Implementing Database Security with Adox and JRO

334

(37)

Two Types of Security in Microsoft Access

334

(1)

Share-Level Security

334

(1)

User-Level Security

335

(1)

Understanding Workgroup Information Files

335

(10)

Creating and Joining Workgroup Information Files

337

(8)

Working with Accounts

345

(11)

Creating a Group Account

345

(3)

Creating a User Account

348

(1)

Adding a User to a New Group

349

(2)

Deleting a User Account

351

(1)

Deleting a Group Account

352

(1)

Listing All Group Accounts

353

(1)

Listing All User Accounts

354

(1)

Listing Users in Groups

355

(1)

Setting and Retrieving User and Group Permissions

356

(13)

Determining the Object Owner

356

(2)

Setting User Permissions for an Object

358

(3)

Setting User Permissions for a Database

361

(1)

Setting User Permissions for Containers

362

(2)

Checking Permissions for Objects

364

(2)

Setting a Database Password

366

(1)

Changing a User Password

367

(2)

Encrypting a Database

369

(1)

Chapter Summary

370

(1)

Database Replication

371

(24)

Creating a Design Master

372

(2)

Creating a Full Replica

374

(1)

Creating a Partial Replica

375

(3)

Replicating Objects

378

(2)

Keeping Objects Local

380

(2)

Synchronizing Replicas

382

(2)

Retrieving Replica Properties

384

(1)

Synchronization Conflicts

385

(6)

Chapter Summary

391

(4)

Part III --- Programming with the Jet Data Definition Language

Creating, Modifying, and Deleting Tables and Fields

395

(18)

Creating Tables

397

(4)

Deleting Tables

401

(1)

Deleting Database Files

402

(1)

Modifying Tables with DDL

402

(10)

Adding New Fields to a Table

402

(1)

Changing the Data Type of a Table Column

403

(1)

Changing the Size of a Text Column

404

(1)

Deleting a Column from a Table

405

(1)

Adding a Primary Key to a Table

406

(1)

Adding a Multiple-Field Index to a Table

406

(1)

Deleting an Indexed Column

407

(1)

Deleting an Index

408

(1)

Setting a Default Value for a Table Column

409

(1)

Changing the Seed and Increment Value of AutoNumber Columns

410

(2)

Chapter Summary

412

(1)

Enforcing Data Integrity and Relationships between Tables

413

(11)

Using Check Constraints

414

(4)

Establishing Relationships between Tables

418

(3)

Using the Data Definition Query Window

421

(2)

Chapter Summary

423

(1)

Defining Indexes and Primary Keys

424

(9)

Creating Tables with Indexes

424

(1)

Adding an Index to an Existing Table

425

(2)

Creating a Table with a Primary Key

427

(1)

Creating Indexes with Restrictions

428

(4)

Deleting Indexes

432

(1)

Chapter Summary

432

(1)

Database Security

433

(11)

Setting the Database Password

433

(1)

Removing the Database Password

434

(1)

Creating a User Account

435

(1)

Changing a User Password

436

(1)

Creating a Group Account

437

(1)

Adding Users to Groups

438

(1)

Removing a User from a Group

438

(1)

Deleting a User Account

439

(1)

Granting Permissions for an Object

440

(1)

Revoking Security Permissions

441

(1)

Deleting a Group Account

442

(1)

Chapter Summary

443

(1)

Views and Stored Procedures

444

(15)

Creating a View

444

(3)

Enumerating Views

447

(1)

Deleting a View

448

(1)

Creating a Stored Procedure

448

(2)

Creating a Parameterized Stored Procedure

450

(2)

Executing a Parameterized Stored Procedure

452

(2)

Deleting a Stored Procedure

454

(1)

Changing Database Records with Stored Procedures

454

(1)

Chapter Summary

455

(4)

Part IV --- Event Programming in Forms and Reports

Using Form Events

459

(42)

Data Events

460

(9)

Current

460

(1)

BeforeInsert

461

(1)

AfterInsert

462

(1)

BeforeUpdate

463

(1)

AfterUpdate

464

(1)

Dirty

465

(1)

OnUndo

466

(1)

Delete

466

(1)

BeforeDelConfirm

467

(1)

AfterDelConfirm

468

(1)

Focus Events

469

(1)

Activate

469

(1)

Deactivate

469

(1)

GotFocus

470

(1)

LostFocus

470

(1)

Mouse Events

470

(3)

Click

470

(1)

DblClick

471

(1)

MouseDown

471

(2)

MouseMove

473

(1)

MouseUp

473

(1)

MouseWheel

473

(1)

Keyboard Events

473

(3)

KeyDown

473

(1)

KeyUp

474

(1)

KeyPress

475

(1)

Error Events

476

(2)

Error

476

(2)

Filter Events

478

(2)

Filter

478

(1)

ApplyFilter

479

(1)

Timing Events

480

(2)

Timer

480

(2)

PivotTable/PivotChart Events

482

(17)

Referencing the Microsoft Office Web Components Object Library

483

(1)

Data Source Events

483

(1)

OnConnect

483

(1)

OnDisconnect

484

(1)

BeforeQuery

484

(1)

Query

484

(3)

Display Events

487

(1)

BeforeScreenTip

487

(1)

AfterLayout

487

(1)

BeforeRender

488

(2)

AfterRender

490

(1)

AfterFinalRender

491

(1)

Change Events

492

(1)

DataChange

492

(1)

DataSetChange

493

(1)

PivotTableChange

493

(1)

SelectionChange

494

(1)

ViewChange

494

(1)

Command Events

495

(1)

CommandEnabled

495

(1)

CommandChecked

496

(1)

CommandBeforeExecute

497

(1)

CommandExecute

498

(1)

Keyboard and Mouse Events

498

(1)

Events Recognized by Form Sections

499

(1)

DblClick (Form Section Event)

499

(1)

Chapter Summary

500

(1)

Using Report Events

501

(13)

Open

501

(1)

502

(1)

Activate

503

(1)

Deactivate

504

(1)

NoData

504

(1)

Page

505

(1)

Error

506

(1)

Events Recognized by Report Sections

507

(6)

Format (Report Section Event)

507

(3)

Print (Report Section Event)

510

(3)

Retreat

513

(1)

Chapter Summary

513

(1)

Events Recognized by Controls

514

(14)

Enter (Control)

515

(1)

BeforeUpdate (Control)

516

(1)

AfterUpdate (Control)

517

(2)

No InList (Control)

519

(1)

Click (Control)

520

(5)

DblClick (Control)

525

(2)

Chapter Summary

527

(1)

More about Event Programming

528

(21)

Sinking Events in Standalone Class Modules

529

(8)

Writing Event Procedure Code in Two Places

537

(1)

Responding to Control Events in a Class

537

(4)

Declaring and Raising Events

541

(5)

Chapter Summary

546

(3)

Part V --- Taking Your VBA Programming Skills to the Web

Access and Active Server Pages

549

(58)

Introduction to Active Server Pages

552

(3)

The ASP Object Model

555

(1)

Installing Internet Information Services (IIS)

556

(1)

Creating a Virtual Directory

557

(2)

Connecting to a Microsoft Access Database via DSN

559

(6)

Other Methods of Connecting to a Microsoft Access Database

565

(2)

Establishing a DSN-less Connection

566

(1)

Connecting to a Microsoft Access Database Using OLE DB

566

(1)

Retrieving Records

567

(12)

Breaking Up a Recordset When Retrieving Records

569

(7)

Retrieving Records with the GetRows Method

576

(3)

Database Lookup Using Drop-Down Lists

579

(4)

Database Lookup Using a Multiple Selection List Box

583

(5)

Adding Data into a Table

588

(4)

Modifying a Record

592

(5)

Deleting a Record

597

(4)

Creating a Web User Interface for Database Access

601

(4)

Chapter Summary

605

(2)

XML Features in Access 2003

607

(64)

What is XML?

607

(2)

XML Support in Access 2003

609

(1)

Exporting XML Data

610

(14)

Understanding the XML Data File

612

(3)

Understanding the XML Schema File

615

(2)

Understanding the XSL Transformation Files

617

(3)

Viewing XML Documents Formatted with Stylesheets

620

(1)

Advanced XML Export Options

620

(1)

Data Export Options

620

(2)

Schema Export Options

622

(1)

Presentation Export Options

623

(1)

Applying XSLT Transforms to Exported Data

624

(5)

Importing XML Data

629

(5)

Exporting to and Importing from XML Programmatically

634

(16)

Exporting to XML Using the ExportXML Method

635

(8)

Transforming XML Data with the TransformXML Method

643

(7)

Importing to XML Using the ImportXML Method

650

(1)

Manipulating XML Documents Programmatically

650

(8)

Loading and Retrieving the Contents of an XML File

652

(1)

Working with XML Document Nodes

653

(2)

Retrieving Information from Element Nodes

655

(1)

Retrieving Specific Information from Element Nodes

656

(1)

Retrieving the First Matching Node

657

(1)

Using ActiveX Data Objects with XML

658

(10)

Saving an ADO Recordset as XML to Disk

658

(2)

Attribute-Centric and Element-Centric XML

660

(1)

Changing the Type of an XML File

660

(1)

Applying an XSL Stylesheet

661

(2)

Transforming Attribute-Centric XML Data into an HTML Table

663

(3)

Loading an XML Document in Excel

666

(2)

Chapter Summary

668

(3)

Index

671

Kids

Men

Women

For You

For Your Car

For Your Home

For Your Pet

Artwork

Games

Holiday

Mascot

Outdoor/Recreation

Sporting

Graduation Gear

Graduation Gifts

Office Supplies

School Supplies

Clothing

Access 2003 Programming By Example With Vba, Xml, And Asp

Rent Book

New Book

Used Book

eBook

Summary

Table of Contents

Access 2003 Programming By Example With Vba, Xml, And Asp

Rent Book

New Book

Used Book

eBook

How Marketplace Works:

Summary

Table of Contents

Digital License