ID codes for CommandBarButtons

When CommandBarButtons are added to a CommandBar in Access their Id property defines their icon and their default behaviour:

'-- Create a command bar with three buttons
Set myBar = CommandBars.Add(Name:="Customer", _
            Position:=msoBarTop, _
            Temporary:=True)
With myBar
  .Controls.Add Type:=msoControlButton, Id:=539
  .Controls.Add Type:=msoControlButton, Id:=4
  .Controls.Add Type:=msoControlButton, Id:=644
  .Visible = True
End With

Every button in the Access toolbar system has its own Id code but these are the most useful:

Icon	Id		Description
	21		Cut
	19		Copy
	22		Paste

	539		New Record
	644		Delete Record

	210		Sort Ascending
	211		Sort Descending
	640		Filter By Selection
	605		Remove Filter/Sort

	247		Page Setup
	4		Print
	258		Send Email

Custom Toolbars

Your Access database will look more impressive if you add custom toolbars.

Access 2002 and Office XP

Notes on the launch of Microsoft Access 2002 and Office XP

Frequent, automatic backups

How to create backups automatically in FoxPro or Access using the Windows Scripting Host

American date formats used by Access SQL

Microsoft Access uses an American date format in SQL commands

Backing up an Access Database

How to backup an Access database using VBA and DAO

January 2009

After all our efforts trying to move our FoxPro users onto C# we're now working on transferring one to VB.Net instead. It's another new language but at least the underlying dot Net concepts are still the same.

Alvechurch Data

Alvechurch Data

Database development and training for Birmingham and the midlands

Specialists in Microsoft Access and Visual Foxpro training and development

Phone us on 0121 445 1300, email sales@alvechurchdata.co.uk , or use our contact page