Phantom Module

[Paul H]

I have a form with a chart. I saved the form as a report and some strange things started happening. First off when Access wouldn't let rename the report. Everytime I did, the switch back to the original name. I tried making copies and doing Save As with similar things happening. I finally gave up and deleted the report, which it let me do, but it left a code module for the report. Each time I click on the module Access gives me error messages stating the report does not exist. What's more I am getting errors on any code I try to run, the same messages. I'm ready to dump a few hours work and go back to a previously saved version, but I'm peaved and would like to know what's up with this.

Any ideas?

[June7]

Been a long time since had that happen. Think I resorted to either:

1. revert to previous version
2. import everything to new project

You could look in the Access system table MSysObjects and see if there is still a record for that report Name. If there is try deleting. Warning: mess with system tables at risk of dire consequences.

[Paul H]

I'm taking the better part of valor and moving on. These Access charts are treacherous. I'm going to start backing up twice a day. It's hard enough to get these things just right. They tend to blow up very easily.

[June7]

I did find building graphs quite a challenge at first. The dozen plus graphs in my project have been stable now for 4 years.

[Paul H]

Once I get them done, they seemed to stay that way. It's usually when I go one step to far without backing up my work that things go haywire. Ain't that always the case?