Error 2467:The Expression you entered refers to an object that is closed or doesn't exist

CLarkou

On a client's machine with Office 97, my access program gives an error
"The Expression you entered refers to an object that is closed or
doesn't exist" when I am assigning a value in the checkbox.

chk_multiuser.V alue = 0

What could be the cause of this error ?

Nov 12 '05 #1

Subscribe Reply

19538

Marc

cl*****@memrb.c om.cy (CLarkou) wrote in message news:<db******* *************** ****@posting.go ogle.com>...

On a client's machine with Office 97, my access program gives an error
"The Expression you entered refers to an object that is closed or
doesn't exist" when I am assigning a value in the checkbox.

chk_multiuser.V alue = 0

What could be the cause of this error ?

probably you referred to a form-field name in a module that is not a
classmodule of the form (event-procedure). Outside the form-context
the field-object is not available or (if available) could only be
addressed using an explicit reference to what form in the database
(DAO) or indirectly by passing through byref-parameters or
function-results.

Marc

Nov 12 '05 #2

Pieter Linden

M.***********@u va.nl (Marc) wrote in message news:<ae******* *************** ****@posting.go ogle.com>...

cl*****@memrb.c om.cy (CLarkou) wrote in message news:<db******* *************** ****@posting.go ogle.com>...
On a client's machine with Office 97, my access program gives an error
"The Expression you entered refers to an object that is closed or
doesn't exist" when I am assigning a value in the checkbox.

chk_multiuser.V alue = 0

What could be the cause of this error ?

probably you referred to a form-field name in a module that is not a
classmodule of the form (event-procedure). Outside the form-context
the field-object is not available or (if available) could only be
addressed using an explicit reference to what form in the database
(DAO) or indirectly by passing through byref-parameters or
function-results.

Marc

OOOOOkay....
is the form open? IF not, you can't reference anything on it. The
object that's closed is the form, so the controls on it and the
functions/procedures that are behind the form are not in memory/not
available. Real simple. check to see if the form is open before
running your code. If it isn't, open the form. Then run your stuff.
then return the form to it's original state (open/closed). done deal.

Nov 12 '05 #3

Christina Larkou

The line chk_multiuser.V alue = 0 (assigning a value to a checkbox) is in
the form_load event I am trying to open and is a control on the same
form. The program runs fine on hundrends of machines. Only this machine
has problem.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 12 '05 #4

Similar topics

6982

Exporting From Access to a Dbase iV. via Object. Fails with error The Microsoft Jet Database engine could not find the object

by: chippy | last post by:

Hi, I've a VB script that creates a Access object in a word doc. Here is the full script. It works for all but the Export. Which always fails with a 3011 error. If I do the same in Access as a straight Macro or script it works. Add it as an object and it won't work. HELP.

Microsoft Access / VBA

2129

Using FileStream and XmlSerializer: Gives me the error:The instruction at "0x635e0719" referenced memory at "0x00000000". The momory could not be "read

by: antsays | last post by:

I am trying to serialize a collection to disk using the code provided. This works just fine but when I try do copy and past the xml file to another location or sometimes even just click on the file it gives me the error: The instruction at "0x635e0719" referenced memory at "0x00000000". The momory could not be "read. Could anyone please help out with this

Microsoft Access / VBA

9223

Compile Error: The type or namespace name 'SQLDataSetCommand' could not be found

by: Matthew Louden | last post by:

using System.Data; using System.Data.SqlClient; //etc... SqlConnection conn = new SqlConnection(connString); SQLDataSetCommand myCmd = new SQLDataSetCommand("select * from Test;", conn); DataSet ds = new DataSet(); myCmd.FillDataSet(ds, "test");

C# / C Sharp

6701

WebClient error: The underlying connection was closed: an unexpected error occurred on a receive

by: matt | last post by:

hello, i am using a .NET 1.1 winform to perform webrequests via the System.Net.WebClient class (not a webservice, actually). It uploads values via a POST command & a URL, then receives the html back. nothing too complicated there. except, i am frequently getting the dreaded error: The underlying connection was closed: an unexpected error occurred

.NET Framework

6476

accessing URLs outside firewall with WebClient? error: The underlying connection was closed

by: Mad Scientist Jr | last post by:

For some reason I can't get a WebClient to access an outside URL from behind our firewall. The code works when it runs outside the firewall. I turned on windows authentication in the web.config <authentication mode="Windows" /> and set up IIS to not allow anonymous access. My browser is set up to auto detect the proxy server, so IE/Firefox can access outside pages, so I added code to auto-detect the proxy server.

ASP.NET

2047

Error 2467:The Expression you entered refers to an object that is closed or doesn't e

by: sumit205 | last post by:

Error 2467:The Expression you entered refers to an object that is closed or doesn't exist . DoCmd.OpenForm frm2, WindowMode:=acDialog, OpenArgs:="c" & NewProductID In the debig mode when i place my cursor on the OpenArgs it displaye the error "the Expression you entered refers to an object that is closed or doesn't exist ." what could be the problem Sumit

General

4670

getting Error: Object expected

by: ipy2006 | last post by:

In my HTML I have, <input type="button" class="cartonsumkey" value="Sum Cartons" onclick="sumup(this);" /> In an external file that is called in Head area, I have, function sumup( o ) { var totoalCartons = 0; var row = document.getElementById( 'oceanDeliveries' ).rows;

Javascript

1540

Geting error ---object reference not set to an instance---at bold line----plz reply

by: rksadhi | last post by:

/*Geting error ---object reference not set to an instance---at bold line----plz reply asap thanks in advance*/ cmd = new OleDbCommand ("SELECT e.emp_id,e.email, m.email AS Email FROM emp_details e INNER JOIN emp_details m ON e.spid = m.emp_id AND e.emp_id='" + e_id + "'",conn); dr=cmd.ExecuteReader(); if(dr.Read()) { strmail=dr.ToString(); strmailto=dr.ToString(); }

.NET Framework

4110

error:the string was not recognized as a valid DateTime.

by: mercea | last post by:

hi all, i'm trying to insert the time/date a button was clicked on a gridview and it generates an error:the string was not recognized as a valid DateTime.There is an unknown word starting at index 0 i have changed the culture to en-US but it still doesn't work. i actually created the date/time column after some data had been entered into the table so the column allows nulls. this is my code: InsertCommand="INSERT INTO...

.NET Framework

8411

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

8838

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++

8739

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

8513

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

6176

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5638

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

2740

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1969

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1732

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