ACCDE - "Requested type library or wizard is not a VBA project"

[sonic8]

I found that mentioned in the google links I found, but discounted that, as I thought you would need the code.
Another black mark against Navigation forms then?

I cannot confirm this weird limitation.
I never used Navigation Forms until I recently "inherited" a large project making extensive use of Navigation Forms. In that project there are several Navigation Forms with a lot of code, event procedures and others, and there is no noticeable problem with that.

 

[sonic8]

I cannot confirm this weird limitation.

Oh, Yikes! I can!
I missed the fact, that this error message only happens in an ACCDE. For completely unrelated reasons, I never ran that new project as an ACCDE yet.
Now I just tried it and also get the error "Requested type library is not a VBA project.".
This is unexpected and very unpleasant. :-(

 

[Gasman]

Oh, Yikes! I can!
I missed the fact, that this error message only happens in an ACCDE. For completely unrelated reasons, I never ran that new project as an ACCDE yet.
Now I just tried it and also get the error "Requested type library is not a VBA project.".
This is unexpected and very unpleasant. :-(

Thank you for input, but believe I've found at least one of the reasons why I got this error.

The main form, holding the navigation menu tabs cannot have any code behind it (that is - all form events must be clean). So I deleted and moved out all code there and selected the No on the Form -> Property -> Other -> Has Module, and the errors where gone (so far).
Found this hint deep in ms office copilot...

What would be the issue if you just accept it? As offered in several links?

Private Sub Form_Error(DataErr As Integer, Response As Integer)

If DataErr = -25357 Then
   ' MsgBox "This is a problem error. HIde the error with the Response parameter  "
     Response = acDataErrContinue
End If

End Sub

 

[Geirr]

What would be the issue if you just accept it? As offered in several links?

Private Sub Form_Error(DataErr As Integer, Response As Integer)

If DataErr = -25357 Then
   ' MsgBox "This is a problem error. HIde the error with the Response parameter  "
     Response = acDataErrContinue
End If

End Sub

Thanks, Gasman, I've tried this - added in the OnError in the same main form which have the nav tabs. The result was the action in the tab where disabled/ignored in the sentence the form in the Tab's Navigation Target Name did not opened. But the app could run 'as normal' when select the Tab's which already where ok from the beginning. This routine was in fact the way I got hint on the solution I mentioned earlier which worked perfectly (so far...).