Navigation form

[irade92]

I use navigation form and compiled ACCDE file..When I click on a navigation button I get this message: Requested type library or wizard is not a VBA projet..When I click Ok it goes on and open another form...
I dont want this message to show...What should I do?
Thanks

 

[Isskint]

There appears to be many possible causes of this error. The only 'FIX' i know of is to trap that particular error code and ignore it. In your Error Trapping do a;

If Err.Number <> X then '...do error routine. where X is the ErrorNumber for your error.

If you can identify exactly where this error is being produced, someone may be able to help further.

 

[irade92]

There appears to be many possible causes of this error. The only 'FIX' i know of is to trap that particular error code and ignore it. In your Error Trapping do a;

If Err.Number <> X then '...do error routine. where X is the ErrorNumber for your error.

If you can identify exactly where this error is being produced, someone may be able to help further.

thenks for your effort but there is no error number..I cannot see it..this message shows only in ACCDE file format , not in others

 

[mpspeer]

Put this code in the OnError event of the main nav subform.

[COLOR=#333333][FONT=Times New Roman]Private Sub Form_Error(DataErr As Integer, Response As Integer) 
   If DataErr = -25357 Then
      Response = acDataErrContinue
   End If
End Sub

[/FONT][/COLOR]

 

[snake5463]

Hello !
Sorry to dig up this topic but I am having the same problem since 3 days and can't fix it!
I have an application and the main form is a navigation form with 2 horizontal level tabs.
When i run into accdb there is no problem at all and all works fine (i've tried on many computers). The Back end db is on the same folder and that's all.
When i compile it to an accde the error msg appear ( when I click, whatever the navigation tab is ).
So i try to put the solution of Mpspeer but the problem is that after the msg appear, the form stay on the 1st tab ( I need to click again on a tab to go on it ).
The error msg appears only once, at the first click.
Please, help me I'm really lost here ... -_-

Regards, Simon.