Beginning Access 2002 VBA
Authors: Smith R.,  Sussman D.
 Published year: 2003
 Pages: 243-245/256
Buy this book on amazon.com >>

team lib

Index

J-K

J \t, Chapter 1: Designing Applications

JET database engine

SQL Server 2000/Desktop and, Jet vs. SQL Server: Why Move?

JET database engine \rJET1, A Brief History of DAO

JET database engine \rJET2, The Future of DAO

K \t, Chapter 1: Designing Applications

Kernel32.dll file, Dynamic Link Libraries (DLLs)

key values \i \rkey1, Dynaset-type Recordset Objects

keyboard shortcuts \rshortcuts1, Trapping Keystrokes Throughout an Application

keysets \rkeysets1, Dynaset-type Recordset Objects

keywords \i, Why is the Code in Different Colors?

 

team lib

team lib

Index

L

L \t, Chapter 1: Designing Applications

labels \i \rlabels1, Visual Basic Errors

Language Converter add-in (example)

USysRegInfo table \b \rUSysRegInfo1, Try It Out-Creating the USysRegInfo Table

Language Converter add-in (example) \i \rLanguage1, The Language Converter Add-In

LastDLLError property, Err objects, The Err Object

libraries (see DLLs), Class Libraries

libraries (see DLLs) \t, Dynamic Link Libraries (DLLs)

library databases, An ADO Class Library

name clashes , Considerations

library databases \i \rlibrary1, Creating a Library Database

lifetime, variables \i, Variable Scope and Lifetime

linked tables \i \rlinked1, Linked Tables

list boxes

AddItem method \rAddItem1, Dynamic Listboxes

RowSource property \rRowSource1, Dynamic Listboxes

RowSourceType property \rRowSourceType1, Dynamic Listboxes

RowSourceType property \rRowSourceType2, Dynamic Listboxes

list boxes \i \rlist1, Dynamic Listboxes

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

local tables \i \rlocal1, Differences between Linked and Local Tables

local variables \i \rlocal1, Variable Scope and Lifetime

local variables \i \rlocal2, Local Variables

Locals window, Hovering

Locals window \i \rLocals1, The Locals Window

Locals window \rLocals1, Working with Recordsets

Locals window \rLocals2, Hovering

locking, ADO recordsets \i \rlocking1, Locking

logic errors \i, What if I Still Get it Wrong?

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

logins, SQL Server security, Logins

creating & adding to server, example, Try It Out-Adding a Login to SQL Server, Try It Out-Create the Whole Works

Long type, Variable Types, Integer and Long, Use the Right Data Type, Use Integer Arithmetic Where Possible

lookup fields \i, Databases

Loop keyword (see Do loops ) \t, Do...Loop

loops \i \rloops1, Loops

 

team lib

team lib

Index

M

M \t, Chapter 1: Designing Applications

macros

converting to VBA \i \rconverting1, Important

keyboard shortcuts \rshortcuts1, Trapping Keystrokes Throughout an Application

macros \i \rmacros1, Macros Or VBA?

maintainance \i \rmaintainance1, Testing

make-table queries \i, Using a Matching Records Table

master detail pages \rmaster1, New DAP Events

matching keys \rkeys1, Using a Matching Records Table

matching records tables \i \rmatching1, Using a Matching Records Table

MDE files \i \rMDE1, Save as an MDE

Me keyword \i \rMe1, The Me Keyword

Me keyword \i \rMe1 VBA, Use Me, see also vba code

Me keyword \rMe1, Adding Intelligent Navigation Buttons to the Company Contacts Form

memory

arrays \b \rmemory1, Memory Considerations

memory \i \rmemory1, Reducing Memory Overhead

memory \i \rmemory2, Reclaim Memory Where Possible

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

methods, objects \i \rmethods1, What are Actions and Methods?, Methods, Custom Form Methods

methods, objects \rmethods2, Avoid Get and Set Methods

Microsoft Access (see Access)\t, What is Client-Server?

Microsoft Excel (see Excel), Microsoft Excel

Microsoft Outlook (see Outlook) \t, Microsoft Outlook

Microsoft Word (see Word) \t, Microsoft Word

Mixed Security

SQL Server security using, Roles, Try It Out-Adding a Login to SQL Server

module level variables (see private variables), Global Variables

modules

class modules \b \rclass2, Forms as Class Modules

class modules \b \rclass3, Getting the Most from Class Modules

class modules \b \rmodules2, Form and Report Modules

class modules \rclass1, Differences between Classes and Modules

class modules \rclass2, An ADO Class Library

Declarations sections, Try It Out-Creating an Enum

Declarations sections \rDeclarations1, Declaring a DLL in Code

form modules \b \rmodules2, Remove Code from Form Modules

report modules, Events

standard modules \b \rstandard1, Standard Modules

modules \i \rmodules1, Form and Report Modules, Modules, Differences between Classes and Modules, Group Procedures into Modules

modules \i \rmodules3, Compile All Modules

MONTH function, SQL Server, qrySalesSummary

Move method, DAO Recordset objects, Moving Through Recordsets

MoveFirst method, ADO Recordset objects, Moving Around in Recordsets

MoveFirst method, DAO Recordset objects, Moving Through Recordsets, Try It Out-Implementing the PaymentStats logic

MoveLast method, ADO Recordset objects, Moving Around in Recordsets

MoveLast method, DAO Recordset objects, Moving Through Recordsets, Try It Out-Implementing the PaymentStats logic

MoveLast method, DAO Recordset objects \rMoveLast1, Dynasets and Snapshots

MoveNext method, ADO Recordset objects, Moving Around in Recordsets

MoveNext method, DAO Recordset objects, Moving Through Recordsets

MoveNext method, DAO Recordset objects \rMoveNext1, Moving Through Recordsets

MoveNext method, DAO Recordset objects \rMoveNext2, Moving Through Recordsets

MovePrevious method, ADO Recordset objects, Moving Around in Recordsets

MovePrevious method, DAO Recordset objects, Moving Through Recordsets

MSDE (Microsoft SQL Server Desktop Engine), see SQL Server 2000/Desktop\t, Chapter 20: Moving to Client-Server

MsgBox function \rMsgBox1, Adding to the User Interface

multi-dimensional arrays

dynamic arrays \rdynamic1, Dynamic Multi-dimensional Arrays

multi-dimensional arrays \i \rmulti1, Multi-dimensional Arrays

multi-line UDF, SQL Server, Multi-Line User-Defined Functions

fixing combo box using, example, Multi-Line User-Defined Functions, Try It Out-Fixing the Combo using a UDF

multiple instances, forms \i \rinstances1, Creating Multiple Instances of Forms

MyRectangle class (example) \i \rMyRectangle1, The MyRectangle Class

 

team lib

Beginning Access 2002 VBA
Authors: Smith R.,  Sussman D.
 Published year: 2003
 Pages: 243-245/256
Buy this book on amazon.com >>

Similar books