home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Power-Programmierung
/
CD1.mdf
/
access
/
update11
/
englisch
/
diskinst
/
a11_3e.exe
/
ERRATA.TX$
/
ERRATA.bin
Wrap
Text File
|
1993-06-24
|
8KB
|
199 lines
----------------------------------------
Microsoft Access Version 1.1 ERRATA File
May 1993
----------------------------------------
(C) Copyright Microsoft Corporation, 1993
This document provides complementary or late-breaking
information as a supplement to the standard Microsoft
Access documentation.
------------------------
How to Use This Document
------------------------
To view ERRATA on screen in Windows Notepad, maximize
the Notepad window.
To print ERRATA, open it in Windows Write, Microsoft
Word, or another word processor. Then select the entire
document and format the text in 10-point Courier before
printing.
-------------------------------------
Errata and Omissions in Documentation
-------------------------------------
The following errata and omissions in the printed
documentation were discovered after the books were delivered
for printing. Please mark the changes in your copies of the
books. We apologize for any inconvenience.
Note that if there is a discrepancy between the Microsoft
Access Language Reference and Help, Help is correct. For
example, the Syntax section on page 286 of the ListFields
Method topic is incomplete in the book but complete in
the Help topic.
If there is a discrepancy between an example in NWIND.MDB
and the printed documentation, the example in the database
is correct.
Also, some of these errors may be fixed in later printings
of the books.
Manual: MICROSOFT ACCESS USER'S GUIDE
Chapter: 4, "Importing, Exporting, and Attaching"
Section: "Using the First Row as Field Names"
Page: 75
Add the following paragraph to the end of the section:
"When you import a Microsoft Excel file, Microsoft Access
changes column names that are numeric to the number of
the column in the new table. For example, if the third
column in the Microsoft Excel file is named '44,' it
will be named '3' in the new table."
Chapter: 4, "Importing, Exporting, and Attaching"
Section: "Exporting Data from Microsoft Access to a Word
Processor"
Page: 87
In the fourth item in the bullet list, the field names
Sales-Field, Sales-Field1, and Sales-Field2 should be
changed to Sales_Field, Sales_Field1, and Sales_Field2,
respectively (in each case, the two words should be
separated by an underscore, not a hyphen).
Manual: MICROSOFT ACCESS: INTRODUCTION TO PROGRAMMING
Chapter: 5, "Variables, Constants, and Data Types"
Section: "Referring to Objects in the Database"
Page: 64
In the third block of code on this page, the third line
should read as follows:
Debug.Print formvar(someControl).ControlName
Chapter: 8, "Manipulating Data"
Section: "Parameter Queries"
Page: 137
In the first block of code, the fifth line should read
as follows:
Set DataRecs = Q.CreateDynaset()
Chapter: 9, "Dynamic Data Exchange"
Page: 140
Section: DDE Conversations
In the third paragraph, the last two sentences should
be replaced with the following:
"You can run Access Basic code from a DDE client
application by using the RunCode action in a Microsoft
Access macro. Use a DDEExecute statement in the client
application to run the macro. However, Access Basic code
run from a client application can't perform DDE operations.
For more information, search Help for 'Microsoft Access
as DDE Server.'"
Manual: MICROSOFT ACCESS LANGUAGE REFERENCE
Topic: ApplyFilter Action
Page: 39
In the description of the Where Condition action argument,
the second paragraph should be replaced with the following:
"In contrast to other action arguments, if you use only an
unqualified name in this expression, it refers to a field in
the underlying table or query and not to a control on the
form or report that called the macro."
Topic: DCount Function
Page: 113
The following should be added to the Remarks section,
after the sentence that begins "If expr identifies multiple
fields":
"The following examples show the effects of each when used
with a non-Null field (Ship Name) and a Null field
(Ship Region).
W = DCount("[Ship Name]", "Orders") ' Returns 1078.
X = DCount("[Ship Region]", "Orders") ' Returns 834.
Y = DCount("[Ship Name] + [Ship Region]", "Orders")
' Returns 834.
Z = DCount("[Ship Name] & [Ship Region]", "Orders")
' Returns 1078."
Topic: DFirst, DLast Functions
Page: 140
The following note should be added at the end of the
Remarks section:
"Note: Unsaved changes to records in domain are not
included when you use these functions. If you want the
DFirst or DLast function to be based on the changed
values, you must first save the changes by using the
Update method, choosing Save Record, or moving the
focus to another record."
Topic: DMin, DMax Functions
Page: 147
The following note should be added at the end of the
Remarks section:
"Note: Unsaved changes to records in domain are not
included when you use these functions. If you want the
DMin or DMax function to be based on the changed values,
you must first save the changes by using the Update
method, choosing Save Record, or moving the focus to
another record."
Topic: ListFields Method
Page: 286
The Syntax section should be replaced with the following:
"Syntax 1
Set snapshot = recordset.ListFields()
Syntax 2
Set snapshot = database.ListFields(table | query)"
In the Remarks section, the following rows should be added
to the Argument table:
"Argument Description
database Name of an open database object
table Name of a table that contains the fields
you want to list
query Name of a QueryDef that contains the fields
you want to list"
Topic: OpenForm Action
Page: 348
In the description of the Where Condition action argument,
the text after the first paragraph should be replaced with
the following:
"To open a form and restrict its records to those specified
by the value of a control on another form, use this syntax:
[fieldname] = Forms![formname]![controlname]
The fieldname argument is the name of a field in the
underlying table or query of the form you want to open. The
controlname argument is the name of the control on the form
that is already open."
The last paragraph, which begins "In contrast to other action
arguments," should be deleted.
Topic: OpenReport Action
Page: 355
In the description of the Where Condition action argument,
the text after the first paragraph should be replaced with
the following:
"To open a report and restrict its records to those specified
by the value of a control on a form, use this syntax:
[fieldname] = Forms![formname]![controlname]
The fieldname argument is the name of a field in the
underlying table or query of the report you want to open.
The controlname argument is the name of the control on the
form."
The last paragraph, which begins "In contrast to other action
arguments," should be deleted.