Flylib.com

Books Software

 
 
 

Beginning Access 2002 VBA (Programmer to Programmer) - page 246

team lib

Index

N

N \t, Chapter 1: Designing Applications

name clashes , Considerations

Name property, ADO Command objects, Command Properties

Name property, ADO Command objects \i \rName1, Name

Name property, buttons, Try It Out-Adding Simple Navigation Buttons to a Form

named arguments, procedures \i \rnamed1, Named Arguments

naming conventions

constants \b \rconstants1, Naming Conventions for Constants

controls \b \rcontrols1, Naming Conventions for Controls

objects \b \robjects1, Naming Conventions for Objects

naming conventions \i \rnaming1, Naming Conventions

navigation buttons, forms \i \rbuttons1, Creating Navigation Buttons, Adding Intelligent Navigation Buttons to the Company Contacts Form, Moving Through Recordsets

nested control structures \i \rnested1, Nested Control Structures

networks \i \rnetworks1, Network Considerations

New keyword \rNew1, Creating Automation Objects

NewRecord property, Form objects \rNewRecord1, Adding Intelligent Navigation Buttons to the Company Contacts Form

Next keyword (see For loops ) \t, For...Next

NoData event, reports , Filters

NoData event, reports \i \rNoData1, NoData

NoMatch property, DAO Recordset objects, Try It Out-Allowing for No Matches, The Language Converter Add-In

NoMatch property, DAO Recordset objects \rNoMatch1, Try It Out-Using the Find Methods

normalization, data \i \rnormalization1, Data Analysis

Not operator \rNot1, Logical Operators with the If statement

Nothing keyword \rNothing1, Reclaim Memory Where Possible

Now function, Other Useful Date and Time Fuctions

null pointers \i \rnull2, Null Pointers

null terminated strings \i \rnull1, Passing Strings

null value, Variant type \i \rnull1, The Null Value

Number property, Err objects, The Err Object, Using a Matching Records Table, The Err Object

Number property, Err objects \rNumber1, Visual Basic Errors

 

team lib

team lib

Index

O

O \t, Chapter 1: Designing Applications

Object Browser \i \rBrowser1, The Object Browser

object libraries \i, Object References

object listbox, Code window \i \robject1, Code Window

object models

Outlook, Microsoft Outlook

object models \i \rmodels1, Object Models, Get the Object Model Right, Interfaces and Object Models

object oriented programming (see OOP), Object Oriented Programming

Object type, Variable Types, Use the Right Data Type

Object type \i \rObject1, Object

objects

Access 2002 \b \rAccess1, Access 2002 Objects

creating an object \b \robjects1, Creating Automation Objects

early binding \b, Try It Out-Using the Implements keyword

early binding \b \rearly1, Try It Out-Using the Implements keyword, Use Specific Object Types (Early Binding)

naming conventions \b \robjects1, Naming Conventions for Objects

New keyword \rNew1, Creating Automation Objects

Nothing keyword \rNothing1, Reclaim Memory Where Possible

references \b \rreferences1, Object References

variables \rvariables1, Creating Automation Objects

With statements \rWith1, Use Variables, Not Properties

objects \i \robjects1, Objects, What Are Objects?

objects \robjects2, Don't Overdo It

ODBC \rODBC1, The Future of DAO

ODBCDirect \i, A Brief History of DAO

ODC files \rODC1, DAP Connection Files

OLEDB \i \rOLEDB1, OLEDB and ADO, Object Linking and Embedding Database (OLE DB)

On Change event property, Other Events

On Click event property, Other Events

On Close event property, Other Events

On Current event property, Other Events, Adding Intelligent Navigation Buttons to the Company Contacts Form

On Dbl Click event property, Other Events

On Delete event property, Other Events

On Dirty event property, Other Events

On Error event property, Other Events

On Error statements, The Err Object

On Error statements \rOnError1, Visual Basic Errors

On Mouse Move event property, Other Events

On Mouse Up event property, Other Events

On Undo event property, Adding to the User Interface

OnConnect property, Form objects, New Object Properties & Methods

OnDisconnect property, Form objects, New Object Properties & Methods

OnUndo property, Form objects, New Object Properties & Methods

OOP (object oriented programming) \i \rOOP1, Object Oriented Programming, Object-Oriented Techniques, Benefits of an Object-Oriented Approach

Open event, reports , NoData, Filters

Open event, reports \i \rOpen1, Open

Open event, reports \rOpen2, Filters

Open method, ADO Recordset objects \rOpen1, Try It Out-Using ADO to Populate a Form in the IceCream.mdb file

OpenForm method, DoCmd object, Try It Out-Editing Hyperlinks

OpenRecordset method, DAO Database objects, Dynasets and Snapshots, Try It Out-Implementing the PaymentStats logic

OpenRecordset method, DAO Database objects \rOpenRecordset1, Different Types of Recordset

OpenRecordset method, DAO Database objects \rOpenRecordset2, Building Recordsets Dynamically

OpenRecordset method, DAO Database objects \rOpenRecordset3, Working with Recordsets

operators

arithmetic operators \rarithmetic1, Operator Precedence

comparison operators \rcomparison1, Operator Precedence

logical operators \b \rlogical1, Logical Operators with the If statement

precedence \b \rprecedence1, Operator Precedence

optimization

caches \b \rcaches1, Cache Data Locally

DAO recordsets, Use Bookmarks

DAO recordsets \b \rrecordsets1, Use Appropriate Recordset Types

DoEvents statements \b \rDoEvents1, Use DoEvents Judiciously

early binding \b \rearly1, Use Specific Object Types (Early Binding)

execution speed, Timing the Code Samples, Avoid Slow Structures, Increasing Apparent Speed, Cache Data Locally

execution speed \b \rexecution1, Increasing Execution Speed

in-line code \b \rinline1, Use In-Line Code

indexes \b \rindexes1, Use Indexes

indexes \b \rindexes2, Search on Indexed Fields in Attached Tables

local machines \b \rlocal1, Put Non-Table Objects on the Local Machine

memory \b \rmemory1, Reducing Memory Overhead

memory \b \rmemory2, Reclaim Memory Where Possible

memory \b \rmemory3, A Final Recommendation - Buy More Memory!

networks \b \rnetworks1, Network Considerations

Performance Analyzer \rAnalyzer1, Efficiency

test data \b \rdata1, Creating Test Data

test harnesses \b \rharnesses1, Timing the Code Samples

test tables \b \rtables1, Populating the Test Table

types \b \rtypes1, Use the Right Data Type

optimization \i \roptimization1, Chapter 19: Optimizing Your Application

Option Base statements, Parameter Arrays

Option Base statements \i \rBase1, Option Base

Option Base statements \rBase1, Important

Option Base statements \rBase2, The Array Function

Option Compare Binary statements \i, Option Compare

Option Compare Database statements, Comparing Bookmarks

Option Compare Database statements \i, Option Compare

Option Compare Text statements \i, Option Compare

Option Explicit statements \i \rExplicit1, Option Explicit

Option Explicit statements \rExplicit1, The Dangers of ReDim

Option keyword, Options

Option Private statements \i \rPrivate1, Option Private

optional arguments, procedures \i \roptional1, Optional Arguments

Optional keyword, Try It Out-Creating the PaymentStats Class Interface

Optional keyword \rOptional2, Optional Arguments

Or operator \rOr1, Logical Operators with the If statement

ORDER BY clause, SQL

views NOT allowing, Views

OrdinalPosition property, DAO Field objects, Working with Tables

OrdinalPosition property, DAO Field objects \rOrdinalPosition1, Working with Tables

Outlook

appointments \b \rappointments1, Microsoft Outlook

email \b \remail1, Microsoft Outlook

object model, Microsoft Outlook

Outlook \i \rOutlook1, Microsoft Outlook

 

team lib