Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Rogue item in Access VBE report list

Rogue item in Access VBE report list

Rogue item in Access VBE report list


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?

RE: Rogue item in Access VBE report list

Is it still here after Compac&Repair?


RE: Rogue item in Access VBE report list


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

CODE -->

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

RE: Rogue item in Access VBE report list


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.

RE: Rogue item in Access VBE report list

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close