requested type library or wizard is not a vba project

[deepcec9]

Created ACCDE database, on selecting a level 2 navigation form I get this error "requested type library or wizard is not a vba project"
all other forms are working fine, error is on only one form.

Created an OnError event for the main navigation form:

Private Sub Form_Error(DataErr As Integer, Response As Integer)
If DataErr = -25357 Then
Response = acDataErrContinue
End If
End Sub

No error now, but the form is not working

 

[Uncle Gizmo]

It might be an idea to create a new blank database and then copy all your objects from the old database into the new database. Don't forget to make a backup database before you do any major alterations.

 

[EmmanuelLan]

I know this is an old post, but I want to share the solution to this.

So, the error control will hide the error, but Me.NavigationSubform.SourceObject = "FormName" will simulate the click. It will load the form it is supposed to. It is working perfectly on my end now.

If DataErr = -25357 Then
Response = acDataErrContinue
Me.NavigationSubform.SourceObject = "FormName"
Else
MsgBox "Error: " & DataErr & vbNewLine & vbNewLine & AccessError(DataErr), vbCritical + vbOKOnly, "Error in Form_Error"
End If

 

[theDBguy]

I know this is an old post, but I want to share the solution to this.

So, the error control will hide the error, but Me.NavigationSubform.SourceObject = "FormName" will simulate the click. It will load the form it is supposed to. It is working perfectly on my end now.

If DataErr = -25357 Then
Response = acDataErrContinue
Me.NavigationSubform.SourceObject = "FormName"
Else
MsgBox "Error: " & DataErr & vbNewLine & vbNewLine & AccessError(DataErr), vbCritical + vbOKOnly, "Error in Form_Error"
End If

Hi @EmmanuelLan

Welcome to AWF!

That's an interesting solution that I didn't even try when I wrote this blog a while back.

Requested type library or wizard is not a VBA project

Do you use Navigation Forms in your database projects and have seen this error message? If so, please read on to hear about my experien...

thedbguy.blogspot.com