![[Alvechurch Data Home Page]](images/weblogo.gif "Alvechurch Data Home Page")
Home
About us
Development
Training
Support
![[MCP logo]](images/smallmcp.gif "Microsoft Certified Professional"){kind=small}
![[BCS logo]](images/smallbcslogo.gif "British Computer Society"){kind=small}
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]](images/acccut.gif "Cut icon"){kind=small}
|
21 | Cut | |
![[Copy icon]](images/acccopy.gif "Copy icon"){kind=small}
|
19 | Copy | |
![[Paste icon]](images/accpaste.gif "Paste icon"){kind=small}
|
22 | Paste | |
![[New Record icon]](images/accnew.gif "New Record icon"){kind=small}
|
539 | New Record | |
![[Delete Record icon]](images/accdelete.gif "Delete Record icon"){kind=small}
|
644 | Delete Record | |
![[Sort Ascending icon]](images/accsortasc.gif "Sort Ascending icon"){kind=small}
|
210 | Sort Ascending | |
![[Sort Descending icon]](images/accsortdesc.gif "Sort Descending icon"){kind=small}
|
211 | Sort Descending | |
![[Filter icon]](images/accfilter.gif "Filter icon"){kind=small}
|
640 | Filter By Selection | |
![[Remove filter icon]](images/accfilteroff.gif "Remove filter icon"){kind=small}
|
605 | Remove Filter/Sort | |
![[Page Setup icon]](images/accsetup.gif "Page Setup icon"){kind=small}
|
247 | Page Setup | |
![[Print icon]](images/accprint.gif "Print icon"){kind=small}
|
4 | ||
![[Send Email icon]](images/accsend.gif "Send Email icon"){kind=small}
|
258 | Send Email |
Hints & tips
The textbox class in Visual FoxPro 9 has a new Autocomplete
property which shows the user the previous values that have
been entered in that textbox.
Autocomplete in VFP 9
Your Access database will look more impressive if you add custom toolbars...
Custom toolbars
FoxPro has always had functions to read and write files at a low level...
Foxpro low level file functions
More...
More pages of hints and tips for users of Microsoft FoxPro and Access databases.