We recently updated from Access 2003 to Access 2010. We are opening an old .mdb database in Access 2010 and for some reason it messes up the custom groups we had in Access 2003. Some of these groups were from years ago and they just reappeared in Access 2010. Are we just going to be forced to recreate the groups or is this there a fix for this? I attached images showing the differences to give you a better idea of what I'm talking about. Access-2003.jpg Access-2010.PNG
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette.
This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database.
Split up all multi-value fields into single values:
Split up fields that belong to other things into separate tables:
Make sure that all record…