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
- Downloads
- Microsoft Access
- Microsoft Access
- Sample file for 'VBA Functions using DAO to determine is a Table, Query, Field (and its properties) exist'
Top Ten Tags
Who's Online
DConcat function sample file
Sample file for 'DConcat function - Concatenating field values for records matching a query's GROUP BY clause' article.
License Agreement
Standard terms
Sample files are provided as-is. No guarantee is made that they are working correctly or that they do what they were intended to. By downloading and using the sample files, you are agreeing to the following:
- You agree to not hold me responsible for any and all damages due to the downloading or use of any sample file or sample code from this website.
- You agree to not to use the sample files and custom VBA functions for any commercial purposes without my express permission.
Please contact me if you need to use any sample file or custom VBA code I've written for commercial purposes and we can discuss terms to allowing that. More than likely, I'll have no problem with it (Mostly I just want to know what it's used for. I may even give you free publicity if you allow me to mention that your project uses my code!). - You are free to use any native Excel formulas that are provided in sample Excel files; I'm just showing you how to use them.
- You agree to not to modify the sample files or vba code and present either or both of them as your own, without documenting changes made and citing me and this website as the source of the original code. This is true regardless of whether used for commercial or non-commercial purposes.
- You also agree to any other terms posted elsewhere on this website regarding the use of this sample file and any VBA functions contained within it and any terms of using this website.