Streamlining Form Module Code in Standalone Class Module. Editing Large Text Box Contents in Zoom-in Control. This topic was initially released in August 2007 and titled "Edit Data in Zoom-in Control." In the preceding example, a custom shortcut menu was devised and linked to the form to activate the zoom-in control, enabling the editing of textbox contents with multiple lines of data, akin to the notes field in the Employees Table. The earlier version of the customized Shortcut Menu for the Employees Form is in the image below for reference. The built-in Shortcut Menu underwent cu ..read more

 Streamlining Form Module Code in Standalone Class Module. Reminder Popup Form. Introduction. Understanding the significance of reminders is paramount. When it comes to important occasions such as a family member's or friend's birthday, adequate preparation time is crucial. Being notified at least two days beforehand ensures that we don't overlook these events amidst our busy schedules and other pressing commitments. When considering business-related activities, let's examine the Inventory System of a Pharmacy as an example. It's imperative to print out a list of medicines that fall below ..read more

 Streamlining Form Module Code in Standalone Class Module. The Database Compact/Repair Utility. The 'Compact on Close' Option in Microsoft Access. When enabled under File --> Current Database --> Application Options, this feature automatically compacts the database every time you open and close it. Additionally, you can manually select the Compact/Repair option from the File menu to Compact and Repair the active database. If you need to compact an external file, you can choose the Compact and Repair option from the Database Tools Menu. If you prefer to refrain from performing the C ..read more

Streamlining Form Module Code in Standalone Class Module. The article on the Synchronized Floating Popup Form was originally published in February 2009. The notable difference is that the Event Subroutine code, once written in the Form Module, is now executed from the Standalone Class Module. All events triggered from the form and controls, such as TextBoxes and Command Buttons, are now captured in the Standalone Class Module, with the corresponding event subroutines being executed outside the Form Module. This exemplifies a paradigm shift where Form Module VBA codes are run from the Standalon ..read more

 Streamlining Event Subroutines in Standalone Class Module. The Standalone Class Module Coding Rules overview. One Wrapper Class Module for several objects of the same Type (E.g.: TextBox) on the Form. Example: ClsTextBox. One Event Subroutine per Event for several Objects of the same type on the Form. Example: Private Sub txt_AfterUpdate() Select Case TypeName(Ctl) Case "TextBox" Select Case Ctl.Name Case "Text0" 'Code Case "Text2","Text4","Text6" 'Code ..read more

 Streamlining  Event Subroutine Code in Standalone Class Module. How Does the Event Firing Mechanism Work within Access Objects? This topic was briefly touched on during the Presentation of  Streamlining Form Module Code in the Standalone Class Module for Access User Groups (Europe) Chapter.  The Event-related Key Words: Event, RaiseEvent, and WithEvents. Event - used to Define an Event. RaiseEvent - to Invoke the Event. WithEvents - to Capture the fired Event and execute the Event Subroutine Code. In the preceding articles, we gained insights into the utilization of ..read more

Streamlining Form Module Code in Standalone Class Module. On January 3, 2024, I presented a concise overview of the intricate topic: "Streamlining Form Module Code in Standalone Class Module" for the Access User Groups (Europe) Chapter.   www.accessusergroups.org/europe/ .  https://youtu.be/AjvjN3h1ipY The YouTube subtitles are available in eleven languages: Danish, Dutch, English, French, German, Italian, Spanish, Hindi, Malayalam, Bangla (India), and English (Autogenerated). Choose your preferred language subtitles from the Settings Menu. Experience the video, packed wit ..read more

 Numbers to Words Converter. While converting numbers to words is straightforward in Microsoft Word Mail Merge, such functionality is not readily available in MS Access.  To address this limitation, we have developed a versatile function that can be employed wherever needed—whether within a Form TextBox Control, on Report Summary Totals, in Printed Invoices, or any other desired location. Utilize the CardText() function by calling it with the desired number for conversion and displaying the result wherever necessary. It's as simple as that. The Main Demo Form Image is given below: T ..read more

RGB Color Wizard. Create your own RGB Color Palette for Form Design. This is a special episode focusing on streamlining the Form Module Code. For our RGB Color Wizard, we utilize an ActiveX ScrollBar Control. It's important to note that you cannot instantiate ActiveX controls such as Scrollbars, Sliders, TreeView, and ListView Controls in the standalone class module. Therefore, all event procedures for these controls must be written in the Form Module exclusively. We employ three ScrollBar Controls dedicated to Red, Green, and Blue color code values. Each control spans from 0 to 255, represent ..read more

 The 3D Heading Creation Wizard for Form and Report. The contents of the 3D Text Wizard were originally published in a series of articles back in September 2006. I created this website to share some tips, many of which I had implemented in my projects while working in an Automotive Company in the Sultanate of Oman. These articles, featuring the QBColor version, aimed to provide insights and practical knowledge based on real-world experiences. The 3D Text Wizard now offers a broader spectrum of colors in RGB format for users to choose from. To enhance customization, a ColorList table has b ..read more