By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,790 Members | 1,398 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,790 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.Value = 0

What could be the cause of this error ?
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
cl*****@memrb.com.cy (CLarkou) wrote in message news:<db**************************@posting.google. 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.Value = 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

P: n/a
M.***********@uva.nl (Marc) wrote in message news:<ae**************************@posting.google. com>...
cl*****@memrb.com.cy (CLarkou) wrote in message news:<db**************************@posting.google. 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.Value = 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

P: n/a
The line chk_multiuser.Value = 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

This discussion thread is closed

Replies have been disabled for this discussion.

Browse more Microsoft Access / VBA Questions on Bytes