http://msaccessvbatutorial.com MS Access Programming - MS Access VBA with Real-World Examples Tue, 18 May 2010 03:21:18 +0000 http://backend.userland.com/rss092 en Last time, you learnt how to create a VBA OOP class by hand. Unfortunately it's tedious. So here's a fantastic tool to help you improve your productivity on MS Access or MS Excel VBA: mztools VBA. This tool is so fantastic that even Visual Studio Users could dream of it. In ... http://msaccessvbatutorial.com/blog/how-to-automate-vba-class-creation-with-mztools-free-addin/ Let's say you have a bunch of ms access database, one per week, you need to import records to the same table, this is the quickest way to do so (for simplicity we suppose that the source tables and the target table have the same structure otherwise you would need ... http://msaccessvbatutorial.com/blog/how-to-import-several-ms-access-databases-into-a-table/ If you have read my Open Letter to MS Access Users, you'd know why it is important to introduce Object Oriented Programming within your MS Access Application: because your IT and even yourself are fed up with the Mess so let's stop it :). Nevertheless Object Oriented Programming may be hard ... http://msaccessvbatutorial.com/blog/introduction-to-object-oriented-programming-with-ms-access-vba/ It is a Best Practice to split your MS Access File between a Front-End MS Access Application and a Back-End MS Access Database this is to make your Software Maintenance easier but this comes with a little price: if you work on multiple computers at work and at home while ... http://msaccessvbatutorial.com/blog/how-to-relink-ms-access-tables/ Let's say you have exported all your tables to another database and now want to delete them in current database. Unfortunately for security reason, Microsoft doesn't facilitate this task by allowing you to select all tables and delete them all at once: if done manually you have to do it ... http://msaccessvbatutorial.com/blog/how-to-delete-all-tables-programmatically/