Problem with conversion Access forms from Office 97 to Office 2000

G

Guest

Hi,
I convert Access form with 2 sub forms from Office 97 to Office 2000 and in some point of the conversion progress I get
Error message that I had to do compilation to the old db before I convert, and after that I get my db but when I open one of the forms I get error message:
Error Message : "Canno't find project or library!"
and at th window of VB code:
Option Comare Database
Option Explicit

()Sub Form_Current

Dim ParentDocName As String

On Error Resume Next
ParentDocName = Me.Parent.Name

If Err<>0 Then
GoTo Form_Current_Exit
Else
On Error GoTo Form_Current_Err
Requery.[×©× ×˜×•×¤×¡ המשנה]!Me.Parent
End If

:Form_Current_Exit
Exit Sub

:Form_Current_Err
MsgBox Error$
Resume Form_Current_Exit

End Sub

If you know this problem, please help me with details...
thanks a lot
 
E

Emilia Maxim

---------- "Racheli said:
Error Message : "Canno't find project or library!"
and at th window of VB code:
Option Comare Database
Option Explicit

()Sub Form_Current

Dim ParentDocName As String

On Error Resume Next
ParentDocName = Me.Parent.Name

If Err<>0 Then
GoTo Form_Current_Exit
Else
On Error GoTo Form_Current_Err
Requery.[?? ???? ?????]!Me.Parent
End If

:Form_Current_Exit
Exit Sub

:Form_Current_Err
MsgBox Error$
Resume Form_Current_Exit

Racheli,

I'm very sorry, but either is the database corrupt, or something got
messed up when pasting the code in the message. The above code
wouldn't run in any Access version, it has too many syntax errors.

What is the purpose of the code anyway? You don't need to requery the
main form when navigating, this is done automatically by Access
assuming, the LinkMaster and LinkChild properties are correctly set.
Best regards
Emilia

Emilia Maxim
PC-SoftwareService, Stuttgart
http://www.maxim-software-service.de
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top