Have you experienced the problem with increasing size of your MS Access files? Do you need to compact your databases from time to time, especially when they reach specific file size?  Then we have a solution build in VBA that could be easily implemented to any MS Access database (this code applies to Access Version 2000 and later).

Displaying a filed from a query that somehow relates to a form which is currently opened is very easy with MS Access. Here we briefly discribe how to do that.

If you have ever tried to build an application in MS Access you probably came across the problem of referring to a control from a main form to its sub-form. Here is a very brief guide how should the reference look like.