ID codes for CommandBarButtons
When CommandBarButtons are added to a CommandBar in Access their
property defines their icon and their default behaviour:
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 |
![[Cut icon]](../media/images/acccut.gif "Cut icon")
|
21 |
|
Cut |
![[Copy icon]](../media/images/acccopy.gif "Copy icon")
|
19 |
|
Copy |
![[Paste icon]](../media/images/accpaste.gif "Paste icon")
|
22 |
|
Paste |
| |
|
|
|
![[New Record icon]](../media/images/accnew.gif "New Record icon")
|
539 |
|
New Record |
![[Delete Record icon]](../media/images/accdelete.gif "Delete Record icon")
|
644 |
|
Delete Record |
| |
|
|
|
![[Sort Ascending icon]](../media/images/accsortasc.gif "Sort Ascending icon")
|
210 |
|
Sort Ascending |
![[Sort Descending icon]](../media/images/accsortdesc.gif "Sort Descending icon")
|
211 |
|
Sort Descending |
![[Filter icon]](../media/images/accfilter.gif "Filter icon")
|
640 |
|
Filter By Selection |
![[Remove filter icon]](../media/images/accfilteroff.gif "Remove filter icon")
|
605 |
|
Remove Filter/Sort |
| |
|
|
|
![[Page Setup icon]](../media/images/accsetup.gif "Page Setup icon")
|
247 |
|
Page Setup |
![[Print icon]](../media/images/accprint.gif "Print icon")
|
4 |
|
Print |
![[Send Email icon]](../media/images/accsend.gif "Send Email icon")
|
258 |
|
Send Email |
|
Your Access database will look more impressive if you add custom toolbars.
Read More
|
How to create backups automatically in FoxPro or Access using the Windows Scripting Host
Read More
|
Microsoft Access uses an American date format in SQL commands
Read More
|
How to backup an Access database using VBA and DAO
Read More
|
How to create a filename from a datestamp
Read More
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
