General

Copy Toolbar Menu

Posted April 26, 2011 By Mike

When you copy a built-in menu (either from an available menu bar or from the Built-In Menus category), Access does not make an independent copy of the original. So, if you copy a menu and then change some of its properties (for example, you delete one of the commands from the menu), you’re also affecting the built-in menu. This is why you must use the New Menu command for the first menu level (File, Edit, View, etc.) on a custom menu bar. If you were to copy the originals and delete unwanted commands from the copies, you’d be deleting them from the built-in menus as well.

Toolbar Context

Posted April 26, 2011 By Mike

If you open one of the built-in toolbars in a context in which the toolbar would not normally be open, the toolbar remains open until you close it. For example, if you open the Customize dialog box while the focus is on the Database window and then open the Form Design toolbar, the toolbar remains open no matter what you are doing in Access. Likewise, if you close a toolbar in a context in which that toolbar is normally open (for example, if you close the Formatting toolbar in a Form window in Design view), that toolbar will remain closed until you open it again within the usual context or from the Customize dialog box.

Y2K

Posted April 22, 2011 By Mike

Although Access 2000 generally interprets 21st century dates with two-digit years correctly, I strongly recommend that you take advantage of the new Use Four-Digit Year Formatting option in Access to avoid all confusion. When you choose this option, Access displays four-digit years in datasheets, forms, and reports. It also converts whatever you type in an expression (such as Criteria in a query) to display four digits.  Choose Options from the Tools menu, and then click the General tab to set this option. I also recommend that you change your Regional Settings in Windows Control Panel to display a four-digit year in the Short Date Style. This will assist your entry and display of year values in other applications — such as Access 97.

Also check out this excellent whitepaper at FMS, Inc.:
Y2K Issues in Microsoft Access