G
Graham Clements
Hi all,
I am having difficulting with converting a large
database from access 97 to access 2000. It seems to work
fine up till the forms are imported at which point is
halts, opens VBA and brings up the message:
"Compile error: Invalid outside procedure"
Within VBA 'Exit Sub' is highlighted with the following
function:
Option Compare Database
Option Explicit
Exit Sub
Err_Company_DblClick:
MsgBox Err.Description
Resume Exit_Company_DblClick
End Sub
All tables, queries and forms have been imported into
2000. The tables and queries work fine but the forms
fails to open.
What is going wrong and how can I get around it. It
seems absurd that a database created in access 97 cannot
be converted to access 2000 effectively.
Thanks for any help,
Graham
I am having difficulting with converting a large
database from access 97 to access 2000. It seems to work
fine up till the forms are imported at which point is
halts, opens VBA and brings up the message:
"Compile error: Invalid outside procedure"
Within VBA 'Exit Sub' is highlighted with the following
function:
Option Compare Database
Option Explicit
Exit Sub
Err_Company_DblClick:
MsgBox Err.Description
Resume Exit_Company_DblClick
End Sub
All tables, queries and forms have been imported into
2000. The tables and queries work fine but the forms
fails to open.
What is going wrong and how can I get around it. It
seems absurd that a database created in access 97 cannot
be converted to access 2000 effectively.
Thanks for any help,
Graham