Access2002: Docmd.OpenReport Error

[mary.h]

Hello,

I've a database compiling statistical Data which will then be displayed in a diagramm, which is a OLEunbound object in a report.

My code works fine in Access2000 but gives an Error in Access2002 when processing following line:

DoCmd.OpenReport stDocName, acPreview

Has anybody an idea, why ?

Thanks.
Mary H.

 

[Pat Hartman]

Have you determined that there are no reference issues?

Open any module in design view. Click Tools/References and make sure that no references are marked as missing.

 

[mary.h]

Hi Pat,

thank you for your reply.

I checked all references and had the same as in Access2000. But can I then be sure that no one is missing. And if one is missing, how should I know which one, I've at least 40 references in my list (oh god I am blond

Would be very greatful, if you could help me further herein.

Thanks in advance.
Mary H.

 

[Pat Hartman]

Usually the missing one will say MISSING. 40 references seems to be a lot. I rarely have more than 6. Are you using a lot of ActiveX controls?

 

[mary.h]

Hello Pat,

it seems our systems are different. I am working with a german version. I have just that list of ca 40 references which I can check or uncheck. I only get an error message if I uncheck i.e. 'Visial Basic for Applications', saying that this reference can't be unchecked as it is in use.

I have 3 checked references:
'Visual Basic for Applications'
'Microsoft Access 9.0 object library'
'Microsoft DAO 3.6 object library',
where the first two cannot be unchecked.

Are we talking about the same thing?

Thank you so much.

Best regards,
Mary H.

 

[Pat Hartman]

Do you have any ADO code in the db? Try selecting the ADO library.

 

[mary.h]

Access2002 Bug? 2nd-form-command crashes report

Hi Pat,

thank you so much for your hints.

But as I have encountered now, the problem is somewhere else.

The fact is, if I open a form (here:the switchboard) and on a button_click a second form (switchboard still open), Access2002 (remember this is no problem in Access2000) crashes, when I then open any report. And this also happens, if I close the second form before opening the report. What's happening here??

This is even when I open the report from the database window. (No problem if I open the report from the database window, before the 2nd-form has openend)

So my problem is not a "docmd.openreport"-error but ... ???

Does this sound any familiar to you? Or someone else out there?

I try a workaround for now, without opening two forms before opening the report.

Have many thanks for investing time and brain )))

Best regards,
Mary H.