Appendix C

Leszynski Naming Conventions for Microsoft Solution Developers


This appendix provides naming convention tags for objects found in Microsoft Office, Visual Basic, and other tools commonly used by solution developers. Use these tags to create meaningful names for application objects and VBA code.

Even if you don't have need of the naming conventions detailed here, this appendix provides a handy and comprehensive object model reference for writing Automation code against Office object models.

To understand the value of tags and how to apply them, review the tutorial on naming conventions in Chapter 5, "Creating Naming Conventions," and the examples for using Access conventions shown in Chapter 6, "Leszynski Naming Conventions for Access."

The file LNC97DEV.HLP on the CD-ROM provides a Windows Help file version of this appendix that you can place on your workstation desktop and use to guide your daily coding efforts. The Help file is more detailed than this appendix. For the latest updates to LNC, visit the Web sites www.kwery.com or www.ldfinfo.com.

Because VBA code is standardized in the Office suite, coding conventions described for Access in Chapter 6, "Leszynski Naming Conventions for Access," can be applied in other hosts. For example, the VBA variable prefixes described in that chapter's section "Prefixes for Variables" will work in Excel, PowerPoint, Project, and Word VBA in the same fashion as they work in Access, and thus are not repeated in this appendix.

In order to make this appendix comprehensive with respect to programmable object models, the tags for Access and Jet (DAO) objects disclosed in Chapter 6 are repeated here.

Each table in this appendix has four columns:

Tags for Access Objects

Access objects are exposed to Automation via the type library MSACC8.OLB.

Table C.1 Tags for Access Objects

Object or item

In Typelib

Tag

Comment

Access


acc

Automation entry point

Application

x

app

Automation entry point

BoundObjectFrame

x

frb

Form/report control

CheckBox

x

chk

Form/report control

Class Module


cls

Database window object, new in 97

ComboBox

x

cbo

Form/report control

CommandButton

x

cmd

Form/report control

Control(s)

x

ctl(s)


CustomControl

x

ocx

Form/report control

Debug


<n/t>


Detail (section)


det

Form/report section

DoCmd

x

dcd


Editors

x

edis

New in 97

Err


<n/t>


Footer (grouping section)*


gft[n]

Report section, see footnote

Form (class)


fcls

Database window object

Form (dialog)


fdlg

Database window object

Form (lookup table)


flkp

Database window object

Form (menu/switchboard)


fmnu

Database window object

Form (message/alert)


fmsg

Database window object

Form (subform)


fsub

Database window object

Form (wizard main)


fwzs

Database window object

Form (wizard subform)


fwzm

Database window object

Form(s)

x

frm(s)

Database window object

Form Footer (section)


fft

Form section

Form Header (section)


fhd

Form section

GroupLevel

x

lvl

Report section

Header (grouping section)


ghd[n]

Report section, see footnote

Hyperlink

x

hlk

New in 97

Image

x

img

Form/report control

Label

x

lbl

Form/report control

Line

x

lin

Form/report control

ListBox

x

lst

Form/report control

Macro


mcr

Database window object

Macro (bar menu)


mbar

Database window object

Macro (for form/report)**


m[obj]

Database window object, see footnote

Macro (general menu)


mmnu

Database window object

Macro (shortcut menu)


mmct

Database window object

Macro (submenu/drop-down)


mmsb

Database window object

Module

x

bas

Database window object

Modules

x

bass

New in 97

ObjectFrame

x

fru

Form/report control

OptionButton

x

opt

Form/report control

OptionGroup

x

grp

Form/report control

Page(s)

x

pge(s)

New in 97

PageBreak

x

brk

Form/report control

Page Footer (section)


pft

Form/report section

Page Header (section)


phd

Form/report section

Properties

x

prps

New in 97

Query


qry

Database window object

Query (append)


qapp

Database window object

Query (crosstab)


qxtb

Database window object

Query (data definition)


qddl

Database window object

Query (delete)


qdel

Database window object

Query (form filter)


qflt

Database window object

Query (form/report source)**


q[obj]

Database window object, see footnote

Query (lookup table)


qlkp

Database window object

Query (make table)


qmak

Database window object

Query (select)


qsel

Database window object

Query (SQL pass-through)


qspt

Database window object

Query (union)


quni

Database window object

Query (update)


qupd

Database window object

Rectangle

x

shp

Form/report control

Reference(s)

x

ref(s)

New in 97

Report (detail)


rdet

Database window object

Report (sub)


rsub

Database window object

Report (summary)


rsum

Database window object

Report(s)

x

rpt(s)

Database window object

Report Footer (section)


rft

Report section

Report Header (section)


rhd

Report section

Screen

x

scn


Section

x

sec


SubForm

x

fsub

Form/report control and Database window object

SubReport

x

rsub

Form/report control and Database window object

TabControl

x

tab

Form/report control, new in 97

Table


tbl

Database window object

Table (linked Btrieve)


tbtv

Database window object

Table (linked dBASE)


tdbf

Database window object

Table (linked Excel)


txls

Database window object

Table (linked FoxPro)


tfox

Database window object

Table (linked Lotus 1-2-3)


twks

Database window object

Table (linked ODBC)


todb

Database window object

Table (linked Paradox)


tpdx

Database window object

Table (linked SQL Server)


tsql

Database window object

Table (linked text)


ttxt

Database window object

Table (lookup)


tlkp

Database window object

Table (many-to-many relation)


tlnk

Database window object

Table (summary information)


tsum

Database window object

TextBox

x

txt

Form/report control

ToggleButton

x

tgl

Form/report control, changed from 95 standard

* [n] in the headers and footers for reports indicates the GroupLevel index, as in gft0 for the first group footer.

** [obj] refers to the full name of a database object, such as tlkpState.

Tags for ActiveX Control Objects

The Office Developer Edition and Visual Basic each ship with a variety of ActiveX controls for use in forms. Table C.2 lists the LNC object tags for the ActiveX controls that ship with these products.

Table C.2 Tags for ActiveX Controls

Control

Tag

Source

File Name

Class Name

3-D Check Box

chk3

VB

THREED32.OCX

SSCheck

3-D Command Button

cmd3

VB

THREED32.OCX

SSCommand

3-D Frame

fra3

VB

THREED32.OCX

SSFrame

3-D Group Push Button

gpb3

VB

THREED32.OCX

SSRibbon

3-D Option Button

opt3

VB

THREED32.OCX

SSOption

3-D Panel

pnl3

VB

THREED32.OCX

SSPanel

Animated Button

ani

VB

ANIBTN32.OCX

AniPushButton

Animation*

anm

ODE/VB

COMCT232.OCX

Animation

Calendar

cal

Access

MSCAL.OCX

MSCal

Kwery Calendar

kcal

Kwery

KCCAL32.OCX

KCCalendar

Chart*

cht

VB

MSCHART.OCX

MSChart

Kwery Clock

kclk

Kwery

KCCLOK32.OCX

KCClock

Common Dialog

cdlg

ODE/VB

COMDLG32.OCX

CommonDialog

Communications

com

VB

MSCOMM32.OCX

MSComm

Crystal Report

rpt

VB

CRYSTL32.OCX

CrystalReport

Data Outline

dout

ADT

DBOUTL32.OCX

DataOutline

DBCombo

dcbo

VB

DBLIST32.OCX

DBCombo

DBGrid

dgrd

VB

DBGRID32.OCX

DBGrid

DBList

dlst

VB

DBLIST32.OCX

DBList

FlexGrid*

flx

VB

MSFLXGRD.OCX

FlexGrid

Gauge

gau

VB

GAUGE32.OCX

Gauge

Kwery Gauge

kgau

Kwery

KCGAGE32.OCX

KCGauge

Grid

grd

VB

GRID32.OCX

Grid

Image List

ilst

ODE/VB

COMCTL32.OCX

ImageList

Internet Transfer*

net

ODE/VB

MSINET.OCX

Inet

Key Status

key

VB

KEYSTA32.OCX

MhState

List View

lvw

ODE/VB

COMCTL32.OCX

ListView

MAPI Message

mpm

VB

MSMAPI32.OCX

MAPIMessage

MAPI Session

mps

VB

MSMAPI32.OCX

MAPISession

Masked Edit

msk

VB

MSMASK32.OCX

MaskEdBox

Multimedia Control

mci

VB

MCI32.OCX

MMControl

Outline

out

VB

MSOUTL32.OCX

Outline

Picture Clip

clp

VB

PICCLP32.OCX

PictureClip

Kwery Preview

kpvw

Kwery

KCPRVW32.OCX

KCPreview

Progress Bar

pbr

ODE/VB

COMCTL32.OCX

ProgressBar

Remote Data

rdc

VB

MSRDC20.OCX

MSRDC

Rich Text Box

rtf

ODE/VB

RICHTX32.OCX

RichTextBox

Slider

sld

ODE/VB

COMCTL32.OCX

Slider

Spin Button

spn

VB

SPIN32.OCX

SpinButton

Status Bar

sbr

ODE/VB

COMCTL32.OCX

StatusBar

SysInfo*

ifo

VB

SYSINFO.OCX

SysInfo

Tab

tab

VB

TABCTL32.OCX

SSTab

Tab Strip

tsp

ODE/VB

COMCTL32.OCX

TabStrip

Toolbar

tbr

ODE/VB

COMCTL32.OCX

Toolbar

Tree View

tvw

ODE/VB

COMCTL32.OCX

TreeView

UpDown*

udn

ODE/VB

COMCT232.OCX

UpDown

WebBrowser*

web

IE/VB

SHDOCVW.DLL

Explorer

Kwery Wheel

kwhl

Kwery

KCWHL32.OCX

KCWheel

Winsock*

sck

ODE/VB

MSWINSCK.OCX

Winsock

* These items are new in Office 97 or Visual Basic 5.

Tags for Binder Objects

Office Binder objects are exposed to Automation via the type library MSBDR8.OLB.

Table C.3 Tags for Office Binder Objects

Object or item

In Typelib

Tag

Comment

Binder

x

bnd

Automation entry point

OfficeBinder


bnd

Automation entry point

PageSetup

x

pgs

New in 97

Section(s)

x

sec(s)


Tags for Data Access Objects

Jet's Data Access Objects hierarchy can be programmed to provide database services via its type library DAO350.DLL.

LNC does not recommend table field tags but provides them here as a convenience for developers who use them. See Chapter 6, "Leszynski Naming Conventions for Access," for more information on field tags.

Table C.4 Tags for Data Access Objects

Object or item

In Typelib

Tag

Comment

AutoNumber (Random Non-sequential)


idn

Field

AutoNumber (Replication ID)


idr

Field

AutoNumber (Sequential)


ids

Field

Binary


bin

Field

Byte


byt

Field

Connection(s)

x

cnc(s)

New in 97

Container(s)

x

con(s)


Currency


cur

Field

DAO


dao

Automation entry point

Database (Btrieve)


dbtv


Database (dBASE)


ddbf


Database (Excel)


dxls


Database (FoxPro)


dfox


Database (Jet)


djet


Database (Lotus 1-2-3)


dwks


Database (ODBC)


dodb


Database (Paradox)


dpdx


Database (SQL Server)


dsql


Database (Text)


dtxt


Database(s)

x

dbs(s)


Date/Time


dtm

Field

DBEngine

x

dbe

Automation entry point

Document(s)

x

doc(s)


Double


dbl

Field

Dynaset


dyn


Error(s)

x

err(s)


Field(s)

x

fld(s)


Group(s)

x

gru(s)


Hyperlink

x

hlk

Field

Index(es)

x

idx(s)


Integer


int

Field

Long


lng

Field

Memo


mem

Field

Ole


ole

Field

Parameter(s)

x

prm(s)


Property(ies)

x

prp(s)


QueryDef (Btrieve)


qbtv


QueryDef (dBASE)


qdbf


QueryDef (Excel)


qxls


QueryDef (FoxPro)


qfox


QueryDef (Jet)


qjet


QueryDef (Lotus 1-2-3)


qwks


QueryDef (ODBC)


qodb


QueryDef (Paradox)


qpdx


QueryDef (SQL Server)


qsql


QueryDef (Text)


qtxt


QueryDef(s)

x

qdf(s)


Recordset (Btrieve)


rbtv


Recordset (dBASE)


rdbf


Recordset (Excel)


rxls


Recordset (FoxPro)


rfox


Recordset (Lotus 1-2-3)


rwks


Recordset (ODBC)


rodb


Recordset (Paradox)


rpdx


Recordset (SQL Server)


rsql


Recordset (text)


rtxt


Recordset(s)

x

rst(s)


Relation(s)

x

rel(s)


Single


sng

Field

Snapshot


snp


TableDef (Btrieve)


tbtv


TableDef (dBASE)


tdbf


TableDef (Excel)


txls


TableDef (FoxPro)


tfox


TableDef (Jet)


tjet


TableDef (Lotus 1-2-3)


twks


TableDef (ODBC)


todb


TableDef (Paradox)


tpdx


TableDef (SQL Server)


tsql


TableDef (Text)


ttxt


TableDef(s)

x

tdf(s)


Text (Character)


chr

Field

User(s)

x

usr(s)


Workspace(s)

x

wsp(s)


Yes/No (Boolean)


bln

Field

Tags for Excel Objects

Excel has a robust object model as exposed in the type library EXCEL8.OLB.

Table C.5 Tags for Excel Objects

Object or item

In Typelib

Tag

Comment

AddIn(s)

x

add(s)


Adjustments

x

adjs

New in 97

Application

x

app

Automation entry point

Arc(s)


arc(s)

Moved to Shape object in 97

Areas

x

ares


AutoCorrect

x

<n/t>


Axis(Axes)

x

axs(s)


AxisTitle

x

<n/t>


Border(s)

x

bdr(s)


Button(s)


cmd(s)

Moved to Shape object in 97

CalculatedFields

x

clfs

New in 97

CalculatedItems

x

clis

New in 97

CalloutFormat

x

<n/t>

New in 97

Characters

x

chrs


Chart(s)

x

cht(s)

Automation entry point

ChartArea

x

<n/t>


ChartColorFormat

x

<n/t>

New in 97

ChartFillFormat

x

<n/t>

New in 97

ChartGroup(s)

x

chg(s)


ChartObject(s)

x

cho(s)


ChartTitle

x

<n/t>


CheckBox(es)


chk(s)


ColorFormat

x

<n/t>

New in 97

Comment(s)

x

cmt(s)

New in 97

ConnectorFormat

x

<n/t>

New in 97

ControlFormat

x

<n/t>

New in 97

Corners

x

<n/t>


CustomView(s)

x

cvw(s)

New in 97

DataLabel(s)

x

dlb(s)


DataTable

x

dtb

New in 97

Debug


<n/t>


Dialog(s)

x

dlg(s)


DialogFrame


<n/t>


DialogSheet(s)


dls(s)


DocumentProperty(ies)


dcp(s)


DownBars

x

<n/t>


Drawing(s)


drw(s)

Moved to Shape object in 97

DrawingObjects


dros


DropDown(s)


cbo(s)


DropLines

x

<n/t>


EditBox(s)


edt(s)


ErrorBars

x

<n/t>


Excel


xls

Automation entry point

FillFormat

x

<n/t>

New in 97

Floor

x

<n/t>


Font

x

fnt


FormatCondition(s)

x

fmc(s)

New in 97

FreeformBuilder

x

<n/t>

New in 97

Gridlines

x

<n/t>


GroupBox(es)


grp(s)


GroupObject(s)


gro(s)


GroupShapes

x

<n/t>

New in 97

HiLoLines

x

<n/t>


HPageBreak(s)

x

hbk(s)

New in 97

Hyperlink

x

hlk

New in 97

Interior

x

<n/t>


Label(s)


lbl(s)


LeaderLines

x

<n/t>

New in 97

Legend

x

lgd


LegendEntry(ies)

x

lge(s)


LegendKey

x

lgk


Line(s)


lin(s)

Moved to Shape object in 97

LineFormat

x

<n/t>

New in 97

LinkFormat

x

<n/t>

New in 97

ListBox(es)


lst(s)


Mailer

x

<n/t>

New in 97

Menu(s)


mnu(s)


MenuBar(s)


mnb(s)


MenuItem(s)


mni(s)


Module(s)


bas(s)


Name(s)

x

nam(s)


Object


obj


ODBCError(s)

x

err(s)

New in 97

OLEFormat

x

<n/t>

New in 97

OLEObject(s)

x

ole(s)


OptionButton(s)


opt(s)


Outline

x

out


Oval(s)


ovl(s)

Moved to Shape object in 97

PageSetup

x

pgs


Pane(s)

x

pan(s)


Parameter(s)

x

prm(s)

New in 97

Phonetic

x

<n/t>

New in 97

Picture(s)


pic(s)


PictureFormat

x

<n/t>

New in 97

PivotCache(s)

x

<n/t>

New in 97

PivotField(s)

x

pvf(s)


PivotFormula(s)

x

<n/t>

New in 97

PivotItem(s)

x

pvi(s)


PivotTable(s)

x

pvt(s)


PlotArea

x

<n/t>


Point(s)

x

pnt(s)


QueryTable(s)

x

tbl(s)

New in 97

Range

x

rng


RecentFile(s)

x

mru(s)

New in 97

Rectangle(s)


shp(s)

Moved to Shape object in 97

RoutingSlip

x

<n/t>


Scenario(s)

x

sce(s)


ScrollBar(s)


scb(s)


Series

x

ser


SeriesCollection

x

sers


SeriesLines

x

<n/t>


ShadowFormat

x

<n/t>

New in 97

Shape(s)

x

shp(s)

New in 97

ShapeNode(s)

x

nod(s)

New in 97

ShapeRange

x

<n/t>

New in 97

Sheet


sht

Automation entry point

Sheets

x

shts


SoundNote

x

<n/t>


Spinner(s)


spn(s)


Style(s)

x

sty(s)


TextBox(es)


txt(s)

Moved to Shape object in 97

TextEffectFormat

x

<n/t>

New in 97

TextFrame

x

<n/t>

New in 97

ThreeDFormat

x

<n/t>

New in 97

TickLabels

x

<n/t>


Toolbar(s)


tbr(s)


ToolbarButton(s)


btn(s)


Trendline(s)

x

tnd(s)


UpBars

x

<n/t>


Validation

x

vld

New in 97

VPageBreak(s)

x

vbk(s)

New in 97

Walls

x

<n/t>


Window(s)

x

wnd(s)


Workbook(s)

x

wkb(s)


Worksheet(s)

x

wks(s)


WorksheetFunction

x

<n/t>

New in 97

Tags for Forms Objects

The new MSForms engine provides form services to Excel, Outlook, PowerPoint, and Word. Its object model is exposed in the type library FM20.DLL.

Table C.6 Tags for Forms Objects

Object or item

In Typelib

Tag

Comment

CheckBox

x

chk

New in 97

ComboBox

x

cbo

New in 97

CommandButton

x

cmd

New in 97

Control(s)

x

ctl(s)

New in 97

DataObject

x

doj

New in 97,Automation entry point

Frame

x

fra

New in 97

HTMLCheckBox

x

hchk

New in 97

HTMLHidden

x

<n/t>

New in 97

HTMLImage

x

himg

New in 97

HTMLOption

x

<n/t>

New in 97

HTMLPassword

x

hpwd

New in 97

HTMLReset

x

<n/t>

New in 97

HTMLSelect

x

<n/t>

New in 97

HTMLSubmit

x

<n/t>

New in 97

HTMLText

x

htxt

New in 97

HTMLTextArea

x

<n/t>

New in 97

Image

x

img

New in 97

Label

x

lbl

New in 97

ListBox

x

lst

New in 97

MSForms


fms

New in 97, Automation entry point

MultiPage

x

<n/t>

New in 97

NewFont

x

<n/t>

New in 97

OptionButton

x

opt

New in 97

Page(s)

x

pge(s)

New in 97

ReturnBoolean

x

rbln

New in 97

ReturnEffect

x

<n/t>

New in 97

ReturnInteger

x

rint

New in 97

ReturnSingle

x

rsng

New in 97

ReturnString

x

rstr

New in 97

ScrollBar

x

scb

New in 97

SpinButton

x

spn

New in 97

Tab(s)

x

tab(s)

New in 97

TabStrip

x

tsp

New in 97

TextBox

x

txt

New in 97

ToggleButton

x

tgl

New in 97

UserForm


ufm

New in 97,Automation entry point

Tags for Graph Objects

Graph can be automated from Access, Excel, and other applications by calling its type library GRAPH8.OlB.

Table C.7 Tags for Graph Objects

Object or item

In Typelib

Tag

Comment

Application

x

app

Automation entry point

AutoCorrect

x

<n/t>

New in 97

Axis(Axes)

x

axs(s)


AxisTitle

x

<n/t>


Border

x

bdr


Chart

x

cht


ChartArea

x

<n/t>


ChartColorFormat

x

<n/t>

New in 97

ChartFillFormat

x

<n/t>

New in 97

ChartGroup(s)

x

chg(s)


ChartTitle

x

<n/t>


Corners

x

<n/t>


DataLabel(s)

x

dlb(s)


DataSheet

x

<n/t>

New in 97

DataTable

x

<n/t>

New in 97

DownBars

x

<n/t>


DropLines

x

<n/t>


ErrorBars

x

<n/t>


Floor

x

<n/t>


Font

x

fnt


Graph


gph

Automation entry point

Gridlines

x

<n/t>


HiLoLines

x

<n/t>


Interior

x

<n/t>


LeaderLines

x

<n/t>

New in 97

Legend

x

lgd


LegendEntry(ies)

x

lge(s)


LegendKey

x

lgk


PlotArea

x

<n/t>


Point(s)

x

pnt(s)


Range

x

rng

New in 97

Series

x

ser


SeriesCollection

x

sers


SeriesLines

x

<n/t>


TickLabels

x

<n/t>


Trendline(s)

x

tnd(s)


UpBars

x

<n/t>


Walls

x

<n/t>


Tags for OLE Messaging (MAPI) Objects

MAPI mail services are exposed in the type library MDISP32.TLB.

Table C.8 Tags for OLE Messaging Objects

Object or item

In Typelib

Tag

Comment

AddressEntry

x

<n/t>


Attachment(s)

x

att(s)


Field(s)

x

fld(s)


Folder(s)

x

fdr(s)


Inbox(es)


ibx(s)


InfoStore(s)

x

inf(s)


MAPI


mpi

Automation entry point

Message(s)

x

mpm(s)


Outbox(es)


obx(s)


Recipient(s)

x

rcp(s)


Sessions(s)


mps(s)

Automation entry point

Tags for Office Objects

Office 97 ships with a type library MSO97.DLL that provides common components that can be used from each of the Office applications.

Table C.9 Tags for Office Objects

Object or item

In Typelib

Tag

Comment

Assistant

x

ast

New in 97

Balloon

x

bal

New in 97

BalloonCheckbox(es)

x

chk(s)

New in 97

BalloonLabel(s)

x

lbl(s)

New in 97

CommandBar(s)

x

cbr(s)

New in 97

CommandBarButton

x

btn

New in 97

CommandBarComboBox

x

cbo

New in 97

CommandBarControl(s)

x

ctl(s)

New in 97

CommandBarPopup

x

pop

New in 97

DocumentProperty(ies)

x

dcp(s)

New in 97

FileSearch

x

fsh

New in 97

FoundFiles

x

fnf

New in 97

IFind

x

<n/t>

New in 97

IFoundFiles

x

<n/t>

New in 97

Menu bar


mbr

As command bar

Office


ofc

New in 97, Automation entry point

PropertyTest(s)

x

tst(s)

New in 97

Shortcut menu


mct

As command bar

Submenu (drop-down)


msb

As command bar

Toolbar


tbr

As command bar

Tags for Outlook Objects

The new time management and messaging functions of Outlook are exposed in the type library MSOUTL8.OLB.

Table C.10 Tags for Outlook Objects

Object or item

In Typelib

Tag

Comment

Action(s)

x

act(s)

New in 97

Application

x

app

New in 97, Automation entry point

AppointmentItem

x

apt

New in 97

Attachment(s)

x

att(s)

New in 97

ContactItem

x

ctc

New in 97

Explorer

x

xpl

New in 97

Folders

x

fdrs

New in 97

FormDescription

x

frd

New in 97

Inspector

x

ins

New in 97

Items

x

itm

New in 97

JournalItem

x

jnl

New in 97

MailItem

x

mal

New in 97

MAPIFolder

x

mpf

New in 97

MeetingRequestItem

x

mtg

New in 97

NameSpace

x

nsp

New in 97

NoteItem

x

not

New in 97

Outlook


otl

New in 97, Automation entry point

Pages

x

pge

New in 97

PostItem

x

pst

New in 97

Recipient(s)

x

rcp(s)

New in 97

RecurrencePattern

x

pat

New in 97

RemoteItem

x

rem

New in 97

ReportItem

x

rpt

New in 97

TaskItem

x

tsk

New in 97

TaskRequestItem

x

tri

New in 97

UserProperty(ies)

x

usp(s)

New in 97

Tags for PowerPoint Objects

For 97, PowerPoint exposes its VBA programming engine and a rich object model as specified in the type library MSPPT8.OLB.

Table C.11 Tags for PowerPoint Objects


Object or item

In Typelib

Tag

Comment

ActionSetting(s)

x

acs(s)

New in 97

AddIn(s)

x

add(s)

New in 97

Adjustments

x

adjs

New in 97

AnimationSettings

x

<n/t>

New in 97

Application

x

app

Automation entry point

ApplicationWindow


awnd


Bitmap


bmp


BitmapButton


bmb


BuildEffects


<n/t>


BulletFormat

x

<n/t>


CalloutFormat

x

<n/t>

New in 97

CharFormat


<n/t>


CheckBox(es)


chk(s)


Clipboard


<n/t>


Collection


col


Color


clr


ColorFormat

x

<n/t>

New in 97

ColorScheme(s)

x

sch(s)

New in 97

ConnectorFormat

x

<n/t>

New in 97

Control(s)


ctl(s)


Dialog(s)


dlg(s)


DocSchemeColors


<n/t>


DocumentWindow(s)

x

dwnd(s)


DropDown(s)


cbo


ExtraColors

x

<n/t>


FillFormat

x

<n/t>


FitText


<n/t>


Font(s)

x

fnt(s)

New in 97

FontInfo(s)


fni(s)


FreeformBuilder

x

<n/t>

New in 97

GraphicFormat


<n/t>


GroupShapes

x

<n/t>

New in 97

HeaderFooter(s)

x

hdf(s)


Hyperlink(s)

x

hlk(s)

New in 97

LineFormat

x

<n/t>


LineSpacing


<n/t>


LineSpacingSet


<n/t>


LinkFormat

x

<n/t>

New in 97

Master

x

<n/t>

New in 97

Menu(s)


mnu(s)


NamedSlideShow(s)

x

shw(s)

New in 97

ObjectVerbs

x

<n/t>

New in 97

OLEFormat

x

<n/t>

New in 97

PageSetup

x

pgs

New in 97

ParaFormat


<n/t>


ParagraphFormat

x

ppf

New in 97

PictureFormat

x

<n/t>

New in 97

PlaceholderFormat

x

<n/t>

New in 97

Placeholders

x

<n/t>


PlayOptions


<n/t>


PlayOptionsVerbs


<n/t>


PlaySettings

x

<n/t>

New in 97

Popup(s)


pop(s)


PowerPoint


ppt

Automation entry point

Presentation(s)

x

psn(s)


PrintOptions

x

pro


PrintRange(s)

x

prr(s)


RGBColor

x

<n/t>

New in 97

Ruler

x

<n/t>


RulerLevel(s)

x

rlv(s)


SchemeColors


<n/t>


Selection

x

sel


ShadowFormat

x

<n/t>


Shape(s)

x

shp(s)

New in 97

ShapeNode(s)

x

nod(s)

New in 97

ShapeRange

x

<n/t>

New in 97

Slide(s)

x

sli(s)


SlideObject(s)


slo(s)


SlideRange

x

slr

New in 97

SlideShow


sls


SlideShowEffects


<n/t>


SlideShowSettings

x

<n/t>

New in 97

SlideShowTransition

x

<n/t>

New in 97

SlideShowView

x

<n/t>


SlideShowWindow(s)

x

<n/t>


SoundEffect

x

<n/t>


SoundNote


<n/t>


Sounds


snds


TabSheet(s)


tbt(s)


TabStop(s)

x

tbs(s)


Tags

x

tags

New in 97

Text


<n/t>


TextBounds


<n/t>


TextEffectFormat

x

<n/t>

New in 97

TextFrame

x

<n/t>

New in 97

TextRange

x

<n/t>


TextStyle(s)

x

txs(s)


TextStyleLevel(s)

x

txl(s)


ThreeDFormat

x

<n/t>

New in 97

View

x

vew


Tags for Project Objects

Project version 4.x is programmable via its type library PJ4EN32.OLB.

Table C.12 Tags for Project Objects

Object or item

In Typelib

Tag

Application

x

app

Assignment(s)

x

asn(s)

Calendar(s)

x

cal(s)

Cell

x

cel

Day(s)

x

day(s)

List

x

lis

Month(s)

x

mon(s)

MSProject


prj

Pane(s)

x

pan(s)

Period

x

prd

Project(s)

x

prj(s)

Resource(s)

x

res(s)

Selection

x

sel

Shift

x

sft

Task(s)

x

tsk(s)

Weekday(s)

x

wdy(s)

Window(s)

x

wnd(s)

Year(s)

x

yer(s)

Tags for Remote Data Objects

Remote Data Objects, once a servant of Visual Basic, can now be automated from any Office application by using the type library MSRDO20.DLL.

Table C.13 Tags for Remote Data Objects

Object or item

In Typelib

Tag

Comment

RDO


rdo

Automation entry point

rdoColumn(s)

x

rdclm(s)


rdoConnection(s)

x

rdcnn(s)


rdoEngine

x

rdeng


rdoEnvironment(s)

x

rdenv(s)


rdoError(s)

x

rderr(s)


rdoParameter(s)

x

rdprm(s)


rdoPreparedStatement(s)


rdprs(s)


rdoQuery(ies)

x

rdqry(s)

New in 97

rdoResultset(s)

x

rdrsl(s)


rdoTable(s)

x

rdtbl(s)


Tags for SQL Server Objects

The type library SQLOLE65.TLB allows for programmatic access to the database engine and other features of SQL Server.

LNC does not recommend table field tags but provides them here as a convenience for developers who use them. See Chapter 6, "Leszynski Naming Conventions for Access," for more information on field tags.

Table C.14 Tags for SQL Server Objects

Object or item

In Typelib

Tag

Comment

Alert(s)

x

alt(s)


AlertSystem

x

als(s)


Application

x

app


Article(s)

x

art(s)


Backup

x

bkp(s)


BackupSink

x

<n/t>

New in 97

Binary


bin

Field

Bit


bln

Field

BulkCopy

x

<n/t>

New in 97

BulkCopySink

x

<n/t>

New in 97

Character


chr

Field

Check(s)

x

cck(s)


Column(s)

x

clm(s)


Configuration(s)

x

cfg(s)


ConfigValue(s)

x

cfv(s)


Constraint


cst


Constraint (Check)


cstc


Constraint (Default)


cstd


Constraint (Foreign Key)


cstf


Constraint (Primary Key)


cstp


Constraint (Unique)


cstu


Database(s)

x

dbs(s)


DateTime


dtm

Field

DBObject(s)

x

dob(s)


DBOption(s)

x

dop(s)


Decimal


dec

Field

Default(s)

x

def(s)


Device(s)

x

dev(s)


DRIDefault(s)

x

dri(s)


Executive

x

exv


Float


dbl

Field

Group(s)

x

gru(s)


HistoryFilter

x

hfl(s)


Image


ole

Field

Index(es)

x

idx


Integer


lng

Field

IntegratedSecurity(ies)

x

isc(s)


Key(s)

x

key(s)


Language(s)

x

lgg(s)


Login(s)

x

lgi(s)


Money


cur

Field

Names

x

nams


Numeric


num

Field

Operator(s)

x

opr(s)


Parameter*


v[prm]

See footnote

Parameter (output)*


r[prm]

See footnote

Permission

x

pms(s)


Property(ies)

x

prp(s)


Publication(s)

x

pub(s)


QueryResult(s)

x

qrs(s)


Real


sng

Field

RegisteredServer(s)

x

rgs(s)

New in 97

Registry(ies)

x

reg(s)


RemoteLogin(s)

x

rlg(s)

New in 97

RemoteServer(s)

x

rsv(s)


Rule(s)

x

rul(s)


Server(s)

x

srv

Automation entry point

ServerGroup(s)

x

svg(s)

New in 97

ServerSink

x

<n/t>

New in 97

SmallDateTime


sdt

Field

SmallInt


int

Field

SmallMoney


smn

Field

SQLObjectList

x

<n/t>

New in 97

SQLOLE

x

sql

Automation entry point

Stored Procedure(s)

x

prc(s)


Stored Procedure (Extended)


prcx


SubscriberInfo

x

<n/t>


Subscription(s)

x

<n/t>

New in 97

SysName


sys

Field

SystemDatatype(s)

x

dtp(s)

New in 97

Table(s)

x

tbl(s)


Task(s)

x

tsk(s)


Text


mem

Field

TimeStamp


tim

Field

TinyInt


tny

Field

TransactionLog

x

<n/t>


Transfer

x

<n/t>

New in 97

Trigger(s)

x

trg(s)


User(s)

x

usr


UserDefinedDatatype(s)

x

udt(s)

New in 97

VarBinary


vbr

Field

VarChar


vcr

Field

View(s)

x

qry(s)


* [prm] represents a stored procedure parameter name. Parameters declared with the OUTPUT keyword are similar to ByRef arguments in VBA, while those without OUTPUT are similar to ByVal.

Tags for Team Manager Objects

Team Manager's object model is exposed via the type library file MSTMGR1.OLB.

Beginning with Office 97, you can use Team Manager and Outlook instead of Project for many time management functions.

Table C.15 Tags for Team Manager Objects

Object or item

In Typelib

Tag

Comment

Application

x

app

New in 97, Automation entry point

Assignment(s)

x

asn(s)

New in 97

Calendar(s)

x

cal(s)

New in 97

Cell

x

cel

New in 97

CurrentView

x

rvw

New in 97

CustomField(s)

x

cfl(s)

New in 97

File

x

fil

New in 97

Filter(s)

x

flt(s)

New in 97

Goal(s)

x

gol(s)

New in 97

Notebook

x

nbk

New in 97

Notes

x

nots

New in 97

People

x

ppl

New in 97

Period

x

prd

New in 97

Person

x

per

New in 97

Selection

x

sel

New in 97

Shift(s)

x

sft(s)

New in 97

SupportingTask(s)

x

sts(s)

New in 97

Task(s)

x

tsk(s)

New in 97

TeamManager


mgr

New in 97, Automation entry point

View(s)

x

vew(s)

New in 97

Window

x

wnd

New in 97

Tags for Visual Basic Objects

Visual Basic 5 is Access's big brother, with a host of features for serious developers. The type library VB5.OLB exposes a map of the objects within VB.

Table C.16 Tags for Visual Basic Objects

Object or item

In Typelib

Tag

Comment

AddInManager


add


AmbientProperties

x

<n/t>

New in 97

App

x

app


Application


app


AsyncProperty

x

<n/t>

New in 97

Button(s)


btn(s)


CheckBox

x

chk

Form control

ClassModule


cls


Clipboard

x

<n/t>


Collection


col


Column(s)


clm(s)


ColumnHeader(s)


chd(s)


ComboBox

x

cbo

Form control

CommandButton

x

cmd

Form control

Component(s)


cmp(s)


ContainedControls

x

cocs

New in 97

Control(s)

x

ctl(s)


ControlTemplate(s)


ctp(s)


Data

x

dat

Form control

DataBinding(s)

x

dbd(s)

New in 97

DataObject

x

<n/t>

New in 97

DataObjectFiles

x

<n/t>

New in 97

Debug


<n/t>


DirListBox

x

dir

Form control

DriveListbox

x

drv

Form control

Err


<n/t>


FileControl


flc


FileListBox

x

fil

Form control

Font


fnt


Form (dialog)


fdlg


Form (lookup table)


flkp


Form (menu)


fmnu


Form (message/alert)


fmsg


Form (wizard main)


fwzs


Form (wizard subform)


fwzm


Form(s)

x

frm(s)


FormTemplate


ftpl


Frame

x

fra

Form control

Global

x

gbl

New in 97

HScrollBar

x

hsb

Form control

Hyperlink

x

hlk

New in 97

Image

x

img

Form control

Label

x

lbl

Form control

Line

x

lin

Form control

ListBox

x

lst

Form control

ListImage(s)


lim(s)


ListItem(s)


lit(s)


MDI child form


fmdc


MDIForm

x

fmdi


Menu

x

mnu

Form control

Menu (shortcut)


mct


MenuItem(s)


mni(s)


MenuLine


mnl


Module(s)


bas(s)


Node(s)


nod(s)


OLE

x

ole


OLEContainer


ole

Form control

OptionButton

x

opt

Form control

ParentControls

x

<n/t>

New in 97

Pen BEdit


bed

Form control

Pen HEdit


hed

Form control

Pen Ink


ink

Form control

Pen Keyboard


pky

Form control

Picture(s)


pic


PictureBox

x

pic

Form control

Printer(s)

x

prn(s)


ProjectTemplate


tpl


Property(ies)


prp(s)


PropertyBag

x

bag

New in 97

PropertyPage

x

<n/t>

New in 97

RowBuffer


row


Screen

x

scn


SelBookmarks


sbk(s)


SelectedComponents


scms


SelectedControls

x

scts


Shape

x

shp

Form control

SubMenu


msub


TextBox

x

txt

Form control

Timer

x

tmr

Form control

UserControl

x

<n/t>

New in 97

UserDocument

x

<n/t>

New in 97

VB


vbp

Automation entry point

VScrollBar

x

vsb

Form control

Tags for Visual Basic Development Environment Objects

The IDE (Integrated Development Environment) or VBEditor for Visual Basic and Visual Basic for Applications (sans Access) can be programmed via type library calls to VB5EXT.OLB for Visual Basic and VBEEXT1.OLB for Office applications. This allows for the creation of wizards and other tools.

In the following table, an x in the In Typelib column means that the class applies to both type libraries, while items marked with * are exposed only from the Visual Basic version of the type library.

Table C.17 Tags for Visual Basic IDE Objects

Object or item

In Typelib

Tag

Comment

AddIn(s)

*

add(s)

New in 97

CodeModule

x

<n/t>

New in 97

CodePane(s)

x

cpn(s)

New in 97

CommandBarEvents

x

<n/t>

New in 97

ContainedVBControls

*

cvcs

New in 97

Events

x

<n/t>

New in 97

FileControlEvents

*

<n/t>

New in 97

IDTExtensibility

*

<n/t>

New in 97

LinkedWindows

x

<n/t>

New in 97

Member(s)

*

mbr(s)

New in 97

Property(ies)

x

prp(s)

New in 97

Reference(s)

x

ref(s)

New in 97

ReferencesEvents

x

<n/t>

New in 97

RelatedDocument(s)

*

red(s)

New in 97

SelectedVBControls

*

sevs

New in 97

SelectedVBControlsEvents

*

<n/t>

New in 97

VBComponent(s)

x

cmp(s)

New in 97

VBComponentsEvents

*

<n/t>

New in 97

VBControl(s)

*

vbc(s)

New in 97

VBControlsEvents

*

<n/t>

New in 97

VBE

x

<n/t>

New in 97

VBForm

*

<n/t>

New in 97

VBIDE


ide

New in 97, Automation entry point

VBNewProjects

*

<n/t>

New in 97

VBProject(s)

x

vbp(s)

New in 97

VBProjectsEvents

*

<n/t>

New in 97

Window(s)

x

wnd(s)

New in 97

Tags for VBA Objects

Access and other Office applications can make use of the Collection object and others stored in the VBA engine VBA332.DLL.

Table C.18 Tags for VBA Objects

Object or item

In Typelib

Tag

Comment

Collection

x

col

New in 97

ErrObject

x

err

New in 97

Global

x

gbl

New in 97

VBA


vba

Automation entry point

Tags for Word Objects

Word now boasts a complex object model, defined in the type library MSWORD8.OLB.

Table C.19 Tags for Word Objects

Object or item

In Typelib

Tag

Comment

AddIn(s)

x

add(s)

New in 97

Adjustments

x

adjs

New in 97

Application

x

app

New in 97, Automation entry point

AutoCaption(s)

x

acp(s)

New in 97

AutoCorrect

x

<n/t>

New in 97

AutoCorrectEntry(ies)

x

ace(s)

New in 97

AutoTextEntry(ies)

x

ate(s)

New in 97

Bookmark(s)

x

bmk(s)

New in 97

Border(s)

x

bdr(s)

New in 97

Browser

x

<n/t>

New in 97

CalloutFormat

x

<n/t>

New in 97

CaptionLabel(s)

x

cla(s)

New in 97

Cell(s)

x

cel(s)

New in 97

Characters

x

chrs

New in 97

CheckBox

x

chk

New in 97

ColorFormat

x

<n/t>

New in 97

Column(s)

x

clm(s)

New in 97

Comment(s)

x

cmt(s)

New in 97

Conflict(s)

x

cnf(s)

New in 97

CustomLabel(s)

x

clb(s)

New in 97

Dialog(s)

x

dlg(s)

New in 97

Dictionary(ies)

x

dic(s)

New in 97

Document(s)

x

doc(s)

New in 97

DropCap

x

<n/t>

New in 97

DropDown

x

<n/t>

New in 97

Endnote(s)

x

end(s)

New in 97

Envelope

x

<n/t>

New in 97

Field(s)

x

fld(s)

New in 97

FileConverter(s)

x

cnv(s)

New in 97

FillFormat

x

<n/t>

New in 97

Find

x

fnd

New in 97

FirstLetterException(s)

x

fle(s)

New in 97

Font

x

fnt

New in 97

FontNames

x

<n/t>

New in 97

Footnote(s)

x

fot(s)

New in 97

FormField(s)

x

fld(s)

New in 97

Frame(s)

x

fra(s)

New in 97

FreeformBuilder

x

<n/t>

New in 97

Global

x

gbl

New in 97

GroupShapes

x

<n/t>

New in 97

HeaderFooter(s)

x

hdf(s)

New in 97

HeadingStyle(s)

x

hds(s)

New in 97

Hyperlink(s)

x

hlk(s)

New in 97

Index(es)

x

idx(s)

New in 97

InlineShape(s)

x

ils(s)

New in 97

KeyBinding(s)

x

kyb(s)

New in 97

KeysBoundTo

x

<n/t>

New in 97

Language(s)

x

lgg(s)

New in 97

LetterContent

x

<n/t>

New in 97

LineFormat

x

<n/t>

New in 97

LineNumbering

x

<n/t>

New in 97

LinkFormat

x

<n/t>

New in 97

List(s)

x

lis(s)

New in 97

ListEntry(ies)

x

len(s)

New in 97

ListFormat

x

<n/t>

New in 97

ListGallery(ies)

x

lgy(s)

New in 97

ListLevel(s)

x

llv(s)

New in 97

ListParagraphs

x

lpps

New in 97

ListTemplate(s)

x

ltp(s)

New in 97

Mailer

x

<n/t>

New in 97

MailingLabel

x

mlb

New in 97

MailMerge

x

mmg

New in 97

MailMergeDataField(s)

x

mmd(s)

New in 97

MailMergeDataSource

x

mms

New in 97

MailMergeField(s)

x

mmf(s)

New in 97

MailMergeFieldName(s)

x

mmn(s)

New in 97

MailMessage

x

msg

New in 97

OLEFormat

x

<n/t>

New in 97

Options

x

opns

New in 97

PageNumber(s)

x

pgn(s)

New in 97

PageSetup

x

pgs

New in 97

Pane(s)

x

pan(s)

New in 97

Paragraph

x

ppg

New in 97

ParagraphFormat

x

ppf

New in 97

ProofreadingErrors

x

<n/t>

New in 97

Range

x

rng

New in 97

ReadabilityStatistic(s)

x

stt(s)

New in 97

RecentFile(s)

x

mru(s)

New in 97

Replacement

x

<n/t>

New in 97

Revision(s)

x

rev(s)

New in 97

RoutingSlip

x

<n/t>

New in 97

Row(s)

x

row(s)

New in 97

Section(s)

x

sec(s)

New in 97

Selection

x

sel

New in 97

Sentences

x

sens

New in 97

Shading

x

<n/t>

New in 97

ShadowFormat

x

<n/t>

New in 97

Shape(s)

x

shp(s)

New in 97

ShapeNode(s)

x

nod(s)

New in 97

ShapeRange

x

<n/t>

New in 97

SpellingSuggestion(s)

x

sug(s)

New in 97

StoryRanges

x

srgs

New in 97

Style(s)

x

sty(s)

New in 97

Subdocument(s)

x

dsb(s)

New in 97

SynonymInfo

x

syn

New in 97

System

x

sys

New in 97

Table

x

tbw

New in 97

TableOfAuthorities

x

tba

New in 97

TableOfAuthoritiesCategories

x

tbg

New in 97

TableOfContents

x

tbc

New in 97

TableOfFigures

x

tbf

New in 97

TabStop(s)

x

tbs(s)

New in 97

Task(s)

x

tsk(s)

New in 97

Template(s)

x

tpl(s)

New in 97

TextColumn(s)

x

tcl(s)

New in 97

TextEffectFormat

x

<n/t>

New in 97

TextFrame

x

<n/t>

New in 97

TextInput

x

<n/t>

New in 97

TextRetrievalMode

x

<n/t>

New in 97

ThreeDFormat

x

<n/t>

New in 97

TwoInitialCapsException(s)

x

tic(s)

New in 97

Users

x

usrs

New in 97

UserStatus

x

<n/t>

New in 97

Variable(s)

x

vbl(s)

New in 97

Version(s)

x

ver(s)

New in 97

View

x

vew

New in 97

Windows(s)

x

wnd(s)

New in 97

Word


wrd

Automation entry point

Words

x

wrds

New in 97

WrapFormat

x

<n/t>

New in 97

Zoom(s)

x

zom(s)

New in 97


1996, QUE Corporation, an imprint of Macmillan Publishing USA, a Simon and Schuster Company.