Wednesday, December 29, 2004

Latest MS Access Knowledge Base Articles

Courtesy of

How to use TOP N Query from Microsoft Access 2.0 in VB (147724) - One of the new types of queries added to Microsoft Access version 2.0 for Windows is called a TOP N query. If you have Microsoft Access version 2.0 or higher, and Microsoft Visual Basic for Windows version 4.0 and higher, you can use this type of ...

How to work with the Outlook E-mail Security Update in an Access database (263084) - Describes that you may receive "A program is trying to automatically send e-mail on your behalf" message when you run the SendObject macro action. Or, you may receive a "run-time error '2293'" when calling the SendObject VBA method in Access.

Cannot edit or update a record on an Access form (209571) - You may not be able to edit a record on a form even though the AllowEdits property of the form is set to Yes . When you try to update data on the form, you may receive the following error message: This Recordset is not updateable. If the form is ...

ACC2000: How to Use a Query to Format Data for a Mail Merge (197520) - In a Microsoft Access table, if you've added formatting to the numbers in a Number field, and you send that data to Microsoft Word through a mail merge, the numbers will lose their formatting when they appear in Microsoft Word. In a mail merge, ...

Objects are removed when you convert partial replicas from Access 97 to Access 2000 (263171) - You convert a Microsoft Access 97 partial replica to Access 2000. Then you synchronize the Access 97 partial replica with a converted full replica or with Design Master. All the database objects are removed from the converted partial replica ...

No records returned in query between an Access 2000 table and a linked Access 97 table (244137) - No records are returned for a query that joins a Microsoft Access 2000 (Jet 4.0) table to a linked Microsoft Access 97 (Jet 3.5) table. This happens even though you are certain that there are matching records. This behavior can occur only when all ...

You receive a "Not a Valid Password" error message when you open an Access 97 database in Access 2000 (246033) - When you open a Microsoft Access 97 database in Microsoft Access 2000, and if the database password has 14 or more characters, you may receive the following error message: Not a valid password. To work around this behavior, follow these steps: ...

A newly created Access 97 database is not secure when you convert a security-enhanced Access 2000 database to Access 97 format (198986) - When you convert a security-enhanced Microsoft Access 2000 database to Microsoft Access 97 format, the newly created Access 97 database is not secure. Permissions are reset to their defaults in the newly created Access 97 database. This problem ...

Friday, December 17, 2004

Sorting Out Order Of Events in MS Access Objects

Order of Events for Access Database Objects An excellent interactive article from MS that takes you through the labyrinth...

Thursday, December 16, 2004

Easier MS Access Debugging

A big frustration in debugging in Access 2000 and later is the clunky rigmarole required to check/set error-trapping. Now you can dramatically simplify the process with my new free Access COM AddIn. Ezy Debug is launched from the right-click popup menu in the code window of the Access VB Editor. The applet provides quick access to the Access error-trapping settings in the code window, and once invoked it is available both in the Access Database and VBE window. The current error-trapping setting is displayed and can be changed on the fly... Free download

Improving MS Access Performance

Improve Access Performance by Turning Off Track Name AutoCorrect A performance tip for boosting performance from By default, Access 2000 and higher maintain a list of changes to database objects and will automatically change references to those objects on forms and reports. For instance, changing the name of a field in an Access table will ripple throughout the application, and all references to the field in forms and reports are automatically updated. Unfortunately, Access imposes a tremendous overhead on the AutoCorrect feature... Read the Full Tip

Wednesday, December 15, 2004

New on MSDN:

Smart Access: Invisible Forms Revisited: Park Your Global Values Here! How adding an invisible form to your application can make a number of difficult tasks much easier.

What's New and Different for the Access Developer Moving to SQL Reporting Services Review Microsoft SQL Server Reporting Services, specifically the key advantages, similarities, and differences between Microsoft Access reports and SQL Reporting Services reports.

Friday, December 10, 2004

New MS Office Migration White Papers

Office 2000 to Office 2003 Migration Issues Possible problem areas administrators might encounter when moving from Office 2000 to Office 2003.

Microsoft Office XP to Microsoft Office 2003 Migration Issues Possible problem areas administrators might encounter when moving from Office XP to Office 2003.

Wednesday, December 08, 2004

MS Access Tip: Use Field Descriptions

Often overlooked is the easy way to document tables fields and automatically provide data entry guidance to users. In Table Design view, express the Description for each field as you would describe it to users making data entries. Access automatically displays the description in the Access status bar in a table's datasheet view and in forms.

Monday, December 06, 2004

Hot off the Press:

Moving Your Access 2002 Database to SQL Server 2000 Use this features comparison in preparation for moving your MS Access 2002 database back-end to SQL Server 2000.

Visual Studio Tools for Office, Version 2005 Beta 1 Code Samples

Visual Studio Tools for Office, Version 2005 Beta 1 IntelliSense Code Snippets This MS download contains 200 IntelliSense Word and Excel code snippets for use with Visual Studio Tools for Office, Version 2005 Beta 1.

Wednesday, December 01, 2004

Analyze XML data with MS Excel 2002/2003

A handy tip from Excel 2002/2003 lets you open and analyze an XML file as a native Excel file. You can use all of Excel's analysis tools, including pivot tables and pivot charts, with XML data. Use File Open, and select XML Files from the Files Of Type drop-down list. Navigate to the XML file you want to open, and click Open. Excel displays XML tags as column headings and lists the data in the rows below the appropriate column headings. For example, in an XML Orders file, every Orders element may have Ship Region as a child element. In the worksheet, Excel represents the child element as the column header /Orders/Ship Region/. Excel opens XML files as read-only files, so users can't make changes to the original file while analyzing it in Excel.

New Ms Office Articles from MSDN

Handy Tips When Using MS Word 2003 Tips and VBA code to make your MS Office applications more robust and even provide even more options to users.

Best of Blogs: Visual Studio Tools for Office, Version 2003 Links to blogs that offer first-hand experience and tips for designing, implementing, and deploying smart client solutions built with Visual Studio Tools for MS Office 2003.