473,666 Members | 1,992 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Method 'Form' of object '_SubForm' failed

This has really been my day for wierd problems sorting one of my forms (a
subform actually)... so here's another one.

I am now receiving the following error

Run-time error '-2146500594 (800f000e)':

Method 'Form' of object '_SubForm' failed

The code breaks on the first line of the following section of code:

With Forms!frmInvent ory![Auto Parts].Form
.OrderBy = "fldPartInv No"
.OrderByOn = True
End With

Now...the wierd part is that this code was working perfectly for the last
several days until tonight. This code runs EVERY time the main form loads
and I have never received any error message until now.

I read a few posts in other forums and got the impression that reinstalling
Access might be the best thing to do - so I did that. No good. Then I ran
the application on another computer and got the same error there.

Now I'm stumped. Has anyone else experienced this and found a solution?

Thanks!
Todd


Nov 13 '05 #1
2 10329
Hi Todd

The message suggests that your database is partially corrupt.

Decompiling might fix it, or follow these steps to rebuild it:
1. Create a new (blank) database.

2. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
(This 'feature' is a cause of many problems.)

3. Import everything from the broken database:
File | Get External | Import

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Todd" <to************ ****@SPAMNOpenl and.net> wrote in message
news:oz******** *******@fe25.us enetserver.com. ..
This has really been my day for wierd problems sorting one of my forms (a
subform actually)... so here's another one.

I am now receiving the following error

Run-time error '-2146500594 (800f000e)':

Method 'Form' of object '_SubForm' failed

The code breaks on the first line of the following section of code:

With Forms!frmInvent ory![Auto Parts].Form
.OrderBy = "fldPartInv No"
.OrderByOn = True
End With

Now...the wierd part is that this code was working perfectly for the last
several days until tonight. This code runs EVERY time the main form loads
and I have never received any error message until now.

I read a few posts in other forums and got the impression that
reinstalling
Access might be the best thing to do - so I did that. No good. Then I
ran
the application on another computer and got the same error there.

Now I'm stumped. Has anyone else experienced this and found a solution?

Thanks!
Todd

Nov 13 '05 #2
Decompile (using the /decompile command line option on MSACCESS.EXE)
and Re-compile. You may just be seeing a code loading failure.

(david)

"Todd" <to************ ****@SPAMNOpenl and.net> wrote in message
news:oz******** *******@fe25.us enetserver.com. ..
This has really been my day for wierd problems sorting one of my forms (a
subform actually)... so here's another one.

I am now receiving the following error

Run-time error '-2146500594 (800f000e)':

Method 'Form' of object '_SubForm' failed

The code breaks on the first line of the following section of code:

With Forms!frmInvent ory![Auto Parts].Form
.OrderBy = "fldPartInv No"
.OrderByOn = True
End With

Now...the wierd part is that this code was working perfectly for the last
several days until tonight. This code runs EVERY time the main form loads
and I have never received any error message until now.

I read a few posts in other forums and got the impression that reinstalling Access might be the best thing to do - so I did that. No good. Then I ran the application on another computer and got the same error there.

Now I'm stumped. Has anyone else experienced this and found a solution?

Thanks!
Todd

Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1284
by: Bill Clark | last post by:
I just had MS Access 97 loaded on my machine. When I try to use the Chart Wizard, I get an error stating: Method 'Form' of object '_Subform' failed Any thoughts? Is there something that isn't loaded that allows me to access the Chart Wizard? If so, do I have to completely reload Access? Thanks
1
4850
by: boxim | last post by:
hi all, I'm having a few problems whereby my application is hanging when using the Invoke method of a form's control. Basically, when a user clicks a button on the form, it calls a remote function, which in turn fires an event that is caught by the form. The form then need to add a value passed in the event to a form object, however, when using the Invoke method, it just hangs.
3
2221
by: BakelNB | last post by:
I am new to the .Net environment, so please bear with me. I am passing a form object (e.g. formA) to an existing form (e.g. formB) by setting a property value defined in formB to hold the formA object. Please keep in mind that formB is defined in a separate library project. I then display formB. Once formB is displayed, I have code in a double click event procedure in formB to display formA by getting the form object throught the property...
2
4722
by: Lauren Wilson | last post by:
Hi folks, I have an Access 2003 app that works perfectly on my computer. However, when we install it on OTHER computers that ALSO have access 2003 we get an error on startup: Error: -2147467259 Method 'Visible' of object 'ComandBar' failed! At this point, I am stumped. Anyone have a clue why this is happening?
2
6060
by: Reginald Bal | last post by:
Hello, I created a main form with 2 subforms. In an attempt to move to the next record (or new record) on the main form I get the error " Method 'requery' of object '_Subform' failed". The database closes after answering the popup window (Microsoft Access has encounterd a problem and needs to close. .....) Does anybody has an idea why I'm having this problem?
0
1370
by: mse07 | last post by:
hi for every one i using program for send e-mail and i use 'IDHTMLEdit' to load text file with message but after i load file and run program ,compiler show following messagebox: Run-time error'-2147418113(8000ffff)': Method 'DocumentHTML' of object 'IDHTMLEdit' failed
4
15480
by: ielamrani | last post by:
Hi, I am getting this error when I try to export to an excel sheet. When I click on a button to export the first time it's fine, I rename the exported excel sheet and I try to export it again and I get the error: Runtime Error 1004: Method ‘Cells’ of Object ‘_Global’ failed It highlight this line: Range("A1:L1").Select sorry the code behind the button is long: . Dim stDocName As String stDocName = "QFinal4"
0
1243
by: kaushalgajjar | last post by:
Hi, I had created an active-x control (ocx) in vb6 and i have used in VB.Net and HTML using ClassId reference and the active-x was working fine with ASP.Net, HTML and VB6. Now the active-x is created again with XML. I have used XMLHTTP object to communicate with a server and DOMDocument. I have also used a few API function for local network ping. and build a new active-x control. Now it is working fine with vb6, vb.net Winforms but not...
0
1772
by: calimerotuttonero73 | last post by:
hi, this is the problem : "-2146500594 (800f000e) : method 'form' of object 'subFom' failed " it is displayed when i try to use a Access file. The file was created using ACCESS 2003 ITA and should be use with ACCESS 2007 PL. We installed OFFICE 2007 POL on 3 italian pcs already having office 2003, and both ACCESS and the file work. But if we open that file on a pc where XP POL and OFFICE 2007 PL are installed, once we have tried to push a...
0
8445
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8871
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8781
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8551
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8640
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7386
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
4198
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2771
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1776
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.