How to Create an Autokeys Closing Macro in Microsoft Access

How to Create an Autokeys Closing Macro in Microsoft Access

As a follow on from my last post about Microsoft Access Macros, here’s a good working example clearly explained using the ‘unsafe’ CloseWindow command…

It walked you through creating a custom hotkey for Microsoft Access (using version 2010 though it will also apply through to the current version, 2016) which used the ‘Autokeys’ macro.

This macro shows you how to avoid a problem during a design and run-time for a form where incorrectly closing this object can save filters and sorts into their properties and alter their behaviour when re-visiting the form.
Continue reading “How to Create an Autokeys Closing Macro in Microsoft Access”

Structuring Queries In Access 2007

how-to-create-a-microsoft-access-database-new-form-2007People prefer to keep complex data sets in databases rather than in flat files because data can be found and grouped more precisely when it is stored in a database. The ability to draw data out of a database depends upon the ability to structure queries, or requests that define specific records. Structuring queries in Access 2007 is relatively easy because Access is designed to handle many different types of operators.

An operator is a special symbol or reserved word that triggers the database to act in a certain way. Access 2007 recognises several types of operators, including comparison operators, arithmetic operators, logical operators and special expressions such as like, between..and, in, and is null. You may also use combinations of these types of operators when structuring queries in Access 2007.

Comparison operators ask Access 2007 to perform a comparison between two values. In a query, a comparison operator can locate all records where a field value is greater than, less than, equal to, not equal to, greater than or equal to, or less than or equal to a specified value. Comparison operators can be applied to all fields that contain a literal value. A literal value is a value that has been directly entered into the field. Access recognizes four literals: text, numbers, dates and times, and constants.

Continue reading “Structuring Queries In Access 2007”