Develop on office 2003, run on Office 2002

N

NNlogistics

I have been developing on a system with Office 20003 (File structure 2000)
and running on a system running Off 2002 and Off 2000 - no problems until
recently

When I try to open front end on Off 2002(Haven't tried Off 2000 yet), which
open frmMainMenu. I get
'An Error Occurredwhile load form_frmOrder'
Do you want to Continue loading project?

When I say Yes
'Invalid Procedure Call or Argument.

frmOrder is opened with command button on frmMainMenu

If I try to Compile, I get same error.

'Invalid Procedure Call or Argument.

Not Sure how to proceed.
 
J

Jerry Whittle

What happens when you open the same file, not a copy but the same file, in
A03? If it works there, you probably have a references problem on the other
machines.

If it doesn't work, there's a very good possibility that the form, and
therefore the database, is corrupt. Try using a recent backup and see if it
works.
 
N

NNlogistics

Jerry

First of all, I am sorry for the multiple posts. I got an error while
posting and it appeared it didn't post.


I was able to put both the backend and frontend on a Network drive and try
from each system. The Office 2003 works and I get the error on the 2002
system. I tried the DB again on the 2003 system after I tried on the 2002
system and it still was fine.

I have the following reference on the 2003 system
Visual basic for Applications
MS Access 11.0 Library
OLE Automation
MS Active X Data Objects 2.1 Library
MS VB for Application Extensibility 5.3

I have the same 5 references on the 2002 system except
MS Access 10.0 Library < different version>



The onlt difference
 
N

NNlogistics

--
Thanks for any assistance


NNlogistics said:
Jerry

First of all, I am sorry for the multiple posts. I got an error while
posting and it appeared it didn't post.


I was able to put both the backend and frontend on a Network drive and try
from each system. The Office 2003 works and I get the error on the 2002
system. I tried the DB again on the 2003 system after I tried on the 2002
system and it still was fine.

I have the following reference on the 2003 system
Visual basic for Applications
MS Access 11.0 Library
OLE Automation
MS Active X Data Objects 2.1 Library
MS VB for Application Extensibility 5.3

I have the same 5 references on the 2002 system except
MS Access 10.0 Library < different version>



More Info
I swapped the 11.0 Library for the 10.0 - no difference????????????
 

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