Object Invalid or no Longer Set

  • Thread starter Thread starter tarpon_zeke
  • Start date Start date
T

tarpon_zeke

I have a very strange error that I am getting that I have
never come across before.

This program has been in a production mode on over 15
computers for 6 months. The customer got a new computer
and had it set up by the IT department and this error is
happening only on this new computer.

When the customer runs the program there is a subform on
the main menu that shows the user any open "todo" items
that have been assigned to them but not completed. This
is a very simple table that is driving this form.

On this new computer when the first run the program the
subform on the main menu looks exactly like it should.

If the user goes into the main data entry form and comes
back to the main menu, this "todo" subform then has #name?
in every field and if you try and click on the form the
error "Object invalid or no longer set" comes up about 10
times and you can finally exit the program.

The form the user goes into does nothing to this subform
but for some reason the subform goes away if they go into
this other form.

The computer is running Windows 2000 Professional and the
network is a Novell network. All the other computers are
fine but this one is not acting properly. Permissions and
all seem fine but obviously something is wrong.

Any help or ideas is greatly appreciated.
 
Is the new computer running the same version of Access as the others? If
not, you might want to open the application on the new computer, go into a
code window and try to compile your code. I've had some strange things
happen to applications written in Access 2000 and run in Access 97. One
error was the result of using parenthesis in the date function. Date()
versus Date.
 
tarpon_zeke said:
I have a very strange error that I am getting that I have
never come across before.

This program has been in a production mode on over 15
computers for 6 months. The customer got a new computer
and had it set up by the IT department and this error is
happening only on this new computer.

When the customer runs the program there is a subform on
the main menu that shows the user any open "todo" items
that have been assigned to them but not completed. This
is a very simple table that is driving this form.

On this new computer when the first run the program the
subform on the main menu looks exactly like it should.

If the user goes into the main data entry form and comes
back to the main menu, this "todo" subform then has #name?
in every field and if you try and click on the form the
error "Object invalid or no longer set" comes up about 10
times and you can finally exit the program.

The form the user goes into does nothing to this subform
but for some reason the subform goes away if they go into
this other form.

The computer is running Windows 2000 Professional and the
network is a Novell network. All the other computers are
fine but this one is not acting properly. Permissions and
all seem fine but obviously something is wrong.

Any help or ideas is greatly appreciated.
Click to expand...

Often when databases don't work on one particular machine, it's because
of a broken or missing reference. See if the steps outlined here help:


http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html
 
The reference issue is something I have experienced before
as well but in that case the form never worked in the
first place. The form works when you go into the
program. It only gets this error when you go into another
form in the application. Reports and stuff can be run and
makes no difference but if the user goes into this one
particular form and returns back to the main menu,
the "todo" subform on the main menu gives you the object
invalid error and all the fields have #name?.

One thing I did not include in the earlier email is that
this is running on Access 2002 run time. I even tried to
install a full version of Access to see if it made a
difference and it did not.
 
Yes. All computers are running exactly the same stuff.
They are all running Access 2002 Run Time.

It is a very strange thing because the form starts off
fine and then gets the #name? errors after the user goes
into another particular form in the database and returns
to the main menu with the subform in question.

Confusing because initially it works but then it does not.

As a temporary fix I reset the sourceobject of the subform
back to what it is already bound to and it works but it
slows down the program to an unacceptable level.
 
tarpon_zeke said:
The reference issue is something I have experienced before
as well but in that case the form never worked in the
first place. The form works when you go into the
program. It only gets this error when you go into another
form in the application. Reports and stuff can be run and
makes no difference but if the user goes into this one
particular form and returns back to the main menu,
the "todo" subform on the main menu gives you the object
invalid error and all the fields have #name?.

One thing I did not include in the earlier email is that
this is running on Access 2002 run time. I even tried to
install a full version of Access to see if it made a
difference and it did not.
Click to expand...

Hmm, I don't know if the runtime issue is significant or not. Without
examining both forms and the code behind them, it's hard to say what may
be going on. The first thing that occurs to me is that you may be
experiencing an error on that one computer, due to a broken reference or
faulty installation, that is causing your VB Project to be reset, and
thus some object variable to lose its value. On that computer, what is
the setting for the Error Trapping option? Does the code include
error-handling? Are warnings turned off, such that an error might occur
on that form but never have an error message displayed? Do these forms
have any code in their modules?
 
It is a very simple form. No real code involved at all.
The form is bound to a query. The query is pulling
records out of the "todo" table that are assigned to the
user that logged in (I didn't use access security, I used
my own but the user is stored in a field on the main menu
of the program).

What you are saying is correct, I just can't think of a
reason why it works when you first go into the program
then it no longer works after you go to this one
particular form.

I use this exact same "todo" list feature in almost all my
programs and have never had any problem at all with it.

I know it is something with the configuration of the
computer, I am just not sure what it is.

I have uninstalled, re-installed, made sure the user
logging in to the computer has full permissions on the
computer. Installed full blown access. Nothing seems to
change the problem.

There is error checking in the very little code that can
actually run from this form but there are only 1 or 2
procedures in the form's module. It is really a very
simple form so it is a mystery to me.

Thanks for all your help. It is much appreciated.
 
I am trying to determine if tarpon_Zeke ever solved this issue as I a
having the exact same problem.

Can someone tell me if there is a solution to this problem ?

Thanks


-
cweinand
 
Back
Top