Rogue item in Access VBE report list

[TrekBiker]

An item has been appearing in the Reports list of the VB Editor window, the one starting ~TMPCLP below

It related to a report that was changed, updated and renamed a while ago but the Remove option is greyed out.

How can I remove it?

 

[combo]

Is it still here after Compac&Repair?

combo

 

[TrekBiker]

Yes, and have decompiled/recompiled. I also created a query to list all reports using this, and it didn't include the rogue name

SELECT MSysObjects.Name
FROM MsysObjects
WHERE (Left$([Name],1)<>"~") AND 
(MSysObjects.Type)= -32764
ORDER BY MSysObjects.Name;

 

[TrekBiker]

I've also created a blank database and imported all objects into it. No rogue now!

Questions remain where it is in the original and how to delete it, as this would be a quicker solution.

 

[lameid]

Life is a lot simpler if you just accept some things are easier to fix than explain. Such is any kind of file or data corruption in access. Just do what it takes to fix it, move on.