Category: Design

  • Nomenclature

    Nomenclature

    When designing an access database it helps to have a consistent nomenclature (naming conventions) When referring to objects in code you will always know what the defined object is Tables – Start with tbl For system tables or tables you wish to automatically hide start with Usys Access System tables start with Msys Queries –…

    Continue Reading

  • Creating Ribbon Menu in VBA

    Creating Ribbon Menu in VBA

    Ribbon Menu’s are controlled by the table USysRibbon and the function MyButtonCallbackOnAction Download my sample application , in the Ribbon table I have included the Ribbon for the application a reporting ribbon and sample of other ribbons I have used in the past. The ribbon menus are written in XML , set your application to…

    Continue Reading