OldConstants Enumeration (Access)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Name

Value

Description

A_ADD

0

A_ALL

0

A_ANYWHERE

0

A_ATTACH

2

A_COPY

3

A_CURRENT

1

A_CUT

2

A_DELETE

6

A_DELETE_V2

7

A_DESIGN

1

A_DIALOG

3

A_DOWN

1

A_DRAFT

3

A_EDIT

1

A_EDITMENU

1

A_ENTIRE

1

A_EXIT

2

A_EXPORT

1

A_EXPORTDELIM

2

A_EXPORTFIXED

3

A_EXPORTMERGE

4

A_FILE

0

A_FIRST

2

A_FORM

2

A_FORMATRTF

A_FORMATTXT

A_FORMATXLS

A_FORMBAR

0

A_FORMDS

3

A_GOTO

4

A_HIDDEN

1

A_HIGH

0

A_ICON

2

A_IMPORT

0

A_IMPORTDELIM

0

A_IMPORTFIXED

1

A_LAST

3

A_LOW

2

A_MACRO

4

A_MEDIUM

1

A_MENU_VER1X

11

A_MENU_VER20

20

A_MODULE

5

A_NEW

0

A_NEWREC

5

A_NEXT

1

A_NORMAL

0

A_OBJECT

14

A_OBJECTUPDATE

3

A_OBJECTVERB

0

A_PAGES

2

A_PASTE

4

A_PREVIEW

2

A_PREVIOUS

0

A_PRINTALL

0

A_PROMPT

0

A_QUERY

1

A_READONLY

2

A_RECORDSMENU

3

A_REFRESH

2

A_REPORT

3

A_SAVE

1

A_SAVEFORM

2

A_SAVEFORMAS

3

A_SAVERECORD

4

A_SELECTALLRECORDS

8

A_SELECTALLRECORDS_V2

9

A_SELECTION

1

A_SELECTRECORD

7

A_SELECTRECORD_V2

8

A_START

2

A_TABLE

0

A_TOOLBAR_NO

2

A_TOOLBAR_WHERE_APPROP

1

A_TOOLBAR_YES

0

A_UNDO

0

A_UNDOFIELD

1

A_UP

0

ALT_MASK

4

CTRL_MASK

2

DATA_ERRADDED

2

DATA_ERRCONTINUE

0

DATA_ERRDISPLAY

1

DB_APPENDONLY

8

DB_ATTACHEDODBC

536870912

DB_ATTACHEDTABLE

1073741824

DB_ATTACHEXCLUSIVE

65536

DB_ATTACHSAVEPWD

131072

DB_AUTOINCRFIELD

16

DB_BINARY

9

DB_BOOLEAN

1

DB_BYTE

2

DB_CONSISTENT

32

DB_CURRENCY

5

DB_DATE

8

DB_DECRYPT

4

DB_DENYREAD

2

DB_DENYWRITE

1

DB_DESCENDING

1

DB_DOUBLE

7

DB_ENCRYPT

2

DB_FAILONERROR

128

DB_FIXEDFIELD

1

DB_FORWARDONLY

256

DB_FREELOCKS

1

DB_HIDDENOBJECT

1

DB_IGNORENULL

8

DB_INCONSISTENT

16

DB_INTEGER

3

DB_LANG_ARABIC

DB_LANG_CYRILLIC

DB_LANG_CZECH

DB_LANG_DUTCH

DB_LANG_GENERAL

DB_LANG_GREEK

DB_LANG_HEBREW

DB_LANG_HUNGARIAN

DB_LANG_ICELANDIC

DB_LANG_NORDIC

DB_LANG_NORWDAN

DB_LANG_POLISH

DB_LANG_SPANISH

DB_LANG_SWEDFIN

DB_LANG_TURKISH

DB_LONG

4

DB_LONGBINARY

11

DB_MEMO

12

DB_NONULLS

3

DB_OLE

11

DB_OPEN_DYNASET

2

DB_OPEN_SNAPSHOT

4

DB_OPEN_TABLE

1

DB_OPTIONINIPATH

1

DB_PRIMARY

2

DB_PROHIBITNULL

4

DB_QACTION

240

DB_QAPPEND

64

DB_QCROSSTAB

16

DB_QDDL

96

DB_QDELETE

32

DB_QMAKETABLE

80

DB_QSELECT

0

DB_QSETOPERATION

128

DB_QSPTBULK

144

DB_QSQLPASSTHROUGH

112

DB_QUERYDEF

5

DB_QUPDATE

48

DB_READONLY

4

DB_RELATIONDELETECASCADE

4096

DB_RELATIONDONTENFORCE

2

DB_RELATIONINHERITED

4

DB_RELATIONLEFT

16777216

DB_RELATIONRIGHT

33554432

DB_RELATIONUNIQUE

1

DB_RELATIONUPDATECASCADE

256

DB_SEC_CREATE

1

DB_SEC_DBCREATE

1

DB_SEC_DBEXCLUSIVE

4

DB_SEC_DBOPEN

2

DB_SEC_DELETE

65536

DB_SEC_DELETEDATA

128

DB_SEC_FRMRPT_EXECUTE

256

DB_SEC_FRMRPT_READDEF

4

DB_SEC_FRMRPT_WRITEDEF

65548

DB_SEC_FULLACCESS

1048575

DB_SEC_INSERTDATA

32

DB_SEC_MAC_EXECUTE

8

DB_SEC_MAC_READDEF

10

DB_SEC_MAC_WRITEDEF

65542

DB_SEC_MOD_READDEF

2

DB_SEC_MOD_WRITEDEF

65542

DB_SEC_NOACCESS

0

DB_SEC_READDEF

4

DB_SEC_READSEC

131072

DB_SEC_REPLACEDATA

64

DB_SEC_RETRIEVEDATA

20

DB_SEC_WRITEDEF

65548

DB_SEC_WRITEOWNER

524288

DB_SEC_WRITESEC

262144

DB_SINGLE

6

DB_SORTARABIC

267

DB_SORTCYRILLIC

263

DB_SORTCZECH

264

DB_SORTDUTCH

259

DB_SORTGENERAL

256

DB_SORTGREEK

269

DB_SORTHEBREW

268

DB_SORTHUNGARIAN

265

DB_SORTICELANDIC

262

DB_SORTNORWDAN

261

DB_SORTPDXINTL

4096

DB_SORTPDXNOR

4098

DB_SORTPDXSWE

4097

DB_SORTPOLISH

266

DB_SORTSPANISH

258

DB_SORTSWEDFIN

260

DB_SORTTURKISH

270

DB_SORTUNDEFINED

-1

DB_SQLPASSTHROUGH

64

DB_SYSTEMOBJECT

-2147483646

DB_TABLE

1

DB_TEXT

10

DB_UNIQUE

1

DB_UPDATABLEFIELD

32

DB_VARIABLEFIELD

2

DB_VERSION10

1

DB_VERSION11

8

DB_VERSION20

16

DELETE_CANCEL

1

DELETE_OK

0

DELETE_USER_CANCEL

2

LB_CLOSE

8

LB_END

9

LB_GETCOLUMNCOUNT

4

LB_GETCOLUMNWIDTH

5

LB_GETFORMAT

7

LB_GETROWCOUNT

3

LB_GETVALUE

6

LB_INITIALIZE

0

LB_OPEN

1

LEFT_BUTTON

1

MIDDLE_BUTTON

4

OBJSTATE_DIRTY

2

OBJSTATE_NEW

4

OBJSTATE_OPEN

1

OLE_CHANGED

0

OLE_CLOSED

2

OLE_RELEASE

5

OLE_RENAMED

3

OLE_SAVED

1

RIGHT_BUTTON

2

SHIFT_MASK

1

SYSCMD_ACCESSDIR

9

SYSCMD_ACCESSVER

7

SYSCMD_CLEARHELPTOPIC

11

SYSCMD_CLEARSTATUS

5

SYSCMD_GETOBJECTSTATE

10

SYSCMD_INIFILE

8

SYSCMD_INITMETER

1

SYSCMD_REMOVEMETER

3

SYSCMD_RUNTIME

6

SYSCMD_SETSTATUS

4

SYSCMD_UPDATEMETER

2

V_CURRENCY

6

V_DATE

7

V_DOUBLE

5

V_EMPTY

0

V_INTEGER

2

V_LONG

3

V_NULL

1

V_SINGLE

4

V_STRING

8

Show: