ACC: How to Search for Microsoft Access Articles by Keywords

Last reviewed: June 8, 1997
Article ID: Q119526
The information in this article applies to:
  • Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SUMMARY

Novice: Requires knowledge of the user interface on single-user computers.

Every Microsoft Access Knowledge Base (KB) article contains a keyword formed from the article's category and subcategory. You can query on this keyword to help you find specific groups of articles.

The category and subcategory of Microsoft Access KB articles are abbreviated and concatenated to form a unique word that you can query on. For example, FmsCmbo stands for Forms, Combo/List Box, where Forms is the category and Combo/List Box is the subcategory. Note that the first letter of the category and the first letter of the subcategory are capitalized. If the subcategory consists of more than one word, additional letters may be capitalized as in IntPubWiz, where Internet is the category and "Publish to the Web Wizard" is the subcategory. This capitalization does not affect your queries; it is intended to make it easier for you to recognize the subcategory.

For more information about how to query the Microsoft Access KB using these keywords, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q119525
   TITLE     : ACC: How to Query on Microsoft Access Keywords

MORE INFORMATION

The following list contains all the categories and subcategories used in Microsoft Access KB articles:

Major Topic

      Minor Topic                                              Subcategory

ADT/ODE

   General                                                     OdeGen
   Help Files                                                  OdeHlp
   Installation                                                OdeInst
   Replication Manager                                         OdeRplMgr
   Setup Wizard options                                        OdeStWiz
   STF issues                                                  OdeStf
Automation
   General                                                     AutoGnrl
   Graph                                                       AutoGrph
   Office Assistant                                            AutoOA
Conversion/Compatibility
   Convert fails on a database                                 CnvNodb
   ConvertErrors table                                         CnvErtbl
   Errors while running Convert                                CnvErrs
   General                                                     CnvGnrl
   Other                                                       CnvOthr
   Performance of Convert utility                              CnvPrfm
   Problems with conversion                                    CnvProb
   Rewriting/Optimizing for new version                        CnvOptVer
   Running previous version databases                          CnvRunPre
   Secured databases                                           CnvScrdb
   Version behaves differently than previous version           CnvVerDif
Documentation/Sample Apps
   Answer Wizard                                               DcmAnsWiz
   Cue Cards                                                   DcmCucd
   Help                                                        DcmHlp
   Manuals                                                     DcmMnl
   NWIND                                                       DcmNwd
   Office Assistant                                            DcmOffA
   Orders                                                      DcmOrds
   Other                                                       DcmOthr
   Samples                                                     DcmSmp
   Solution                                                    DcmSltn
Environment/Configuration
   Corrupted Registry                                          EvnReg
   GP Fault/IPF                                                EvnGpf
   Hardware                                                    EvnHdwr
   Networks                                                    EvnNtw
   Operating system                                            EvnOs
   Other                                                       EvnOthr
   Other drivers                                               EvnOdr
   System performance                                          EvnPrfm
   System requirements                                         EvnSysReq
   TEMP directory                                              EvnTemp
   TSR problems                                                EvnTsr
   Video drivers                                               EvnVido
Expressions
   Expression Builder                                          ExrBldr
   Nulls and Zero-length strings                               ExrNls
   Other                                                       ExrOthr
   String manipulation                                         ExrStrg
FastTips Q&A scripts                                           Fstqa
Forms/Reports, Common to
   Code Behind Forms/Reports                                   FmrCdbeh
   Code Builder                                                FmrCodeb
   Color Builder                                               FmrColrb
   Colors/Color Palette                                        FmrColr
   Default Properties/Template                                 FmrProp
   Field List                                                  FmrFld
   How To                                                      FmrHowto
   Other                                                       FmrOthr
   Problems                                                    FmrProb
   Toolbox                                                     FmrTlbx
Forms, Specific to
   Button Design Builder                                       FmsButb
   Combo/List box                                              FmsCmbo
   Combo/List Box Builder                                      FmsCmbob
   Custom Help/Help Compiler                                   FmsHlp
   Events (calling macro/modules)                              FmsEvnt
   Form properties                                             FmsProp
   How To                                                      FmsHowto
   Option Group Builder                                        FmsOptB
   Option groups                                               FmsOpt
   Other                                                       FmsOthr
   Problems                                                    FmsProb
   Requery/Refresh                                             FmsRqry
   SubForm                                                     FmsSubf
   Wizards
      AutoForm/Quick Form                                      FmsWiza
      Chart Wizard                                             FmsWizc
      Main/Subform                                             FmsWizm
      PivotTable                                               FmsWizpt
General Functionality
   Application design                                          GnlApp
   Compact/Repair                                              GnlCmp
   Corrupted database                                          GnlBaddb
   Data Entry/Editing                                          GnlDe
   Database Documentor/Print Def                               GnlDbdoc
   Encrypt/Decrypt                                             GnlEncr
   File Manipulation/Management                                GnlFilem
   Find/Replace                                                GnlFnd
   Formatting                                                  GnlFrmt
   Global settings (View options)                              GnlGlobl
   Input masks                                                 GnlInpt
   MSACC20.INI                                                 GnlAcini
   MultiUser/Locking                                           GnlMu
   Other                                                       GnlOthr
   Performance overall                                         GnlPrfm
   Quick sort                                                  GnlQksrt
   Reserved words                                              GnlRsvd
   Validation                                                  GnlValid
Internet
   MS Access on the internet, such as Newsgroups               AccInternet
   ASP                                                         IntAsp
   Frames                                                      HtmFram
   Hyperlinks                                                  IntLink
   Tables                                                      HtmTbl
   View HTML in Browser                                        HtmView
   Wizards
      Publish to the Web Wizard                                IntPubWiz
Interoperability
   Charting                                                    IntpChrt
   Custom Controls                                             IntpCstm
   DDE                                                         IntpDde
   Graph                                                       IntpGrph
   Import/Export MS Office Data                                IntpOff
   Mail (Send from File menu)                                  IntpMail
   Menus                                                       IntpMenu
   OLE                                                         IntpOle
   OLE Automation                                              IntpOlea
   Other                                                       IntpOthr
   Print Merge/Mail Merge                                      IntpPrtm
   Shell to other apps                                         IntpShell
   Toolbars                                                    IntpToolbr
   VB Mapping Layer                                            IntpVb
   Word 6.0/Merge It                                           IntpWrd6
   Web-related issues                                          IntpWeb
ISAM
   Btrieve                                                     IsmBtrv
   Excel 2.0-4.0                                               IsmExl4
   Excel 5.0                                                   IsmExl5
   Fox/xBase                                                   IsmXbase
   General                                                     IsmGnrl
   How To                                                      IsmHowto
   Import/Export/Attach Access MDBs                            IsmIea
   Import/Export Setup (specs)                                 IsmSetup
   Import/Export Text (delimited)                              IsmTxtd
   Import/Export Text (fixed width)                            IsmTxtfx
   Lotus                                                       IsmLotus
   Other                                                       IsmOthr
   Paradox                                                     IsmPdox
   Problems                                                    IsmProb
   Works                                                       IsmWorks
Jet database engine
   Compact/Repair                                              JetCmp
   Data Entry/Editing                                          JetDE
   Filters                                                     JetQryFiltr
   Find Methods                                                JetFind
   How To                                                      JetQryHowto
   MultiUser/Locking                                           JetMU
   Parameters/Referencing                                      JetQryParm
   QueryDefs                                                   JetQryDef
   Recordsets                                                  JetRS
   Requery/Refresh                                             JetRqry
   Security                                                    JetSec
   Seek Method                                                 JetSeek
   Sort                                                        JetQrySort
   TableDefs                                                   JetTblDef
   Transactions                                                JetTrans
   Using Bookmarks                                             JetBkmk
   Validation                                                  JetValid
Macros
   Action Arguments                                            McrArg
   Actions                                                     McrActn
   Condition Column                                            McrCond
   General                                                     McrGnrl
   How To                                                      McrHowto
   Macro Builder                                               McrBldr
   Macro Name                                                  McrName
   Other                                                       McrOthr
   Problems                                                    McrProb
Modules
   DAO                                                         MdlDao
   Adding/deleting records                                     MdlAdrec
   Editing records                                             MdlEdit
   Find methods                                                MdlFind
   General                                                     MdlGnrl
   Immediate window                                            MdlImmed
   Debug window                                                MdlDebug
   Libraries (MDA)                                             MdlLib
   Navigating                                                  MdlNav
   Other                                                       MdlOthr
   Performance                                                 MdlPrfm
   Problems                                                    MdlProb
   QueryDefs                                                   MdlQry
   Recordsets                                                  MdlRcd
   Transactions                                                MdlTran
   Using Bookmarks                                             MdlBkmk
   VB Compatibility                                            MdlVb
Non Product
   Chatter                                                     NpdChat
   Compliment/complaint                                        NpdCmnt
   Legal/Licensing issues                                      NpdLegal
   Manufacturing issues                                        NpdMfg
   Non-Microsoft product                                       NpdNotms
   Other                                                       NpdOthr
   Post-Sales request                                          NpdPstsl
   MTS Support                                                 NpdMts
   Sales Support                                               NpdSales
ODBC
   Access 2.0 ODBC Driver                                      OdbcAc20
   Driver Pack                                                 OdbcDrvpk
   General                                                     OdbcGen
   How To                                                      OdbcHowto
   MSysConf                                                    OdbcMsys
   Non-Microsoft drivers                                       OdbcNonms
   Oracle                                                      OdbcOracl
   Other                                                       OdbcOthr
   Problems                                                    OdbcProb
   SQL Data Definition query                                   OdbcDdl
   SQL Pass-Through query                                      OdbcSpt
   SQL Server: MS                                              OdbcSqlms
   SQL Server: Sybase                                          OdbcSqlsy
   SQL Union query                                             OdbcSun
Output To
   AutoStart option                                            OtpAuto
   General                                                     OtpGnrl
   Microsoft Excel/Analyze It                                  OtpExl
   MS-DOS Text (*.txt)                                         OtpTxt
   Other                                                       OtpOthr
   Problems                                                    OtpProb
   Rich Text Format (*.rtf)                                    OtpRtf
Printing
   Controlling printing options                                PtrOpt
   Other                                                       PtrOthr
   Print Preview doesn't match output                          PtrPrev
   Print dialog box                                            PtrDialg
   Print fixed font output                                     PtrFxfnt
   Print setup                                                 PtrSetup
   Printing graphs/lines                                       PtrGraph
   Printing limitations                                        PtrLimit
   Problems/Performance                                        PtrProb
Programming/Logic
   API/DLL calls                                               PgmApi
   Class modules                                               PgmCM
   Controlling Print options                                   PgmPrt
   Declarations/DIM                                            PrgDecl
   Error Handling/Debugging                                    PgmErr
   Events                                                      PgmEvnt
   File manipulation                                           PgmFilm
   How To                                                      PgmHowto
   Looping structures                                          PgmLoop
   Object manipulation                                         PgmObj
   Other                                                       PgmOthr
   Parsing strings and files                                   PgmParse
   Performance/Optimization                                    PgmPrfm
   Process control                                             PgmPrcs
   Reserved words                                              PgmRsvd
   Variable                                                    PgmVbl
   Working with collections                                    PgmColl
Queries
   Append                                                      QryAppnd
   Criteria                                                    QryCrit
   Crosstab                                                    QryCross
   Delete                                                      QryDel
   Filters                                                     QryFiltr
   General                                                     QryGnrl
   How To                                                      QryHowto
   Joins                                                       QryJoin
   Make Table                                                  QryMktbl
   Other                                                       QryOthr
   Parameters/Referencing                                      QryParm
   Performance                                                 QryPrfm
   Problems                                                    QryProb
   Properties                                                  QryProp
   Rushmore                                                    QryRush
   SQL
      View/Syntax questions                                    QrySqlvw
      Data Definition query                                    QrySqldd
      Pass-Through query                                       QryPass
      Union query                                              QryUnion
   Top <number>                                                QryTopn
   Totals/Aggregate functions                                  QryTotal
   Updatability/Row Fix-Up                                     QryFixup
   Update                                                      QryUpdat
   Wizards
      Archive                                                  QryWiza
      Crosstab                                                 QryWizc
      Find Duplicates                                          QryWizd
      Find Unmatched                                           QryWizu
      Simple Query                                             QryWizs
Relationships
   Can't save multiple layouts                                 RltNosav
   How to create relationships                                 RltCreat
   How to delete relationships                                 RltDel
   How to view relationships                                   RltView
   Need mouse to join tables                                   RltMous
   On attached MS Access tables                                RltAttac
   Other                                                       RltOthr
   Referential integrity                                       RltRef
Replication
   Briefcase                                                   RplBfcs
   Conflict resolution                                         RplConf
   Creating Design Master and Replicas                         RplDmr
   General                                                     RplGen
   Undoing replication                                         RplUndo
   Updating replica sets                                       RplUpd
Reports, Specific to
   Envelopes                                                   RptEnv
   Events                                                      RptEvent
   Layout                                                      RptLayou
   Mailing labels                                              RptLabel
   Other                                                       RptOthr
   Page numbers                                                RptPagen
   Problems                                                    RptProb
   Report properties                                           RptProp
   Sorting and grouping                                        RptSort
   SubReports                                                  RptSub
   Totaling                                                    RptTotal
   Wizards
      AutoReport/Quick Report                                  RptWiza
      Chart                                                    RptWizc
      Mailing Label                                            RptWizlbl
      Groups/Totals                                            RptWizg
      Single-Column                                            RptWizsi
      Snaking Columns                                          RptWizsn
      Summary                                                  RptWizsu
      Tabular                                                  RptWizt
Security
   Changing ownership                                          ScrtOwnr
   Default accounts                                            ScrtDef
   Implementing                                                ScrtImpl
   Other                                                       ScrtOthr
   Permissions                                                 ScrtPerm
   Users/Groups                                                ScrtUsr
   Workgroup Administrator                                     ScrtAdm
Setup
   Compliance checking                                         StpComp
   DMF-related problems                                        StpDMF
   Errors starting Microsoft Access                            StpErr
   How To                                                      StpHowto
   Install Options (Typical, and so on)                        StpOptio
   Install: General Issues                                     StpGnrl
   Install: Side by side (1.x&2.0)                             StpSide
   Install: Update (2.0 over 1.x)                              StpUpdat
   Maintenance install                                         StpMaint
   Media-related problems                                      StpMedia
   Network install                                             StpNet
   ODBC setup                                                  StpOdbc
   Other                                                       StpOthr
   Registration errors (REG.DAT)                               StpReg
   Setup fails                                                 StpFail
Syntax/Formulas
   Functions                                                   SynFnc
   General                                                     SynGnrl
   Referencing objects                                         SynRef
Tables
   Counters                                                    TblCount
   Data Types                                                  TblDatyp
   Database Design                                             TblDsign
   Field Builder                                               TblFldb
   Field properties                                            TblFldp
   How To                                                      TblHowto
   Modify                                                      TblModfy
   Other                                                       TblOthr
   Primary Keys/Indexes                                        TblPriky
   Problems                                                    TblProb
   Wizards
      Table                                                    TblWiz
      Input Masks                                              TblInpMk
Upsizing Tools
   Installation                                                AutInst
   General                                                     AutGen
   Problems                                                    AutPrb
User Interface
   Commandbars                                                 UifCmdbar
   Database window (container)                                 UifDbwin
   Datasheet view                                              UifDatash
   Dialog Boxes                                                UifDialog
   Keyboard                                                    UifKeybd
   Menu Builder                                                UifMenub
   Menus                                                       UifMenu
   Other                                                       UifOthr
   Problems                                                    UifProb
   Right mouse menus                                           UifRtmous
   Toolbars                                                    UifToolbr
Wizards
   Add-in Manager                                              WzAdmgr
   Attachment Manager/Linked Table Manager                     WzAtmgr
   Auto Dialer Builder                                         WzAutod
   Data Base                                                   WzDb
   General                                                     WzGnrl
   How To                                                      WzHowto
   Import database                                             WzImport
   Other                                                       WzOthr
   Problems                                                    WzProb

REFERENCES

Each article in the Microsoft Access KB also contains at least one generic, KB-wide keyword. These keywords are standard throughout the Microsoft Knowledge Base, appearing in all KB articles, regardless of product. You can use these keywords to organize all KB articles or to search for articles across several Microsoft products. For more information about these keywords, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q94671
   TITLE     : Categories and Keywords for All Knowledge Base Articles


Additional query words: kbkeyword kbref
Keywords : kbother NpdOthr
Version : 1.0 1.1 2.0
Platform : WINDOWS
Hardware : X86
Issue type : kbkeyword


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: June 8, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.