Home  |   French  |   About  |   Search  | mvps.org  

What's New
Table Of Contents
10 Commandments 

In Memoriam

Terms of Use

VB Petition

General: Commonly used naming conventions

Dev Ashish

Commonly used naming conventions (Taken from Rcurtis@princeton.edu's Access notes)

The Leszynski/Reddick Guidelines for Access is the most commonly used naming convention for Access objects.  These Guidelines as published in SmartAccess, suggest that all objects should have a descriptive tag, placed at the start of the object name

Note: It is suggested that the choice of naming convention is not as important as making sure that you do implement 'A' naming stragegy. Which one is purely a personal preference

Tags for Database Container Objects

Object Tag Example
Form frm frmCustomer
Form (Dialog) fdlg fdlgLogin
Form (Menu) fmnu fmnuUtility
Form (message) fmsg fmsgWait
Form (subform) fsub fsubOrder
Macro mcr mcrUpdateInventory
Macro (menu) mmnu mmunEntryFormFile
Module bas basBilling
Query (append) qapp qappNewProduct
Query (crosstab) qxtb qxtbRegionSales
Query (DDL) qddl qddIInit
Query (delete) qdel qdelOldAccount
Query (form filter) qflt qfltSalesToday
Query (make table) qmak qmakShipTo
Query (select) qry/qsel qryOverAchiever
Query (SQL pass-through) qspt qsptOrder
Query (totals) qtot qtotResult
Query (union) quni quniMerged
Query (update) qupd qupdDiscount
Query (lookup) qlkp qlkpStatus
Report rpt rptInsuranceValue
Report (subreport) rsub rsubOrder
Table tbl tblCustomer
Table (lookup) tlkp tlkpShipper

Database Container Object Prefixes

Archived objects zz zzfrmPhoneList
System Objects zs zstblObjects
Temporary objects zt ztqryTest
Under development _ _mcrnewEmployee  

Tags for Control Objects

Chart cht chtSales
Check box chk chkReadOnly
Combo box cbo cboIndustry
Command button cmd cmdCancel
Frame fra fraPhoto
Label lbl lblHelpMessage
Line lin linVertical
Listbox lst lstPolicyCode
Option button opt optFrench
Option group grp grpLanguage
Page break brk brkPage1
Rectangle (shape) shp shpNamePanel
Subform/report sub subContact
Textbox txt txtLoginName
Toggle button tgl tglForm

Tags for Access Basic / VBA Variables

Container   con   Dim conTables as Container
Control   ctl   Dim ctlVapour As Control
Currency   cur   Dim curSalary As Currency
Database   db   Dim dbCurrent As Database
Document   doc   Dim docRelationships as Document
Double   dbl   Dim dblPi As Double
Dynaset   dyn   Dim dynTransact As Dynaset
Field   fld   Dim fldLastName as Field
Flag (Y/N,T/F)   f   Dim fAbort As Integer
Form   frm   Dim frmGetUser As Form
Group   gru   Dim gruManagers as Group
Index   idx   Dim idxOrderld as Index
Integer   int   Dim intRetValue As Integer
Long   lng   Dim lngParam As Long
Object   obj   Dim objGraph As Object
Parameter   prm   Dim prmBeginDate as Parameter
Property   prp   Dim prpUserDefined as Property
QueryDef   qdf/qrd   Dim qdfPrice As QueryDef
Recordset   rst/rec   Dim rstPeople as Recordset
Relation   rel   Dim relOrderItems as Relation
Report   rpt   Dim rptYTDSales As Report
Single   sng   Dim sngLoadFactor As Single
Snapshot   snp   Dim snpParts As Snapshot
String   str   Dim strUserName As String
Table   tbl   Dim tblVendor As Table
TableDef   tdf/tbd   Dim tdfBooking as TableDef
Type (user-defined)   typ   Dim typPartRecord As mtPART_RECORD
User   usr   Dim usrJoe as User
Variant   var   Dim varInput As Variant
Workspace   wrk/wsp   Dim wrkPimary as Workspace
Yes/No   ysn   Dim ysnPaid As Integer

Access Basic Variable / VBA Prefixes for Scope

Global g glngGrandTotal
Local (none)   intCustomerld
Module m mcurRunningSum
Passed parameter p pstrLastName
Static s sintAccumulate

1998-2010, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer