Access MVP (2010-2015)


Limit Number of Record Entries

Every once in a while you may want to restrict how many records can be entered. Maybe because of space limitations on a Report or perhaps you want to limit CD rentals to 4 per Customer or book a specific amount people per room. Whatever the reason here’s some code to make it happen…


 648 total views

Ampersand not showing in Caption

When using an Ampersand (&) in a Label or Button Caption you get an underscore (Jack_Jill) or nothing (JackJill). To get Jack & Jill you need to double up on the ampersands… Jack && Jill.

Why? In Access the Ampersand is used as a Keyboard Shortcut. So, if you have a Button Caption entered like […]

 7,791 total views