ACCESS, EXCEL LINKING LIMITS
Links go only so far between Access and Excel. If you create a link table in Microsoft Access 97 that links to a worksheet in an Excel 97 for Windows workbook, be careful. If you change a value or values in the link table using Access, open the workbook in Excel, AND if one or more formulas in the workbook refer to the changed values, you may get recalculation errors. Microsoft's work-around: Open the workbook in Excel and press Ctrl-Alt-F9. This will recalculate all the workbook's values. However, if you again make changes through Access, you'll need to go through the same ritual.
2000
Microsoft has identified a problem you may experience with Access 2000. The problem occurs when Access 2000 improperly evaluates an If Then Else expression comparing a variable that is null. Microsoft's solution is to use IsNull() check on variables in the If Then Else expression. Rewrite the expression to include IsNull(), as in the following example from Microsoft.
The expression below will not evaluate properly if strName or txtName is Null.
If strName = txtName then
strName = '1'
Else
strName = '2'
End if
Change the expression to:
If strName = txtName and Not IsNull(strName) and Not IsNull(txtName)
then
strName = '1'
Else
strName = '2'
End if
NUMLOCK PROBLEM IN ACCESS 2000.
Having trouble keeping your NumLock key on while using Access 2000?
Microsoft has acknowledged a problem with Access 2000 where the
NumLock key keeps turning off. A well-known bug in all versions of
Access causes SendKeys to switch off the NumLock key. Unfortunately,
no solution is available at this time. Keep an eye on the Microsoft
Support Web site for a future fix.
97
95
6.0
|