couldnt open a report due to some error

[geek]

hi, when i try to open my report, the following error would occur. i've
already done the update but the problem still persists. can anyone tell me
what is the exact root of the problem and advise me on what i should do?

here is the error message:

Visual Basic for Applications (VBA) encountered a problem while attempting
to access a property or method. The problem may be one of the following:

A reference is missing.
For help restoring missing references, see the Microsoft Knowledge Base
article 283806.

An Expression is misspelled.
Check all expressions used in event properties for correct spelling.

A user-defined function is declared as a sub or as a private function in a
module.
Expressions can resolve a user-defined function only if the function is
declared as one of the following:
A public function in a module
A public or private function in a code module of the current form or report
Security in Access is set to Medium or High and the Microsoft Jet 4.0 SP8
update is not installed.
A more recent verion of Jet 4.0 must be installed for Access to function
properly when security is set to Medium or High. To obtain the latest version
of Microsoft Jet, go to Windows Update.

 

[Tom Wickerath]

A reference is missing.
Check out these two documents for solving a possible reference problem:

Solving Problems with Library References (Allen Browne)
http://allenbrowne.com/ser-38.html

Access Reference Problems (Doug Steele)
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

An Expression is misspelled.
Check all expressions used in event properties for correct spelling.

Does your report include any event properties? To determine this, open the
report in design view. Click on View > Properties to open the Properties
dialog, if it is not already displayed. You should see the word "Report" in
the blue title bar of the properties dialog. (If not, click on the small
black square in the upper left corner). Select the Event tab. Scan the list
of events. Do you have any event procedures listed? If so, what are they
(macro, expression or code)? If you see any event procedures, click into the
box. You should see an ellipses button (a button with three dots). Click this
button to open the macro or code that is associated with the event procedure.
If code, try clicking on Debug > Compile ProjectName from the VBE window.

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

hi, when i try to open my report, the following error would occur. i've
already done the update but the problem still persists. can anyone tell me
what is the exact root of the problem and advise me on what i should do?

here is the error message:

Visual Basic for Applications (VBA) encountered a problem while attempting
to access a property or method. The problem may be one of the following:

A reference is missing.
For help restoring missing references, see the Microsoft Knowledge Base
article 283806.

An Expression is misspelled.
Check all expressions used in event properties for correct spelling.

A user-defined function is declared as a sub or as a private function in a
module.
Expressions can resolve a user-defined function only if the function is
declared as one of the following:
A public function in a module
A public or private function in a code module of the current form or report
Security in Access is set to Medium or High and the Microsoft Jet 4.0 SP8
update is not installed.
A more recent verion of Jet 4.0 must be installed for Access to function
properly when security is set to Medium or High. To obtain the latest version
of Microsoft Jet, go to Windows Update.