Elements
The elements of the naming convention are described in the following table.
| Component | Description | Example |
|---|---|---|
| Prefix(es) | A lowercase letter that adds extra information to the tag | p for Public variable |
| Tag | A three-letter sequence indicating the object type | tbl for table |
| BaseName | A word or two describing the object. If several words are used, each starts with a capital letter, and there are no spaces between them | OutlookContacts – contacts imported from Outlook |
| Suffix (RVBA), Qualifier (LNC) | A word giving more specific information about an object | ByDate – the data is sorted by date |
| Object | Tag |
|---|---|
| Incomplete objects, backup objects, or objects that are under development | _ or – (In some versions of Access, dashes sort to the beginning of the database object list.) |
| Hidden system objects | zh |
| Displayed system objects | zs |
| Programmatically created temporary objects | zt |
| Backup copies of objects, for later copying or reuse | zz |
| Variable Type | Tag |
|---|---|
| Local variable | |
| Local static variable | s |
| Module-level variable | m |
| Public variable in a form or report module | p |
| Public variable declared in the Declarations section of a standard module | g |
| Object | Tag |
|---|---|
| Class module | cls |
| Form | frm |
| Form (dialog) | fdlg |
| Form (menu) | fmnu |
| Form (message) | fmsg |
| Form (subform) | fsub |
| Macro | mcr |
| Module | bas |
| Query (any type) | qry |
| Query (append) | qapp |
| Query (crosstab) | qxtb |
| Query (data definition) | qddl |
| Query (delete) | qdel |
| Query (form filter) | qflt |
| Query (lookup) | qlkp |
| Query (make-table) | qmak |
| Query (select) | qry (or qsel) |
| Query (SQL pass-through) | qspt |
| Query (union) | quni |
| Query (update) | qupd |
| Report | rpt |
| Report (subreport) | rsub |
| Table | tbl |
| Table (attached dBASE) | tdbf |
| Table (attached Excel) | txls |
| Table (attached FoxPro) | tfox |
| Table (attached Lotus) | twks |
| Table (attached ODBC) | todb |
| Table (attached Paradox) | tpdx |
| Table (attached SQL Server) | tsql |
| Table (attached text) | ttxt |
| Table (lookup) | tlkp |
| Pages | pge |
| Object | Tag |
|---|---|
| Autonumber (random non-sequential) | idn |
| Autonumber (replication ID) | idr |
| Autonumber (sequential) | ids |
| Binary | bin |
| Byte | byt |
| Currency | cur |
| Date/Time | dtm |
| Double | dbl |
| Hyperlink | hlk |
| Integer | int |
| Long | lng |
| Memo | mem |
| OLE | ole |
| Single | sng |
| Text (character) | chr |
| Yes/No (Boolean) | ysn |
| Object | Tag |
|---|---|
| Boolean | bln |
| CommandBar | cbr |
| Control (generic; useful when cycling through controls on a form or report) | ctl |
| Currency | cur |
| Database | dbs |
| Double | dbl |
| Form | frm |
| Integer | int |
| Long | lng |
| QueryDef | qdf |
| Report | rpt |
| Single | sng |
| Snapshot | snp |
| String | str |
| Table | tbl |
| Type (user-defined) | typ |
| Variant | var |
| Object | Tag |
|---|---|
| Attachment | att |
| Bound object frame | frb |
| Chart (graph) | cht |
| Check box | chk |
| Combo box | cbo |
| Command button | cmd |
| Custom control | ocx |
| Frame | fra |
| Hyperlink | hlk |
| Image | img |
| Label | lbl |
| Line | lin |
| List box | lst |
| Option button | opt |
| Option group | grp |
| Page (on a Tab control) | pge |
| Page break | brk |
| Rectangle (shape) | shp |
| Subform/report | sub |
| Tab control | tab |
| Text box | txt |
| Toggle button | tgl |
| Unbound object frame | fru |
| Object/variable name | LNC naming elements | Description |
|---|---|---|
| tblEmployees | tag + base name | A table of employee data |
| qupdSales | tag + base name | A query that updates sales data |
| fsubDayMax | tag + base name + qualifier | A subform that shows the maximum day |
| intLines | tag + base name | An Integer variable to hold a value representing the number of lines in a Word table |
| curSales | tag + base name | A Currency variable holding a Sales value |
| pstrForm | prefix + tag + base name | A public String variable holding a form name |
| zztblContacts | prefix + tag + base name | A backup Contacts table, for copying and filling with imported data |
Read more about this topic: Leszynski Naming Convention
Famous quotes containing the word elements:
“Barbarisation may be defined as a cultural process whereby an attained condition of high value is gradually overrun and superseded by elements of lower quality.”
—Johan Huizinga (1872–1945)
“But all subsists by elemental strife;
And Passions are the elements of Life.”
—Alexander Pope (1688–1744)
“The popularity of that baby-faced boy, who possessed not even the elements of a good actor, was a hallucination in the public mind, and a disgrace to our theatrical history.”
—Thomas Campbell (1777–1844)
Related Phrases
Related Words