On Open bug in new Access2003

  • Thread starter Thread starter Max Yaffe
  • Start date Start date
M

Max Yaffe

Dear Group,

I'm just starting to run an Access MDB in Access 2003. It was created
in Access 2000. I get an error when I open a form, to wit:
The expression On Open you entered as the event property setting
produced the following error: Expected: identifier.
* The expression may not result in the name of a ...[Event Procedure]
* There may be an error evaluating the fuction, event or macro.
Click to expand...

So I deleted the offending "Form_Open" function and the Form opened
OK, albeit without the correct data present because the function was
missing. Then I entered a new default event function which looks
like:
Public Sub Form_Open(Cancel As Integer)

End Sub
Click to expand...

And the error reoccurs. I looked in the KB without success.

The code works fine on Access 2000

Any ideas?

Thanks
Max
 
If it's not incredibly long, can you post the code?

Max Yaffe said:
Dear Group,

I'm just starting to run an Access MDB in Access 2003. It was created
in Access 2000. I get an error when I open a form, to wit:
The expression On Open you entered as the event property setting
produced the following error: Expected: identifier.
* The expression may not result in the name of a ...[Event Procedure]
* There may be an error evaluating the fuction, event or macro.
Click to expand...

So I deleted the offending "Form_Open" function and the Form opened
OK, albeit without the correct data present because the function was
missing. Then I entered a new default event function which looks
like:
Public Sub Form_Open(Cancel As Integer)

End Sub
Click to expand...

And the error reoccurs. I looked in the KB without success.

The code works fine on Access 2000

Any ideas?

Thanks
Max
Click to expand...
 
Thanks anyway -- I found it.

The "expression On Open ... event" in the error message was a red
herring. I thought something was wrong with Form_Open() which is
associated with the On Open event. However, the message was due to
the compiler choking on something in a completely different spot.

Max

If it's not incredibly long, can you post the code?

Max Yaffe said:
Dear Group,

I'm just starting to run an Access MDB in Access 2003. It was created
in Access 2000. I get an error when I open a form, to wit:
The expression On Open you entered as the event property setting
produced the following error: Expected: identifier.
* The expression may not result in the name of a ...[Event Procedure]
* There may be an error evaluating the fuction, event or macro.
Click to expand...

So I deleted the offending "Form_Open" function and the Form opened
OK, albeit without the correct data present because the function was
missing. Then I entered a new default event function which looks
like:
Public Sub Form_Open(Cancel As Integer)

End Sub
Click to expand...

And the error reoccurs. I looked in the KB without success.

The code works fine on Access 2000

Any ideas?

Thanks
Max
Click to expand...
Click to expand...
 
Back
Top