Finding Control Names for Use in XML Code

If you want to assign a familiar Access image to a button on the Ribbon, you need to know the name of the standard Access control that uses this image, so you can set the imageMso argument for the button with that name. You can download an Excel worksheet AccessRibbonControls.xls with this information from 432 9d9e9-4d11-46a5-8 98d-23e4f331e9ae amp displaylang en on the Microsoft web site. Even though Office 2007 has been released, the latest worksheets of control names were prepared during the...

Using Excel Templates to Create Formatted Worksheets Filled with Access Data

If you want to produce a more formatted worksheet, you can prepare an Excel template and format it as needed for example, adding a large, centered title and column headings with appropriate text, perhaps in a larger or bolder font than the data area. Then, instead of using the Excel command on the Ribbon, use VBA code to export the Access data row by row to the data area of a new worksheet created from the template. I created a set of queries for archiving data, again using the sample Northwind...