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)
- You are here:
- Home
- Articles
- Microsoft Excel
- Formulas
- Count occurrences of string within another string using LEN and SUBSTITUTE
Top Ten Tags
© Free Joomla! 3 Modules- by VinaGecko.com