106) 12/2/2003 168799168799  168799.html">HOWTO: Parse a Person's Name into Multiple Variables
(168799) - This article provides a procedure for parsing a single variable containing a person's name into up to 6 parts: Title (Mr., Ms., etc.) First Name Middle Initial(s) Last Name Pedigree (Jr., Sr., III, etc.) Degree(s) (B.S., PhD, etc.)

107) 12/2/2003 195226195226  195226.html">BUG: DAO dbFailOnError causes RecordsAffected to return 0
(195226) - When you run an action query by using Data Access Objects (DAO) and the Microsoft Jet database engine against an ODBC table, if you specify the dbFailOnError argument, the RecordsAffected property always returns 0, regardless of the number of records...

108) 12/2/2003 170721170721  170721.html">OFF97: How to Create and Use a Global Array in VBA Procedures
(170721) - In Microsoft Visual Basic for Applications, you can create a dimensioned array, such as A(6,6), that is available to all procedures in all modules. This article includes sample Visual Basic for Applications routines that demonstrate how this can be...

109) 12/2/2003 180766180766  180766.html">VBA: Sample Code to Determine CD-ROM Drive Letter
(180766) - This article contains sample Microsoft Visual Basic for Applications code that determines the drive letter of the first CD-ROM drive and returns it to a variable as a string. It is then output to a message box. This would be useful for accessing files...

110) 12/2/2003 170549170549  170549.html">HOWTO: Read or Modify User-Defined DAO Properties
(170549) - This article provides two procedures that allow you to read and modify user- defined properties in a Microsoft Jet database.

111) 12/2/2003 169719169719  169719.html">OFF97: Error in Macro Referencing Remote Data Objects
(169719) - If you run a macro that uses objects from the Microsoft Remote Data Object 2.0 library, you may receive the following error message: Run-time error '429' ActiveX component can't create object

112) 12/2/2003 161394161394  161394.html">VBA: Sample Code to Retrieve the Current User Name
(161394) - The "More Information" section of this article contains sample Microsoft Visual Basic for Applications code that calls WNetGetUser (a Windows API function in the file Mpr.dll) to retrieve the user name used to establish a network connection.

113) 12/2/2003 154900154900  154900.html">OFF97: How To Left Justify Cursor in TextBox Control
(154900) - In the Microsoft Office products listed at the beginning of this article, when you display a UserForm that contains a TextBox control, by default the cursor position in the TextBox control is indented. If you want the initial cursor position in the...

114) 12/2/2003 177760177760  177760.html">ACC97: How to Run Macros in Other Office Programs
(177760) - You can use Automation to run a Microsoft Visual Basic for Applications Sub procedure that exists in a document of another Microsoft Office program. This article shows you how to run Sub procedures from four of the Microsoft Office programs that...

115) 12/2/2003 160529160529  160529.html">Sample Code to Return the UNC Path of a Network Drive
(160529) - This article describes how to use a Microsoft Visual Basic for Applications sub-procedure (or macro) and a Windows application programming interface (API) call to return the universal naming convention (UNC) path for a mapped network drive.

116) 12/2/2003 161012161012  161012.html">VBA: How to Create a New Contact Item in Outlook with Automation
(161012) - Advanced: Requires expert coding, interoperability, and multiuser skills. This article shows you how to use Automation from a Microsoft Access form to start Microsoft Outlook and display a new contact screen for input. You can change just one line of...

117) 12/2/2003 239104239104  239104.html">Jet Expression Can Execute Unsafe Visual Basic for Applications Functions
(239104) - Using Jet 3.5x, a user can call unsafe Visual Basic for Applications functions in query statements from all types of Jet applications, such as ODBC or Access. For example, the following statement would result in all files being deleted from a...

118) 12/2/2003 240074240074  240074.html">"Unrecognized Format" Trying to Open Access Database Converted from Pocket Access
(240074) - When you try to open a Microsoft Access 97 database that was converted from a Microsoft Pocket Access database, you may receive the following error message: Unrecognized format After you receive this error message, you cannot open the file in Access...

119) 12/2/2003 253338253338  253338.html">INFO: Office Developer Samples and Tools Available for Download
(253338) - This article contains a list of Microsoft Office Developer samples and tools that are available in the Microsoft Download Center.

120) 12/2/2003 221931221931  221931.html">HOWTO: Return Record's Autonumber Value Inserted into Access DB
(221931) - When a new record is added to an ActiveX Data Objects (ADO) Recordset that contains an Autonumber field, immediately reporting the value of the Autonumber field for the inserted record returns a value of 0. This article describes how to retrieve the...