Sunday, June 27, 2004

Importance of Installing MS Office Patches Access 2000 error, "Network connection may have been lost," might indicate Vbe6.dll conflict. An article for Tech Republic: In Access 2000, receiving the message "Error accessing file. Network connection may have been lost" may not really reflect a connection issue. Instead, it may merely reflect the hazards of patching security holes over time. The solution is another patch, of course.

Access SQL Tip From TechRepublic: Search for two or more single characters in a field. You can use the [ ] wildcard with the Like operator in your queries to search for two or more single characters in a field.

For example, suppose you want to find all customers with the following ZIP codes: 08052, 08053, or 08055. To use the [ ] wildcard, enter the following in your query's Criteria row under the ZIP Code field:

Like "0805[235]"

This expression searches for all field entries whose last character matches one of the characters specified between the brackets. Conversely, to search for all customers that don't live within these three ZIP code areas, place an exclamation point before the list, as shown below:

Like "0805[!235]"

The exclamation point inside the brackets stands for Not in the list. The query results will include all entries whose characters do not match any character in the list within the brackets.

You can combine the [ ] wildcard with any other wildcard character. For example, you can combine the * wildcard character with [ ] to search for any ZIP codes that begin with 0805, 0807, or 0808:

Like "080[578]*"

New from MSDN:

Creating Charts in Excel 2003 Using Visual Basic for Applications Code Methods of creating charts though the macro recorder, using VB and automation.
Building Office 2003 Research Services That Work Offline Give users the benefit of research services whether they are in their office plugged into the network or writing a proposal on a plane without network connectivity.
Migrate Word VBA Solutions to Visual Studio Tools for Office Learn how to migrate an existing Word VBA solution to a Visual Studio Tools for Office solution.
Microsoft Office Access 2003 VBA Language Reference The new objects, properties, and methods in Access 2003.
Microsoft Office Excel 2003 VBA Language Reference The new objects, properties, methods, and events in Excel 2003.
Migrating Word VBA Solutions to Visual Studio Tools for Office Explores the process of migrating an existing solution to managed code in Visual Studio Tools for the Microsoft Office System.

No comments: