1) 9/29/2004 207878207878  207878.html">ACC2000: Cannot Import Spreadsheet If Field Name Begins with Space
(207878) - When you try to import a Microsoft Excel spreadsheet into a Microsoft Access database, you may receive the following error message: An error occurred trying to import file '<File Name>'. The file was not imported.

2) 9/29/2004 209482209482  209482.html">ACC2000: Error Previewing Subreports That Call Filter Macro
(209482) - When you print a form or a report that contains a subform/subreport that calls an ApplyFilter macro action in its OnOpen event, you receive the following error message: The action or method is invalid because the form or report isn't bound to a table...

3) 9/29/2004 207836207836  207836.html">ACC2000: Error "Operation Is Not Supported" with OldValue Property
(207836) - When you run code that uses the OldValue property of a control on a form, you may receive the following error message: Run-time error '3251': Operation is not supported for this type of object.

4) 9/29/2004 209261209261  209261.html">ACC2000: Showing All Records (Including Null) in a Parameter Query
(209261) - When you run a query that takes its parameters from a form, no records are returned by the query if you leave the field blank. If you type an asterisk (*) in the field, only records with non-null values are returned. This article describes a method...

5) 9/29/2004 207784207784  207784.html">ACC2000: MS Access Behavior When Importing Data to Fields with Default Values
(207784) - When you import data into an existing Microsoft Access table that has default values specified for certain fields, the default values will not be used to populate any blank fields for the imported data.

6) 9/29/2004 207763207763  207763.html">ACC2000: You Cannot Sum Calculated Controls in Forms or Reports
(207763) - When you open a form or a report, you may see the following behavior: #Error or #Name? is displayed in a text box in the form footer. A parameter box prompts you for the field that is specified in a sum expression within a report.

7) 9/29/2004 210098210098  210098.html">ACC2000: Same Named Module and Procedure Causes Errors
(210098) - When you run a procedure from an object's events, you may receive the following error message: The expression [event name] you entered as the event property setting produced the following error: The expression you entered has a function name that...

8) 9/29/2004 209229209229  209229.html">ACC2000: Update Query on More Than One Table Gives Wrong Data
(209229) - An update query that tries to update more than one table may yield unexpected results.

9) 9/28/2004 207755207755  207755.html">ACC2000: Subform Field Linker Builder Error Creating Links
(207755) - When you click the Subform Field Linker Build button next to the LinkChildFields or LinkMasterFields property of a bound subform property sheet, you may receive the following error message: Can't build a link between unbound forms.

10) 9/28/2004 207751207751  207751.html">ACC2000: OLE Objects Do Not Appear in Output File
(207751) - Novice: Requires knowledge of the user interface on single-user computers. If you output a report from Microsoft Access to another file format, such as .rtf, .txt, .xls, or .html, an OLE object that has been inserted into the report does not appear.

11) 9/28/2004 209193209193  209193.html">ACC2000: How to Return Records in a Many-to-Many Relationship
(209193) - This article shows you how to design a query to return the records from one table in a many-to-many relationship where each of the records returned is related to two records in the other table in the relationship. Note that the many-to-many...

12) 9/28/2004 209185209185  209185.html">ACC2000: Options Dialog Box Items Are Not Visible
(209185) - When you click Options on the Tools menu, some of the option items are not visible.

13) 9/27/2004 197384197384  197384.html">ACC2000: Static Hyperlink on Disabled Subform Appears Enabled
(197384) - When you open a main form that has a subform, and the subform contains a hyperlink, the hyperlink appears to be active. However, if you click the hyperlink to follow it, nothing happens.

14) 9/27/2004 209106209106  209106.html">ACC2000: Table Field Validation Rule Causes Error
(209106) - When you try to save a table that has a field name, control name, or user-defined function in a validation rule, you may receive the following error message: Invalid SQL syntax - cannot use multiple columns in a column-level CHECK constraint.

15) 9/27/2004 197373197373  197373.html">ACC2000: You Cannot Follow Hyperlinks in Totals Query
(197373) - When you create a totals query that uses the SQL aggregate (totals) functions First () or Last () on a Hyperlink field, the query results do not display a usable Hyperlink field. Instead, you see the Displaytext, Address, and Subaddress portions of...