Datasheet

ErrorCode ErrorString

• You may have tried to run a macro or event procedure on a report that

is already open. To use the ApplyFilter action in a report, set the

OnOpen property to the name of the macro, close the report, and then

reopen it.

2584 You can’t use aggregate functions in a page header or footer. The page

header or footer of the report you tried to preview contains a calculated

control with an aggregate function in its expression. If you want to

show the result of an aggregate function in a page header or footer, cre-

ate a hidden calculated control in an appropriate section of the report.

Then create an unbound text box in the page header or footer. If you

are running a macro, use the SetValue action to set the unbound text

box value to the value in the hidden control.

2585 This action can’t be carried out while processing a form or report

event. A macro specified as the OnOpen, OnClose, OnFormat,

OnRetreat, OnPage, or OnPrint property setting contains an invalid

action for the property. When you click OK, an Action Failed dialog

box will display the name of the macro that failed and its arguments.

2586 Microsoft Access changed the MoveLayout and NextRecord properties

to True from False. The macro or Visual Basic function run by the

OnFormat property of one of the sections of the report set both the

MoveLayout and NextRecord properties to False. Having both proper-

ties set to False can make the report print continuously. Revise the

macro or function so that it sets these properties to the values you

want.

2587 Microsoft Access can’t complete the Output operation. The Visual

Basic code you entered contains a syntax error or the Output proce-

dures are not available. Make sure there isn’t a syntax error in your

code. If the syntax is correct, run Setup to reinstall Microsoft Access. If

you want to preserve your security or custom settings, back up the

Microsoft Access workgroup information file. For information on back-

ing up files, search the Microsoft Windows Help index for ‘backing up

files’.

2588 You must select a form to save as a report.

2589 The expression ‘|’ is invalid. Aggregate functions are only allowed on

output fields of the Record Source.

2590 The Var and VarP aggregate functions are not supported in an Access

project.

2591 You can’t change printer properties in the OnOpen event of a report.

2592 You cannot bind a hierarchical report to a DAO Recordset.

Appendixes for Web Site

ART VI