Erroneous Error Question

[Simple]

I've only 4 yrs. Access Experience and am self taught. I only recently began working with code this last year. I assume I am creating my own issues but don't know how. I have been getting error messages that come and go with some code changes.



I've had stack overflow on a passvalue. Can't find form on docmd.openform. The latest is docmd.maximize doesn't work on any of my forms. It just throws an error doesn't even open debugger.

My question is that since in each case I didn't do anything different, just went on to work another part of the project then came back and it worked fine, what am I doing wrong? Most of the stuff I am doing is real minor and hard to screw up. Is access that sensative?

[Simple]

Current error is ".....on open....produced "this error": Procedure declaration does not match desricption of events or procedure having the same name. Oh the code causing the issue...

Private Sub Form_Open(Cancel As Integer)
Me.DoCmd.Maximize
End Sub

Not sure how I've tried just DoCmd.Maximize which is how it was and was working fine. Then I added mousehook and everything was fine. The did something else, don't know, wasn't in code, just form look and feel stuff, then opened form and no bueno...if i remove the above it works...

[RuralGuy]

The proper syntax is: DoCmd.Maximize

[Simple]

Thanks but like I said that is how I had it. It doesn't work when written properly either. It was working fine (written as you showed). Then phht. My overall project seems to be doing this (various errors). Would it help to create a new db and import it all?

[RuralGuy]

It might and is certainly worth the couple of minutes it takes to accomplish along with Compact and Repair. You should check your references for bogus MISSING errors as well.

[Simple]

OK thanks Rural, I will try that then. I've been compacting along the way but I'll try that again too. Sometime access is a tad sensative to novice fingers it seems.