VBA Access

VBA Access Tutorial

VBA Recordset Basics:

1. DAO & ADO in VBA

2. Recordset types in VBA

3. Move with no records in VBA

4. RecordCount without MoveLast in VBA

5. MoveNext without testing EOF in VBA

6. Loop without MoveNext in VBA

7. FindFirst / Seek without testing NoMatch in VBA

8. AddNew without moving to LastModified in VBA

9. Failing to close a recordset in VBA

10. Nested recordsets in VBA

VBA - DAO Programming Examples:

Introduction: DAO Programming in VBA
Ex1: VBA Create tables using DAO
Ex2: VBA - Modify existing tables using DAO

Ex3: VBA - Delete / Drop a table using DAO

Ex4: VBA - Create Indexes using DAO

Ex5: VBA - Delete indexes using DAO

Ex6: VBA - Create relations using DAO

Ex7: VBA - Delete relations using DAO

Ex8: VBA - Delete a query using DAO

Ex9: VBA - Set Object property using DAO

Ex10: VBA - Return Object property using DAO

Ex11: VBA - Set default properties using DAO

Ex12: VBA - Proper() function using DAO

Ex13: VBA - Set field description using DAO

Ex14: VBA - Index on field using DAO

Ex15: VBA - Create a query using DAO

Ex16: VBA - Create new database using DAO

Ex17: VBA - Show DB properties using DAO

Ex18: VBA - Read fields using DAO

Ex19: VBA - Read table records using DAO

Ex20: VBA - Convert numeric results using DAO

Ex21: VBA - Open & Loop through records using DAO

Ex22: VBA - Show form properties using DAO

Ex23: VBA - Execute SQL using DAO

Ex24: VBA - GetName of AutoNumber using DAO

VBA - ADO Programming Examples:

ADO programming examples in VBA
Ex1: VBA - List the tables using ADO
Ex2: VBA - Open a recordset using ADO
Ex3: VBA - Create a new query using ADO
Ex4: VBA - Modify a query using ADO
Ex5: VBA - BAND Operator in ADO
Ex6: VBA - BNOT Operator in ADO
Ex7: VBA - Database Active users in ADO
Ex8: VBA - Distinct users Connected to DB using ADO

VBA - ADOX Programming Examples:

ADOX Programming Code Examples in VBA
Ex1: VBA - Set the Seed of an AutoNumber using ADOX
Ex2: VBA - List the tables using ADOX
Ex3: VBA - Show the columns in a table using ADOX
Ex4: VBA - Create a table using ADOX
Ex5: VBA - Modify table using ADOX
Ex6: VBA - Modify field properties using ADOX
Ex7: VBA - Delete a table using ADOX
Ex8: VBA - Create indexes using ADOX
Ex9: VBA - Delete indexes using ADOX
Ex10: VBA - Create relationships using ADOX
Ex11: VBA - List relationships using ADOX
Ex12: VBA - Delete relationships using ADOX
Ex13: VBA - Create a query using ADOX
Ex14: VBA - Create a parameter / action query using ADOX
Ex15: VBA - List the parameter/action queries using ADOX
Ex16: VBA - Execute a parameter query using ADOX
Ex17: VBA - Delete a parameter/action query using ADOX
Ex18: Create a database using ADOX
Ex19: VBA - Delete all record using ADOX
Ex20: VBA - Read Seed / Autonumber using ADOX
Ex21: VBA - Reset Seed / Autonumber using ADOX