Object invalid error in Acc 2002 - Microsoft Access / VBA

Owen Jenkins

I have found references to this problem in several threads on this
newsgroup but none provide an answer to explain this problem. So any
further assistance would be very helpful...

I have 2 forms (one in form view-FF, one in datasheet view-FD) which are
open together and which use a query as the recordsource with data from
the same table. When one form (FF) is visible, the other (FD) is hidden.
In some circumstances, entering data onto the FF form gives an 'object
invalid or no longer set' error. When I look at the datasheet form FD,
all the records show #NAME. Any other keystrokes cause repeated object
invalid ... errors which cannot be trapped in the running code. Data can
be entered into the FF OK, but when data is entered into a linked
subform on the FF form, the FD form loses it's recordset.

I understand there may be issues with basing two forms on the same
table, but this can't be the entire answer. The reasons being ...
1. The app has been working now for 120 clients for 4 years.
2. The app works in Acc97 on the same computer on which it doesn't work
in Acc2002.
3. The app works one one computer with a similar configuration as one
where it doesn't work.

Specifially, the app (mde) is written in A97 and converted to A2000 for
clients with A2000/2002. The rogue machine has Access 2002 and Win XP
home. I have checked the references and all are OK. I have
uninstalled/reinstalled my app and Office XP. It happens with mde or
mdb. When I run the A97 version on the same machine with the Acc97
runtime, the app works fine.

Mysterious eh. Is it a M$ issue?

Owen Jenkins
oj@healthbase.c om.au

Nov 12 '05 #1

Subscribe Reply

1408

Well, if you showed the lines of code that got the error, someone could
doubtless tell you the cause!

TC
"Owen Jenkins" <oj@healthbase. com.au> wrote in message
news:3F******** ******@healthba se.com.au...

I have found references to this problem in several threads on this
newsgroup but none provide an answer to explain this problem. So any
further assistance would be very helpful...

I have 2 forms (one in form view-FF, one in datasheet view-FD) which are
open together and which use a query as the recordsource with data from
the same table. When one form (FF) is visible, the other (FD) is hidden.
In some circumstances, entering data onto the FF form gives an 'object
invalid or no longer set' error. When I look at the datasheet form FD,
all the records show #NAME. Any other keystrokes cause repeated object
invalid ... errors which cannot be trapped in the running code. Data can
be entered into the FF OK, but when data is entered into a linked
subform on the FF form, the FD form loses it's recordset.

I understand there may be issues with basing two forms on the same
table, but this can't be the entire answer. The reasons being ...
1. The app has been working now for 120 clients for 4 years.
2. The app works in Acc97 on the same computer on which it doesn't work
in Acc2002.
3. The app works one one computer with a similar configuration as one
where it doesn't work.

Specifially, the app (mde) is written in A97 and converted to A2000 for
clients with A2000/2002. The rogue machine has Access 2002 and Win XP
home. I have checked the references and all are OK. I have
uninstalled/reinstalled my app and Office XP. It happens with mde or
mdb. When I run the A97 version on the same machine with the Acc97
runtime, the app works fine.

Mysterious eh. Is it a M$ issue?

Owen Jenkins
oj@healthbase.c om.au

Nov 12 '05 #2

Similar topics

10548

Object Reference not set

by: Pkpatel | last post by:

Hi, I keep getting this error every time I try to load crystalreportviewer on a webform with a dataset. Here is the error: -------------------------------------------------------- Server Error in '/Cr_Dataset' Application. ----------------------------------------------------------- ---------------------

.NET Framework

11501

value is null or not an object, but its defined?

by: cwizard | last post by:

I'm calling on a function from within this form, and there are values set but every time it gets called I get slammed with a run time error... document.frmKitAmount.txtTotalKitValue is null or not an object... the function is like so: function calc_total() { var x,i,base,margin,total,newmargin,newtotal; base = document.frmKitAmount.txtTotalKitValue.value; margin = document.frmKitAmount.margin.value/100;

Javascript

5990

"error CS1577: Assembly generation failed -- Unexpected exception processing attribute -- System.ArgumentException: Invalid directory on URL."

by: | last post by:

Some time ago I installed VC# 2003, made a small generic project, compile with the allow unsafe flag and I get the error below: "error CS1577: Assembly generation failed -- Unexpected exception processing attribute -- System.ArgumentException: Invalid directory on URL." (If I do not compile with the unsafe flag compiler setting all compiles perfect) After long tracing, I ended up discovering that it is csc.exe installed by the .NET...

.NET Framework

9267

Object test = new Object() <-- Java, best way in C++

by: DrUg13 | last post by:

In java, this seems so easy. You need a new object Object test = new Object() gives me exactly what I want. could someone please help me understand the different ways to do the same thing in C++. I find my self sometimes, trying Object app = Object(); Object *app = Object(); Object app = new Object();

C / C++

36717

Meaning of "Object Invalid or no longer set"?

by: deko | last post by:

I'm getting intermittent "Object Invalid or No Longer Set" errors in my Access 2002 mdb. What causes these errors? Has anyone dealt with this before? I can't trace it because it's not easy to duplicate -- it just show up... I've heard that spurious queries that use Now() or Date() or some other date

Microsoft Access / VBA

2236

Very sticky Object Invalid error

by: deko | last post by:

RE: "Object Invalid or No Longer Set" errors I've had an angelic visitation and the revelation is that my problem, in essence, is due to the fact that I have multiple forms open at the same time whose recordsources draw data from the same table. I use a tabbed interface: frmMain has 4 tabs. On each tab there is a form and at least one subform (datasheet). So we're talking at least 5 subform datasheets, on different tabs, all open at...

Microsoft Access / VBA

4669

object invalid or no longer set

by: TSanders | last post by:

Hello everyone, I hope someone here can help. I created an application in MSAccess 2000 using VBA for a local telco to track their DSL orders. The database is split into a front end and a back end. There are approximately 60 users. 4 of the users receive the error "Object invalid or no longer set" at random times while they are using the application. After trying all the suggestions on Microsoft's site, the error is still occurring....

Microsoft Access / VBA

5624

i'm really desperate: invalid memory alloc request size 0

by: Janning Vygen | last post by:

Hi, tonight my database got corruppted. before it worked fine. since two days i do the following tasks every night psql -c 'CLUSTER;' $DBNAME psql -c 'VACUUM FULL ANALYZE;' $DBNAME before these opertaions i stop all web access. The last months i only did a

PostgreSQL Database

5953

Object invalid or no longer set

by: 4bex | last post by:

Hello there, I am trying to get to the bottom of an 'Object invalid or no longer set' issue, but I am not a database programmer. We have approx 20 users on MS Access 2002 front ends on 2 sites connected by WAN using a SQL 2000 SP4 database backend. 1 site is 24 hours, the other is 9 - 5 operation. We have a SQL database at both sites using replication. Every 10 minutes the data entered at 24hr site is uploaded to 9-5...

Microsoft Access / VBA

9456

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9273

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10032

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9872

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9841

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9711

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

6534

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5141

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

2666

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General