Form1 misspelled or missing

[MMcCarthy]

Mary an existing form becoming corrupted has PLAGUED me for years and I just found out that you can usually still export the corrupted form as text using VBA then reimport it the same way and off you go. Worked like a champ. I have this issue ALL the time, I think it is because of the size of my front end databases.

Yes I've done that. I haven't had the problem since I applied all three updates on office 2000 though.

[Denburt]

Yeah can't copy and paste the version info but I am currently using 2003 (11.6566.8132) SP2. Last I checked all updates were installed and I still had it happen.

[MMcCarthy]

Yeah can't copy and paste the version info but I am currently using 2003 (11.6566.8132) SP2. Last I checked all updates were installed and I still had it happen.

Hmmm!

Don't use 2003 that often. Most of my clients are still on 2000.

[NeoPa]

Hmmm!

Don't use 2003 that often. Most of my clients are still on 2000.

M$ do like to back-port their 'features' :D

[Jim Doherty]

Yeah can't copy and paste the version info but I am currently using 2003 (11.6566.8132) SP2. Last I checked all updates were installed and I still had it happen.

I,ve used SaveFileasText and LoadFromText a number of times as the solution for some corrupted frontends and you're dead right, its never not done the business

[JustJim]

Wow, you have all been busy while I've been away over the weekend! As I said, I'm back in the "real" application after creating some new forms in a copy. The fantom Phorm still exists in this copy, but it is not causing any problems so I'm happy to leave it for the time being.

It seems to have caused quite a reaction from many experienced people though. I love this forum!

Jim

[NeoPa]

Jim,

My advice (should you care to accept it) is "Always work clean".
By that I mean, never knowingly leave 'crap' in your work. It's unpredictable, and may come back and bite you in the rear-end when you least expect it.
I don't know all your circumstances so this is only advice and it's up to you what you choose to do of course.

[JustJim]

Jim,

My advice (should you care to accept it) is "Always work clean".
By that I mean, never knowingly leave 'crap' in your work. It's unpredictable, and may come back and bite you in the rear-end when you least expect it.
I don't know all your circumstances so this is only advice and it's up to you what you choose to do of course.

You are, as always, absolutely correct. I can only plead that I am, as always, under attack from the Dread Foe, the Great Enemy - Time.

I will fix it, I semi-promise!

JIm

[Denburt]

Couple of things I thought you might give a go at is this, Changing Deadmod for your Modules name.

Sub DeleteModule()
DoCmd.DeleteObj ect acModule, "DeadModule "
End Sub


Check to see if the form still exists where you may not be able to see it. If it does you can use something similar to delete it.

   For Each doc In Frmcon.Documents
        Set doc = Frmcon.Documents(doc.Name)
        Debug.Print doc.Name
          Entries = Entries + 1
        'End If
    Next doc

Good Luck let us know if this helps.

[JustJim]

Couple of things I thought you might give a go at is this, Changing Deadmod for your Modules name.

Sub DeleteModule()
DoCmd.DeleteObj ect acModule, "DeadModule "
End Sub


Check to see if the form still exists where you may not be able to see it. If it does you can use something similar to delete it.

   For Each doc In Frmcon.Documents
        Set doc = Frmcon.Documents(doc.Name)
        Debug.Print doc.Name
          Entries = Entries + 1
        'End If
    Next doc

Good Luck let us know if this helps.

When I say that I see the form in Project Explorer, it is under "Microsoft Office Access Class Objects" not under "Modules". I will try this, but using

DoCmd.DeleteObj ect acForm, "Form1"

instead. I'll get back to you.

Jim

[JustJim]

When I say that I see the form in Project Explorer, it is under "Microsoft Office Access Class Objects" not under "Modules". I will try this, but using

DoCmd.DeleteObj ect acForm, "Form1"

instead. I'll get back to you.

Jim

No...
Error 7874
(My application name) can't find the object 'Form1'

Back to the drawing board!

Jim

[Denburt]

Sorry I can't offer more advice I will keep my eyes peeled though. I just opened one of my apps and BAMM corruption so it looks like I am going to have a good day. Probably just another form needing the dreaded export import.

Good Luck and let us know if you find a solution.