Editing Leszynski naming convention (section)

==Elements==
The elements of the naming convention are described in the following table.

{| class="wikitable"
|-
!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
|}

=== The Basic LNC Object Prefixes ===
{| class="wikitable"
!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
|}

===The Basic LNC Variable Prefixes===
{| class="wikitable"
!Variable Type
!Tag
|-
|Local variable
|[no prefix]
|-
|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
|}

===The Basic LNC Database Object Tags===
{| class="wikitable"
!Object
!Tag
|-
|Class module
|cls
|-
|Form
|frm
|-
|Form (dialog)
|fdlg
|-
|Form (menu)
|fmnu
|-
|Form (message)
|fmsg
|-
|Form (subform)
|fsub
|-
|Macro
|mcr
|-
|Module
|bas
|-
|Module
|mod
|-
|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
|-
|Middle Table
|trel
|-
|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
|}

===The LNC Table Field Tags===
{| class="wikitable"
!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
|}

===The LNC Tags for VBA Variables===
{| class="wikitable"
!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
|}

===The LNC Tags for Form and Report Controls===
{| class="wikitable"
|+(may also be used in code referencing controls)
|-
!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 (Radio 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
|-
|Button
|btn
|-
|Unbound object frame
|fru
|}

===Some Typical LNC Names for Database Objects, Controls and Variables===
{| class="wikitable"
!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
|}