Report error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gox - 12 Jan 2006 13:29 GMT

Hi all!

My MS Access application (create version: 2k Access) running on PC with
2003 Office.
I work with oracle ODBC driver.
Everything is fine except one report (other report run well). This
report brings back error:

3012. Object <name> already exists.

All reports is created by same way and use same mechanism.

Any suggest? Jet problem maybe?

Thanks!

Reply to this Message

Tim Marshall - 12 Jan 2006 13:37 GMT

> 3012. Object <name> already exists.

> All reports is created by same way and use same mechanism.
>
> Any suggest? Jet problem maybe?

You haven't given us enough information.

You need to look at and consider the following to narrow down your area
of concern:

1) what code is being run with any part of this report?

2) what query/SQL is associated with the report?

We have no idea what any of this could be.

Signature

Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

Reply to this Message

Gox - 12 Jan 2006 19:17 GMT

> 1) what code is being run with any part of this report?

Tim thanks for reply.

I call report from form and I use only this:

stWhere = ""
stDocName = "My_report"
DoCmd.OpenReport stDocName, acPreview, , stWhere

> 2) what query/SQL is associated with the report?

This is a potential problem because I create dynamic query regarding
parameters on form.
First of all, I run my function queryIsExist(MyQueryName) /true-false.
If exist delete query and after that create new query with same name.
If not exist don't delete, only create new query with same name.

This is a main part of function:

For Each dcm In dcms
If dcm.Name = MyQueryName Then
queryIsExist = True
Exit Function ' Quit function once form has been found.
End If
Next

This query is Record Source of report.

On my environment (WinXP-office 2k, and Win2k-office 2k) report run well.

I hope, I gave some more information.

Regards,
Gox

Reply to this Message