Sidebar
Welcome!
Welcome to the portion of my website where I share and store information or tools about Microsoft Access and Excel. Hope you find some of it interesting or helpful!
If you're totally new to using Microsoft Access, I recommend reading this article to help get you started.
If you have any questions or suggestions for the articles on the website, feel free to post in the forums. I can't promise my response will be quick, but I will try my best to respond to all forums posts.
Sincerely,
Azli
As an Amazon Associate I earn from qualifying purchases.
Latest Articles
- Excel - True/False showing as 1/0 - Transition Formula Evaluation (Lotus 1-2-3)
- Microsoft Access VBA - Bold Font in MsgBox (Access 97)
- VBA and DAO : Creating a table and its fields
- Previous Date & Sum of Month/Year to-date using a correlated subquery
- Move down one row with hidden or filtered rows with Excel VBA
- Microsoft Access - List of reserved words
- Check if email address and/or URL domain is valid using VBA
- VBA Error Handling
Most Read
- Populating TreeView using VBA (ActiveX Common Control)
- Check if email address and/or URL domain is valid using VBA
- DConcat function - Concatenating field values for multiple records matching a query's GROUP / SORT BY or WHERE clause
- Running Sum / Total / Count / Average in a query using a correlated subquery
- Access 2016 / 365 : DAO reference error & ACE 16
- VBA Functions using DAO to determine if a Table, Query, Field (and its properties) exist
- Set DPI setting for all sheets in a workbook using VBA
- New data type in Access 2016—Large Number (BigInt)
Who's Online
Microsoft Access
Microsoft Access Downloads
My first database
DConcat function sample file
Highlighting edited fields - using .Value, .OldValue, AfterUpdate/Change (Control event), and BeforeUpdate (Form event)
My first Microsoft Access database (Revisited)
Populating a TreeView control sample file (Microsoft Access)
Date/Time gaps - Find next date using correlated subquery sample file
Running Sum/Total/Count/Average in a query using a correlated subquery
Bold Font in MsgBox
Cascading Comboboxes
Sample file for 'VBA Functions using DAO to determine is a Table, Query, Field (and its properties) exist'
Access VBA - Other uses of SysCmd
Powered by Phoca Download