Run time error 57 in MS Project 2002

[Steffen]

I have made a userform and when using one or more projects connected to a
resource pool file the user sometimes gets a run-time error and a message
could not find the specified object. The form is loaded with load and then
show and at the end with hide and unload. The form loads the resources in an
array and then in the form. some task fields are also loaded into the form.
The assignements are first loaded into an array and then stored in the form.

 

[J Baird]

Do you have any Local Resources in the schedules where this occurrs?
(Calling server info that's blank for local resources)?

 

[Steffen]

Thank you for answering. But no, I have only resources in the resource pool
file. I have even made it impossible for the users to create new resources in
the project files.

 

[Jan De Messemaeker]

Hi,

You say "resource pool" which makes me think you do not use Server; OTOH,
the expression "Local Resource" is typical for server.
Is there a connection to Server or not?

 

[Steffen]

Hi,

No, there is not a connection to a server. There was no possibility to set
up a server due to network restrictions. Many countries etc.

Steffen

 

[Jan De Messemaeker]

Hi Steffen,

OK, so I can at least try to help (I don't know Server that well)

But before, you surprise me when you say you make it impossible for a user
to introduce resources not in the pool. Does that man you delete them
through VBA after the user has introduced them? Because you can't stop a
user from introducing them!

Now trying to clarify, when you get the error mesage select debug and look
at the "yellow" line in the VBA editor which is the culprit.
What does it say?

Greetings

 

[Steffen]

Hi Jan,

In a class module I use the event ProjectBeforeResourceNew to cancel the
possibility to add a new resource in the ordinary project file.
The VBA stops at the line "Load frmResurstilld". That is the user form where
the user can allocate resources to the tasks.
Sometimes when the user tries to save the file one more problem can occur.
The user cannot save the file with the name it already has. In this case all
VBA-modules and userforms has disappeared. In some way it seems that the
thread is missing and the connection to the existing file is somewhere in the
outer space.

Steffen

 

[Jan De Messemaeker]

Hi Steffen,

Sorry, I give up... never seen any of these.
You could be facing a corruption somewhere.

 

[Steffen]

Hi Jan,

I understand that this is a great problem and unfortunately my customer got
the problem. Thanks anyway for trying to help me.

Regards

Steffen