91) 12/7/2003 198522198522  198522.html">HOWTO: Place a Custom Bitmap on an Office Commandbar Button
(198522) - Using Automation, you can modify the Microsoft Office CommandBar to add one or more CommandBarButtons and customize the appearance of those additions with respect to the caption, the tooltip text, and the graphic image on the face. The graphic can be...

92) 12/7/2003 826763826763  826763.html">Special Characters That You Must Avoid When You Work with Access
(826763) - Microsoft Access does not restrict the use of special characters such as a number sign (#), a period (.), or a double quotation (") in the database object names or in the database field names. However, if you do use the special characters you may...

93) 12/7/2003 242002242002  242002.html">PRB: ATL Control Appears Incorrect in Access Report
(242002) - An ATL ActiveX Control does not appear or appears incorrectly when added to a Microsoft Access Report. The same control displays correctly when the Report is in design mode or if the control is added to an Access Form.

94) 12/7/2003 236825236825  236825.html">PRB: #deleted Seen When SQL Server 7.0 Tables Containing Numeric and Text fields Are Opened
(236825) - If Microsoft Access 97 or Microsoft Access 2000 is used to link SQL Server 6.5 or 7.0 tables, which have numeric and text field columns, #deleted is seen in alternate rows if the SQL Server database is created using non default code pages and Sort...

95) 12/7/2003 154569154569  154569.html">ACC: How to Use Automation to Print a Microsoft Word Document
(154569) - This article shows you how to use Automation to print a Microsoft Word document that you are working with in a Microsoft Access function or in a Microsoft Access form's object frame. This article assumes that you are familiar with Visual Basic for...

96) 12/7/2003 257767257767  257767.html">PRB: Cannot Open Pubs Table Image Data Through Microsoft Access Link
(257767) - If you use Microsoft Access and you link to the SQL Server Pubs_info table, by using the logo field, which is Image data, you cannot open the Image. This error occurs: A problem occurred while Microsoft Access was communicating with the ole server....

97) 12/2/2003 172967172967  172967.html">VBA: Reset Method of CommandBars Rebuilds Menu Bar Only
(172967) - When you reset a menu on a built-in menu bar using Microsoft Visual Basic for Applications code, none of the menu items are available.

98) 12/2/2003 170988170988  170988.html">ACC: How to Create a Word 97 Merge Document Using Automation
(170988) - This article shows you how to use Automation to create a Microsoft Word 97 mail merge document to insert merge fields, and then to run the merge. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft...

99) 12/2/2003 159328159328  159328.html">ACC: How to Use Automation to Run Word 97 Mail Merge from Access
(159328) - Advanced: Requires expert coding, interoperability, and multiuser skills. This article shows you how to use Automation to run a Microsoft Word 97 for Windows mail merge in Microsoft Access version 7.0 or 97. For information about how to run a Word 7.0...

100) 12/2/2003 160295160295  160295.html">ACC: How to Use Automation to Find Bookmark in Word 97 Document
(160295) - This article shows you how to use Automation in Microsoft Access to open a Microsoft Word 97 document and to move to a specific location in the document. For information about how to move to a specific location in a Microsoft Word version 6.0 or 7.0...

101) 12/2/2003 186119186119  186119.html">OFF97: How to Programmatically Hide and Unhide the Windows Taskbar
(186119) - By using API calls in Visual Basic for Applications, you can programmatically hide the Microsoft Windows 95 or later, or Microsoft Windows NT 4.0 taskbar. This article shows you how to create the two functions that you need to hide and unhide the...

102) 12/2/2003 142938142938  142938.html">HOWTO: Create a Parameter Query via Data Access Objects
(142938) - This article explains how to create and use a parameter query using Data Access Objects (DAO). A parameter query is a type of QueryDef specific to the Microsoft Jet database engine used by Visual Basic, Microsoft Access, and other products. Parameter...

103) 12/2/2003 168836168836  168836.html">HOWTO: Search for the Last Occurrence of a Substring
(168836) - The InStr() function provides a method to search for the first occurrence of one string (substring) inside another string. However, there is no intrinsic method to search for the last occurrence of a substring. This article provides a sample function...

104) 12/2/2003 170550170550  170550.html">INFO: Format Function and International Settings
(170550) - The Format function does not always return the expected number format with certain international settings. This article explains this behavior and describes how the Format function interprets its parameters.

105) 12/2/2003 168798168798  168798.html">HOWTO: Parse City, State, and Zip Code into Separate Values
(168798) - This article provides a procedure for parsing a single variable containing US City, State, and Zip Code information into three separate variables. The routine supports: Either 5- or 9-digit zip code. Multi-word state names (if preceded by a comma)....