[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Method 'Item' fo object 'Forms' Failed

Posted on 2006-04-27
3
Medium Priority
?
456 Views
Last Modified: 2011-09-20
A2000  XP Home Edition

I did a search and replace to change the name of a control.

I now get the message

Error -2146500594
SS Open Form Error "The name of the form"  and
Method 'Item' of object 'Forms' failed.

I can open the form in Design view, but I can't find anything that was misnamed.

What can cause this error and how do I find it?

Thanks

Elton
0
Comment
Question by:katzwhite
  • 2
3 Comments
 
LVL 58

Accepted Solution

by:
harfang earned 2000 total points
ID: 16558706
Hello,

Little chance, but you might try this: change the Record Source, even just adding a dummy space. This will force the form to recreate it's internal list of objects. For example, if you have a *field* called Foo and a *control* called Foo, renaming the control drops also the field from the list. After resetting the record source, you will have both Form.Foo and Form.cboFoo for example.

Search and replace is a tricky thing. If you did that while the form was open, for example, you might have desynchronized VB's compilation state flags.

For serious form corruptions, the  best is to remove it entirely:

* In the immediate pane:
   SaveAsText acForm, "frmBroken", "C:\frmBroken.txt"
* Delete the form
* Repair and compace
* Recompile project
* Back to the immediate pane:
   LoadFromText acForm, "frmBroken", "C:\frmBroken.txt"
* Recompile project

See if that helps.
(°v°)
0
 

Author Comment

by:katzwhite
ID: 16558962
(°v°)

You're wonderful.  I backup often, but had about 8 hours very intense querry work, so I didn't want to go back to the old backup, nor did I want to delete the form and reload from backup as I was afraid I wouldn't remember all the changes to it either.

It'll take awhile to put the form back, as I changed or commented many things looking for the porblem, but I can fix all that now that the form works.

Thanks again,

E
0
 
LVL 58

Expert Comment

by:harfang
ID: 16559322
Thank you for your kind words! I'm happy that this saved your 8hrs of work.
Good luck now!
(°v°)
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question