ADO Object Tags

Tag

Object

Tag

Object

cmd

Command

prm

Parameter

cnn/cnx

Connection

prms

Parameters

err

Error

prps

Properties

errs

Errors

prp

Property

fld

Field

rst

Recordset

flds

Fields

The following table lists the common DAO object tags. Again, these include the plural forms although most developers stick to singular forms. The list is in order by DAO object.

DAO Object Tags

Tag

Object

Tag

Object

cnt/con

Container

err

Error

db

Database

fld

Field

dbe

DBEngine

fdc

Field collection

doc

Document

fd

Field Object

ds

Dynaset

grp/gru

Group

Tag

Object

Tag

Object

idx

Index

rsnp

Recordset (snapshot)

ixc

Index collection

rtbl

Recordset (table)

ix

Index Object

rel

Relation

int

Integer

sng

Single

lng

Long

snp

Snapshot

obj

Object

str

String

prm

Parameter

tbl

Table

prp

Property

tb

Table Object

qry

Query

tdf

TableDef

qdf

QueryDef

td

TableDev Object

qd

QueryDef Object

usr

user

rst

Recordset

var

Variant

rdyn

Recordset (dynaset)

wsp

Workspace

The following table lists the common VB Object tags. Again, these include the plural forms although most developers stick to singular forms. The list is in order by VB object.

VB Object Tags

Tag

Object

Tag

Object

app

App

fra

Frame

chk

CheckBox

glb

Global

clp

Clipboard

hsb

HScrollBar

cbo

ComboBox

img

Image

cmd

CommandButton

lbl

Label

ctl

Control

lics

Licenses

dat

Data

lin

Line

dir

DirListBox

lst

ListBox

drv

DriveListBox

mdi

MDIForm

fil

FileListBox

mnu

Menu

frm

Form

ole

OLE

Tag

Object

Tag

Object

opt

OptionButton

txt

TextBox

pic

PictureBox

tmr

Timer

prt

Printer

uctl

UserControl

prp

PropertyPage

udoc

UserDocument

scr

Screen

vsb

VscrollBar

shp

Shape

The following table lists the common Data Type tags

in order by data type.

Data Type Tags

Tag

Object

Tag

Object

ID

AutoNumber

lng

Long

bin

Binary

mem

Memo

bln/tf

Boolean (Yes/No)

obj

Object

byt

Byte

ole

Ole

col

Collection

sng

Single

cur

Currency

str

String

dat/dtm/dt

Date/Time

stf

String (fixed length)

dec

Decimal

chr

Text (character)

dbl

Double

udt

User-defined type

err

Error

var/vnt

Variant

int

Integer

The following table lists the common scope prefixes. A scope prefix typically precedes the tags on functions and constants.

Prefix

Scope

(none)

Local, procedural level lifetime

c

Constants

g

Global (public) object lifetime

m

Module-level, private object lifetime

s

Static variable, static object lifetime

Field tags are truly optional. They provide the extra bit of detail when added to an otherwise complete name. Think "self-documenting." Notice in the following table that many of the field tags are the same as the data type tags for other objects.

Tag

Field Object Type

lng

Autoincrementing (either sequential or random) Long (used with the suffix Cnt)

bin

Binary

byte

Byte

cur

Currency

date

Date/time

dbl

Double

guid

Globally unique identifier (GUID) used for replication Autoincrement fields

int

Integer

lng

Long

mem

Memo

ole

OLE

sng

Single

str

Text

bool

Yes/No

Tag suffixes, listed object.

in the following table,

are another optional detail. They explicitly identify the type of

Tag Suffixes with Objects

Tag

Suffix

Object

tlkp

Lookup

Table (lookup)

qsel

(none)

Query (select)

qapp

Append

Query (append)

qxtb

Xtab

Query (crosstab)

qddl

DDL

Query (DDL)

qdel

Delete

Query (delete)

qflt

Filter

Query (filter)

Tag Suffixes with Objects

Tag

Suffix

Object

qlkp

Lookup

Query (lookup)

qmak

MakeTable

Query (make table)

qspt

PassThru

Query (SQL pass-through)

qtot

Totals

Query (totals)

quni

Union

Query (union)

qupd

Update

Query (update)

fdlg

Dlg

Form (dialog)

fmnu

Mnu

Form (menu)

fmsg

Msg

Form (message)

fsfr

SubForm

Form (subform)

rsrp

SubReport

Report (subreport)

mmnu Mnu Macro (menu)

mmnu Mnu Macro (menu)

Standards

Throughout the book, we've pulled together reference material, sharing our expertise and experiences, and encouraging you to take the try-it, like-it, modify-as-appropriate approach. That methodology is particularly fitting for the lists and guidelines in these appendixes. With that in mind, here are a few reminders:

□ Rules and guidelines change over time, so your naming conventions may need to be updated as you work with new versions and additional programs.

□ There's an overwhelming supply of reference material with varying degrees of quality and applicability.

Some of the more reliable sources for additional or updated information on naming conventions, reserved words and special characters will likely be found by searching Microsoft and www.mvps.org. Although it might seem that the preponderance of Microsoft's articles is related to .NET, there are several that are relevant to Access development.

The most critical factor is that you consistently implement and follow some standard.

0 0

Post a comment