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
Sample file for 'VBA Functions using DAO to determine is a Table, Query, Field (and its properties) exist'
Sample file for 'VBA Functions using DAO to determine is a Table, Query, Field (and its properties) exist'.
VBA Functions that use DAO to do the following:
- IsTable()
- Determine if table exists in an Access database
- IsQuery()
- Determine if query exists in an Access database
- IsField()
- Determine if field exists in an Access database table/query
- IsFieldProperty()
- Determine if property for a table/query field exists
License Agreement
THIS ARE NOT THE STANDARD TERMS. Read the terms for each file you download to be sure which one you are agreeing to.
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 are free to to use any sample VBA code from this file for any commercial purposes, but not the sample file itself.
- 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 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.