2024-04-22 17:32
Streamlining Form Module Code in Standalone Class Module.Data Filter by Character and Sort on Form.Version 1.0 of this Article was originally published in April 2009 and introduce… Read More
Blog Directory > Software Blogs > Programming Blogs > LEARN MS-ACCESS TIPS AND TRICKS programming Blog >
Learn Ms-access Tips And Tricks Blog
msaccesstips.com
Learn advanced Microsoft Access Programming Techniques, Tips and Tricks.
2024-03-29 12:55
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… Read More
2024-03-19 09:42
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… Read More
2024-02-29 08:13
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 D… Read More
2024-02-14 16:14
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 E… Read More
2024-02-01 12:03
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… Read More
2024-01-20 15:12
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 Presenta… Read More
2024-01-13 18:33
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"… Read More
2023-12-03 07:12
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… Read More
2023-11-22 12:21
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 Sc… Read More
2023-11-11 05:47
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 t… Read More
2023-10-30 12:17
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 hyp… Read More
2023-10-18 02:46
Streamlining Custom Made Reports Wizard Form Module VBA Code.Hope you like the Custom Form Wizard of last week, which organized its VBA Code in standalone Class Modules. You can… Read More
2023-10-09 09:22
Streamlined Custom Made Form Wizard.This blog post was published earlier in December 2008 under Access 2003 and is now updated using the streamlined VBA Coding method in the stand… Read More
2023-09-30 15:59
All Frequently Used Controls on a Form.We learned how to write the Form or Report Module Event Subroutine VBA Code in the Stand-alone Class Module. Besides that, we can directly access any c… Read More
2023-09-23 03:09
Introduction.Hiding Report Lines Conditionally.Last week we saw that the Report Print Event Subroutines can be moved into the standalone Class Module and execute the Code from there wh… Read More
2023-09-12 16:00
Introduction.Report Module VBA Code in Standalone Class Module.After going through the earlier Episodes of this Topic: Streamlining Form Module Code in the Standalone Class Module, we… Read More
2023-08-31 17:34
Introduction.
In this Episode of Streamlining Form Module VBA Code, we will create Wrapper Classes for ComboBox and OptionGroup Controls. Having gone through the previous Episodes, you are n… Read More
2023-08-19 05:46
Creating Access Menu using Tabcontrol, ListBox, and Command Buttons.
We will take up the TabControl-based Menu design task after a few minutes.
Organizing the Wrapper Classes for Differen… Read More
2023-08-07 16:35
Introduction.After going through the last eight episodes of the Title Topic I assume that you are familiar with this new coding procedure and realized its advantages. By implementing t… Read More
2023-07-28 09:24
Introduction.Continued from "Streamlining Form Module Code - Part Six & Seven"Earlier we used the TextBox Wrapper Class Array to store the TextBox instances enabled with the requir… Read More
2023-07-17 13:38
Introduction
Streamlining Form Module Code in Standalone Class Module.
Maybe next week we will continue from the earlier episode Part Six and refine those new coding methods introduced there… Read More
2023-07-04 13:34
Continued from the last Episode - Part Five.Introduction.Streamlining Form Module VBA Code in Standalone Class Module.Earlier Episode Links:
Re-using Form Module VBA Coding for New Pro… Read More
2023-06-23 08:50
Continued from the last Episode - Part Four.Introduction.Writing Form Module VBA Code in Standalone Class Module.Earlier Episode Links:
Re-using Form Module VBA Coding for New Projects… Read More
2023-06-08 17:08
Continued from the earlier episodes on Streamlining Form Module VBA Code Part Three.Links to the earlier Episodes of the above topic are given below for Reference:
Re-using Form Module… Read More
2023-05-12 10:10
Introduction. This is the continuation of the last two Articles published earlier on this topic. Hope you have gone through the Title topic: Streamlining Form Module Code. By now… Read More
2023-04-25 17:55
Understanding Form Controls Event.
Hope you have enjoyed last week's Article and Demo of User-Defined Custom Events in the Form's Class Module. We have seen how Events are de… Read More
2023-04-12 11:34
Streamlining Form Module Event Procedures.
The Existing Form Module Coding Procedure.
We create and design Forms, with several controls like Textboxes, Command Buttons, and so on, and we wr… Read More
2022-09-27 16:04
Introduction.We already learned how to use MS Access live data in Excel earlier. Another VBA-based procedure was created to export the Table/Query data in the current version of the Excel Wo… Read More
2022-07-18 23:07
Introduction.We had an extensive discussion on the following database backup topics earlier:1. Database Daily Backup.2. Repairing Compacting Databases from a dedicated database with VBA Prog… Read More
2022-05-09 07:02
Introduction.Last week we learned the usage of ShowWindow and PostMessage Windows APIs. We could easily change the window state of Forms and Reports using their built-in windows… Read More
2022-04-27 10:48
IntroductionThis is all about controlling Form/Report Views and changing them from one state to another, like Hide, Minimized, Maximized, and Normal with the use of Windows APIs. I was aware… Read More
2022-01-15 11:05
Rearranging Rows of Data in ListView Control.In the earlier episode of this Tutorial, we have learned how to rearrange the Columns by enabling this feature: AllowColumnReorder option on the… Read More
2021-12-20 03:29
The ImageList ActiveX Control.For Assigning Images to the ListView control, we need the help of another ActiveX Control: the ImageList Control. We have seen Icons in Windows Explo… Read More
2021-11-25 13:52
Introduction.Continued from last week's ActiveX ListView Control Tutorial-01.In this session of the Tutorial, we will learn how to search and find the particular row and column values and di… Read More
2021-11-18 06:51
The LEARN MS-ACCESS TIPS AND TRICKS Articles at your Finger-Tip. Take all Articles with you in your Android Phone App, wherever you go, and learn them at your own pace. Install the Andr… Read More
2021-11-14 05:17
Introduction.In MS-Access we have ListBox control and mostly it will have only a few columns of data, to find the item(s) quickly. The source data for this control are either typed dire… Read More
2021-07-07 15:40
Introduction.A very useful Command to transfer data between Microsoft Access and Excel using the Import/Export Options. Here, we will concentrate on the Export aspect and what challeng… Read More
2021-03-29 17:16
Introduction.The CreateShortcut() method of the Windows Script Object can be used for creating Desktop Shortcuts in Microsoft Access. The Desktop Shortcut can launch frequently us… Read More
2021-02-05 14:56
Introduction.This message box accepts all the parameters of the Access MsgBox function, except [helpfile] and [context] parameters. In addition to that it has another optional paramete… Read More
2021-01-19 11:04
Introduction.In this Session of the TreeView Control Tutorial, we will use two Subforms along with the TreeView control on the main form frmTreeViewtab. We have imported the… Read More
2020-12-31 15:38
Introduction.We are familiar with the Drag and Drop operations on TreeView Control, in Ms-Access that rearranges Nodes. All the base records for the Treeview Control Nodes comes from a… Read More
2020-12-17 14:15
Introduction.Microsoft Access ListView Control Project has been designed and demonstrated here, in this episode of TreeView Control Tutorial. The main task is, first populate the TreeV… Read More
2020-11-21 09:01
Introduction.I hope you found, last week’s tutorial on ImageCombo Control useful for your Microsoft Access Projects. With the TreeView ImageCombo Control we could create a… Read More
2020-11-03 01:18
Introduction.In this Session of TreeView Control Tutorial we will learn programming the ImageComboBox Control. We will create an MS-Access Project Drop-down Menu, with ImageCombo Contr… Read More
2020-10-18 14:20
Introduction.In this Episode of Tree View Control Tutorial we will learn how to Add/Delete Nodes. The position of the Add/Delete candidate item will be check-marked, where we want to A… Read More
2020-10-09 17:48
Introduction.Hope, you found last few weeks Tutorial Sessions, of Microsoft TreeView and ImageList Control interesting and ready to take on the next episode. If you have not yet gone through… Read More
2020-10-01 15:49
Introduction.Last week we have created Access Project Menu on TreeView Control and I hope you were able to create it on your own and run it, in your Version of Microsoft Access. There… Read More
2020-09-19 17:36
The Microsoft Access Project Menu, when finished with the Tree View Control, will look like the Image given below.The Image above shows the Report Group’s third Option Custom Report is… Read More
2020-09-11 12:10
A. Introduction.Microsoft Tree View Control is part of Microsoft Windows Common Controls. It is an interesting piece of Object that displays related data in an hierarchy of Nodes. It c… Read More
2020-09-05 14:24
We are planning a Series of Tutorials on Microsoft Windows Tree View Control Programming in Microsoft Access and will publish the Series in the coming weeks. In the meantime I thought it… Read More
2020-08-19 02:46
Get all Microsoft Access Tips and Tricks Articles at your Finger-Tip. Take all Articles with you in your Android Phone App, wherever you go and learn them at your pace. Install the Andr… Read More
2020-01-14 07:06
Introduction.Form Letters.Form Letters are prepared from a standard template merged with addressee related information filled in on each letter. Appointment letters, call letters for i… Read More
2020-01-02 06:13
IntroductionDuring January 2010 I have published a Function: QrySeq() - Auto-Numbering in Query Column on this website and well-received by the readers all through these years. W… Read More
2019-12-18 15:48
Introduction.This is an offshoot of the earlier Function Running-Sum in Query Column. With few changes in the earlier Function RunningSum() we can easily calculate and find the loan ba… Read More
2019-12-03 14:19
Frequently Used Methods.Set the Form Name in Display Form Option of Current Database in Access Options. BIG DEAL!, this is the first trick any novice learns, when he/she start learning Micro… Read More
2019-11-11 13:34
Introduction.We are familiar with creating Auto-Numbers in Query Column, through an earlier Function created with the Name QrySeq(), published on this Website with the Post Title: Auto-Numbe… Read More
2019-11-07 16:03
Query Run ImageReport ImageUnique Key Test Read More
2019-10-29 12:12
Introduction.We already have some frequently used Report Footer formatting simple functions, like Report Page Number formatting function =PageNo([page],[pages]), output: Page: 1/20 &nd&hell…Read More
2019-10-17 12:09
Introduction.This is about running a User-Defined Function (say myFunction(Parameter)) on the Mouse Move Event Property of Text Boxes. When the Mouse Move Event occurs the Text-Box nam… Read More
2019-09-24 15:49
We have introduced ROUNDUP() Function of Excel in Microsoft Access earlier. It works like ROUND() Function except that the number is always rounded up. When number of digits is g… Read More
2019-08-16 13:11
IntroductionSo far we have worked extensively with only one type of Control: the TextBoxes on Form, enabled with Events to Raise and capture in stand alone Class Module, in various ways.&nbs&hell…Read More
2019-07-29 17:08
Continued from Last Week's PostSo far we have used the Collection Object , to hold all the Class Object instances of the Form Controls as an alternative to Class Object Arrays.If you have di… Read More
2019-07-18 15:17
Introduction.Hope that you have gone through last three Posts on Report based Event Trapping in Class Module and modifying Report controls in real-time. The links of those Posts are gi… Read More
2019-06-21 15:13
IntroductionThis is really a re-run of an earlier Post: Highlighting Reports published during August, 2007. The full Code was written on the Report Class Module itself. The chang… Read More
2019-06-15 17:05
IntroductionIf you have tried out last week's Report OnPrint() Event trapping in Access Class Module then it will be easy for you here. What we did there was Report's Detail Section Pr… Read More
2019-06-08 13:30
IntroductionWe have tried out several WithEvents examples with Class Modules, capturing built-in Events and User-defined Events from Form based Controls. We have created Class Module O… Read More
2019-05-31 16:59
So far we have used Unbound Text Boxes on Form for Demo runs, for built-in Event capturing in Class Module Object. Since, Text Boxes are the main control used on Forms, for data entry/… Read More
2019-05-24 16:20
So far we have used only a single Form and Text Box Controls on it to demonstrate the usage of WithEvents and built-in Event capturing, running subroutines in Class Object Arrays or in Colle… Read More
2019-05-16 15:54
This is the continuation of last Week’s Topic on Text Box AfterUpdate and LostFocus Event capturing and performing Validation Checks on values, in Class Module Array.Last week we have… Read More
2019-05-11 07:11
Last week we have learned how to create the Class Object Array (the Class Object that defines only a single Access.TextBox Control as it's Property) of TextBox Controls from MS-Access Form… Read More
2019-05-05 16:40
Last week we have learned how to capture Events, built-in and User-Defined, Raised from several type of Form-Controls and to run Event driven Programs in Class Module. We have us… Read More
2019-04-30 10:03
If you know how to program one control on the Form to capture the built-in Event in Class Module then you know how to do it for all of them. Last week we have used one Text box a… Read More
2019-04-25 09:45
Hope that you have gone through the last week’s WithEvents, Event, RaiseEvent introduction, tried out the sample Forms and understood as how both Form based VBA Code relates each other… Read More
2019-04-15 16:05
There are Class Modules on Forms and Reports. Almost all Controls on Form, like Command Buttons, Text Boxes, Combo Boxes, List Boxes and others have Event s Coding features that… Read More
2019-03-29 10:32
Last week we have done a trial run for adding/retrieving Class Objects into/from Dictionary Object Items. One important point we have highlighted there was that each Class Object Item… Read More
2019-03-19 17:12
We have learned the fundamentals of Dictionary Object, done trial runs for sorting simple items and displayed Access Table records through Dictionary Object to Ms-Access Form.Now, let us lea… Read More
2019-03-10 18:01
We will do a similar exercise that we did for Collection Object, for displaying Table Records retrieved from Collection Object on Form, based on the Key value selection from a Combo-box on t… Read More
2019-02-21 17:25
Sorting/Indexing of Table Records is a frequently used important exercise to organize the data in proper order, for faster retrieval of information, using Index Keys.As far as Dictionary Obj… Read More
2019-02-09 12:40
Last week’s introduction to Dictionary Object was a good start and informative for this weeks topics and to learn the fundamentals of this Object’s usage in Programs. The s… Read More
2019-02-03 12:55
Hope you have gone through the last few Articles on Collection Object usage in Microsoft Access, by now. If not, there will not be any difficulty in understanding Dictionary Object and… Read More
2019-01-23 16:54
Data records from a Table will be Added as the Collection Object Items and Description field values goes into the Collection Object as Key Parameter.The source values for the Combo Box on th… Read More
2019-01-10 12:15
Last week we had a brief introduction to the Collection Object Basics. We have learned as how to Add items to a Collection Object and the data item retrieval methods. We have use… Read More
2018-12-31 11:27
VBA Array is more popular and commonly used, for storing several set of related values (rows and columns), than Collection Object. We have used Arrays to store User-Defined Types and C… Read More
2018-12-16 17:00
Last week we have created a new Wrapper Class ClsTiles, using the ClsArea Class twice in the new Class Module, one instance for Floor dimension values and the second instance for Floor… Read More
2018-12-06 17:37
There are times that a particular Class Module needs to be instantiated more than once, to use similar set of values for a particular Application. For example: our ClsArea Class Module… Read More
2018-11-25 18:13
Here, we will build a Class Module for data processing task, by passing a DAO.Recordset Object to our Custom Class Object. Since it is an Object that is passing to our Custom Class we… Read More
2018-11-14 18:01
Last week we have tried an example as how to pass a Base Class Object, through the Set Property Procedure, to become part of the Object in memory. The passed object become an ext… Read More
2018-11-08 12:00
Last week we have created a Derived Class ClsVolume Object, using Class ClsArea as Base Class. We have created Property Procedures in the Derived Class to expose the Base Class’s… Read More
2018-10-30 16:06
If you have not seen the earlier Posts on Microsoft Access Class Module, please go through them before continuing, the links are given below.MS-Access Class Module and VBA.MS-Access VBA Clas… Read More
2018-10-20 15:08
Last Week we had a brief introduction of a simple Custom Class Object with only two Variables, for Length and Width Values. A Method for calculating Area of anything with Length and Width Va… Read More
2018-10-08 14:33
Last few weeks we have learned how to use User Defined Type (UDT) by creating a complex data structure and we know UDT’s strength or weakness, more or less by now. If you h… Read More
2018-09-16 18:06
Last week we have learned how to define a User-Defined Data Type and it’s usage in programs. If you have landed on this page, you may go through the earlier Post: User-Defined Da… Read More
2018-08-25 13:14
This is the second Post on User-Defined Data Type. The Link to the first Post on this topic you can find it HERE.The topic of User Defined Data Type came up when we have used Two Dimensiona… Read More
2018-08-09 17:00
First of all, I have some good news for you, our website: LEARN MS-ACCESS TIPS AND TRICKS has been selected by https://blog.feedspot.com panellist as one of the Top 5 Microsoft Access Blogs… Read More
2018-07-17 17:13
Last week we have explored the usage of ByVal (By Value) and ByRef (By Reference), in the Function Parameter, to pass the value from a Variable from the calling function or the L… Read More
2018-07-15 13:58
Before taking up the above subject let us look at some fundamentals on variables for the benefit of novices. When we define a variable in VBA or in any other programming language the compute… Read More
2018-06-20 16:27
Last week we have seen how to use Dir() DOS Command, it’s ability to read files from the Disk one by one and display it on the Debug Window.In continuation of that, we will get f… Read More
2018-06-20 16:25
We all know Dir() Function from the time of Windows DOS Operating System. This is the first Command introduced to those who sit on a Personal Computer to learn how to use Computers.&nb&hell…Read More
2018-06-20 16:21
Bookmarks are stored on individual records of a Recordset, when loaded into memory on a Form. When a Table or Query linked to a Form is open a unique Id is generated and stored in the… Read More
Subscribe to Learn Ms-access Tips And Tricks
Get updates delivered right to your inbox!