Category Archives: VBA

Microsoft Access Forms – How To Build Your Own MS Access Form Wizard

Microsoft Access Forms – How To Build Your Own MS Access Form Wizard One of the many uses that Microsoft Access forms can be used for includes the ability to create your very own MS Access form wizard feature. As … Continue reading

Posted in Forms, MS Access, VBA | Tagged , , , , | 4 Comments

How to Convert Microsoft Access Macros To Visual Basic For Application VBA

How to Convert Microsoft Access Macros To Visual Basic For Application VBA The scenario: You’ve inherited an Access database that was originally built way back say with version 97 and some of the forms have started to look a little … Continue reading

Posted in Macros, MS Access, Utilities, VBA | Tagged , , , , | Leave a comment

Access Form Designs – How To Create A Report Interface For Your Access Database

Access Form Designs – How To Create A Report Interface For Your Access Database For the more polished and professional database, using Access form designs doesn’t necessarily mean viewing records from tables and queries. It can also serve as a … Continue reading

Posted in Dialog Boxes, Forms, MS Access, Reports, VBA | Tagged , , , , | 2 Comments

Microsoft Access Tutorial: How To Resize Form Fields Dynamically Using MS Access VBA

Microsoft Access Tutorial: How To Resize Form Fields Dynamically Using MS Access VBA I often see many poorly designed Access forms that just make it hard and clumsy to navigate and use. One particular element (and there are many) is … Continue reading

Posted in Forms, MS Access, VBA | Tagged , , , , | Leave a comment

Access VBA Events: What Are Events And How Do We Use MS Access VBA Events

Access VBA Events: What Are Events And How Do We Use MS Access VBA Events Microsoft Access VBA events have been around forever! Well, not forever but since VBA has been (circa 20+ years) and it’s still widely unexplored beyond … Continue reading

Posted in Modules, MS Access, VBA | Tagged , , , , | Leave a comment

Microsoft Access Tutorial: How To Build Alternative Access Form Controls – The Command Button

Microsoft Access Tutorial: How To Build Alternative Access Form Controls – The Command Button Building Access forms is a time consuming aspect to front-end database designs and in this Microsoft Access tutorial, I want to add some extra aesthetics and … Continue reading

Posted in Forms, Microsoft Training, MS Access, VBA | Tagged , , , , | Leave a comment

Access Database Forms: How To Print A Record In Access Through A Form

Access Database Forms: How To Print A Record In Access Through A Form Interacting with Microsoft Access database forms provides that rich, smooth and harmonious way to control data with functionality.  One popular feature is the ability to call another object … Continue reading

Posted in Forms, MS Access, Reports, VBA | Tagged , , , , | 9 Comments

Access Report VBA: Using Some VBA Report Properties To Automate Your Microsoft Access Reports

Access Report VBA: Using Some VBA Report Properties To Automate Your Microsoft Access Reports Working and automating an Access report VBA will require some knowledge of the module window (VBE), the defined sections and an insight to pre-defined events for … Continue reading

Posted in Modules, Reports, VBA | Tagged , , , , | 3 Comments

MS Access Functions: How To Build A Soundex Or Sounds Like Custom Access VBA Function

MS Access Functions: How To Build A Soundex Or Sounds Like Custom Access VBA Function Working with MS Access functions (of the built-in variety), you may have noticed a vast list of functions across different categories. By combining (or nesting) … Continue reading

Posted in Functions, Modules, MS Access, VBA | Tagged , , , , | Leave a comment