requested type library or wizard is not a vba project

deepcec9

Registered User.
Local time
Today, 00:34
Joined
Oct 7, 2015
Messages
33
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
 
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.
 
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
 
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.
 

Users who are viewing this thread

Back
Top Bottom