runtime error

[Jessica]

Hello All,

I made a database using Access 2003 I converted it to Access 97 and
tried opening a report and get a runtime error 2121. When I go to debug
this line is highlighted

DoCmd.OpenReport "Bush", acViewPreview, , "UPC = '" & StrUPC & "'"

I have a total of 7 reports in my database and only two result in this
runtime error. I am not sure if this may be the reason but the two
reports that will not open have a event procedure
=Choose(Month(Date()),"A","B","C","D","E","F","G","H","J","K","L","M")

All reports open fine in Access 2003.Any thoughts on why this doesn't
work in Access 97?

TIA,
Jess

 

[Brian]

Hello All,

I made a database using Access 2003 I converted it to Access 97 and
tried opening a report and get a runtime error 2121. When I go to debug
this line is highlighted

DoCmd.OpenReport "Bush", acViewPreview, , "UPC = '" & StrUPC & "'"

I have a total of 7 reports in my database and only two result in this
runtime error. I am not sure if this may be the reason but the two
reports that will not open have a event procedure
=Choose(Month(Date()),"A","B","C","D","E","F","G","H","J","K","L","M")

All reports open fine in Access 2003.Any thoughts on why this doesn't
work in Access 97?

TIA,
Jess

I believe that the Choose function did not exist until Access 2000. You'll
have to write your own for Access 97.

 

[Douglas J. Steele]

I believe that the Choose function did not exist until Access 2000.
You'll
have to write your own for Access 97.

No, the Choose function exists in Access 97.

Are the reports based on a query or a table? If a query, does the query work
in Access 97? If a table, can you open the table? What datatypes are the
fields in the table(s)? Access 97 doesn't recognize the Decimal data type:
if you've used that, that may be your problem.

 

[Jessica]

Hi Douglas,

My reports are based on a query and the data type are not decimal. I
thought since just two of my reports that wouldn't open was because of
the choose function and thought maybe I would have to check a reference
in order for them to open.

Thanks,
Jess