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!frmInventory![Auto Parts].Form
                .OrderBy = "fldPartInvNo"
                .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

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" <todd.penlandNOSPAM@SPAMNOpenland.net> wrote in message 
news:oziSc.782$qB1.594@fe25.usenetserver.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!frmInventory![Auto Parts].Form
>                .OrderBy = "fldPartInvNo"
>                .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 

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

(david)

"Todd" <todd.penlandNOSPAM@SPAMNOpenland.net> wrote in message
news:oziSc.782$qB1.594@fe25.usenetserver.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!frmInventory![Auto Parts].Form
>                 .OrderBy = "fldPartInvNo"
>                 .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
>
>
>
>