none
Can Not See or Delete a form RRS feed

  • Question

  • I need help!!!

    In Project Explorer the is a reference to "~TMPCLP507761".  From the explorer I can view the code and even open the form, however, I can not find a way to delete the form. It is not visible as a table in the Access Object view. 

    How can I delete this form?

    Thanks

    Brian

    Saturday, February 16, 2019 1:40 AM

Answers

  • Brian

    This is a temporary object that should clear once you close the database. If it does not get cleared your indexing or code page might be corrupt. Compact & Repair your database. Then close and re-open it. If the temporary object is still listed you will need to take another step to eliminate it.

    Open a new, blank database and import all objects into it. Because Access won't see this object it won't be imported.


    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    • Marked as answer by BrianSir Wednesday, February 20, 2019 6:46 PM
    Tuesday, February 19, 2019 6:51 PM

All replies

  • Hi BrianSir,

    I'm not sure I can understand your situation.
    If you want to delete a Form, I suppose, you can.
        

    I'd like to know what is "~TMPCLP507761". According to its name, it would be a temporary file. If this is correct, you could find it by using [Search Box] in File Explorer.
      

    Regards,

    Ashidacchi -- https://ssl01.rocketnet.jp/hokusosha.com/default.html

    Saturday, February 16, 2019 7:39 AM
  • Objects starting with ~ are system driven and normally you shouldn't be messing around with them.

    That being said, have you tried using DeleteObject?


    Daniel Pineault, 2010-2018 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Saturday, February 16, 2019 10:08 AM
  • The form is not visible as a form

     

    I have searched the server and found no reference to TMPCL507761

    Thanks

    Saturday, February 16, 2019 8:49 PM
  • Daniel,

    I had not tried DeleteObject, however, it can not find object.

    Thanks 

    Saturday, February 16, 2019 8:58 PM
  • My question is why are you even trying to delete this?  Why is this such an issue.

    Can you show us where you see this object?

    Did you try without the 'Form_' prefix?


    Daniel Pineault, 2010-2018 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Saturday, February 16, 2019 9:42 PM
  • Hi BrianSir,

    According to an image you provided,
      (1) all Forms are in "Forms" tree-view,
      (2) and there are two tables in your database, i.e. "tmp_SupplyItems" and "tmp_SwapIssueData"  

    If you want to delete a table, select it in "Forms" tree-view and delete. 
    I'm wondering where did you know the name "TMPCL507761",and it can not be found on your image. 
        

    Regards,

    Ashidacchi -- https://ssl01.rocketnet.jp/hokusosha.com/default.html


    • Edited by Ashidacchi Saturday, February 16, 2019 10:41 PM
    Saturday, February 16, 2019 10:39 PM
  • it is on the code side.  It is not a major issue but I am trying to clean up unused items.

    Sunday, February 17, 2019 12:26 AM
  • Hi BrianSir,

    I'm afraid information you provided is/was partial.
    Putting that aside... Why do you think it is unused?
    I guess it is an old temporary information that was created once and not deleted automatically in some reasons (your project, Access, or Windows stopped abnormally).

    What and how did you do for deleting it?

    Regards, 

    Ashidacchi -- https://ssl01.rocketnet.jp/hokusosha.com/default.html

    Sunday, February 17, 2019 12:51 AM
  • Brian

    This is a temporary object that should clear once you close the database. If it does not get cleared your indexing or code page might be corrupt. Compact & Repair your database. Then close and re-open it. If the temporary object is still listed you will need to take another step to eliminate it.

    Open a new, blank database and import all objects into it. Because Access won't see this object it won't be imported.


    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    • Marked as answer by BrianSir Wednesday, February 20, 2019 6:46 PM
    Tuesday, February 19, 2019 6:51 PM
  • Bill,

    Thank you that worked.

    • Marked as answer by BrianSir Wednesday, February 20, 2019 6:46 PM
    • Unmarked as answer by BrianSir Wednesday, February 20, 2019 6:46 PM
    Wednesday, February 20, 2019 6:46 PM
  • You're welcome, Brian.

    When I develop an Access application where I create and delete objects I always take the time to import everything into a new, blank database just so I get rid of any oddball objects like your form. Not only does that keep the database stable but it clears up all the fragments that get lost, thus reducing the file size.


    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Friday, February 22, 2019 6:50 PM