Streamlining Code Reminder Popup Form
LEARN MS-ACCESS TIPS AND TRICKS
by a.p.r. pillai
1w ago
 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
Visit website
Streamlining Code Database Compacting Utility
LEARN MS-ACCESS TIPS AND TRICKS
by a.p.r. pillai
3w ago
 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
Visit website
Streamlining Code Synchronized Forms
LEARN MS-ACCESS TIPS AND TRICKS
by a.p.r. pillai
1M ago
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
Visit website
One TextBox and Three Wrapper Class Instances.
LEARN MS-ACCESS TIPS AND TRICKS
by a.p.r. pillai
2M ago
 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
Visit website
The Event Firing Mechanism in Access Objects
LEARN MS-ACCESS TIPS AND TRICKS
by a.p.r. pillai
2M ago
 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
Visit website
Streamlining Form Module Code Presentation
LEARN MS-ACCESS TIPS AND TRICKS
by a.p.r. pillai
2M ago
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
Visit website
Streamlining Numbers to Words Converter
LEARN MS-ACCESS TIPS AND TRICKS
by a.p.r. pillai
4M ago
 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
Visit website
Streamlining Event Procedures RGBColor Wizard
LEARN MS-ACCESS TIPS AND TRICKS
by a.p.r. pillai
4M ago
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
Visit website
Streamlining Event Procedures 3DTextWizard
LEARN MS-ACCESS TIPS AND TRICKS
by a.p.r. pillai
4M ago
 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
Visit website
Streamlining Form VBA External Files List HyperLinks
LEARN MS-ACCESS TIPS AND TRICKS
by a.p.r. pillai
5M ago
 External Files List in Hyperlinks in Form. The Office.FileDialog Control  The FileDialog Control displays files from the selected folder as hyperlinks in the form. Clicking on a hyperlink will open the file in its native application, if available. The File Dialog control features user-defined filters that allow users to display specific categories of files, such as Word Documents, Excel Worksheet files, and Access Databases, or view all files within a folder. Select the required files and click on the 'Create File Link' Command Button to add the selected files to a table and display ..read more
Visit website

Follow LEARN MS-ACCESS TIPS AND TRICKS on FeedSpot

Continue with Google
Continue with Apple
OR