by Jimmy Simp » Thu, 22 Jan 2004 01:52:57
1. Access Run time 2003 and Access 2003 on Termianl Server (Windows Server 2003)
2. Access 2007 Run-time Error 2467 when accessing a listbox value on a sub form
I have a database that has been in production on Access 2003 for quite
some time and has run without errors.
A user's machine was recently upgraded to Access 2007 and now the
database throughs a Run-time Error 2467 "The Expression you entered
referes to an object that is closed or does not exist" on the
following line that references a listbox value on a sub form.
If Nz(Me.sfrm_Consultant_Contract_Request.Form.Cmb_Consultant.Value) =
"" Then
.
.
.
I changed the code to
If Nz(Forms!
frm_Main.sfrm_Consultant_Contract_Request.Form.Cmb_Consultant.Value) =
"" Then
.
.
.
and still get the same error. Both verisions of the code work fine in
Access 2003.
Anyone have a solution or an idea why the object reference chokes in
Access 2007?
Thanks in advance.
Keith E.
3. Access Run time 2003 and Access 2003 on Termianl Server (Windows Server 2003)
4. Test Access Application will work on Access Run-time
5. Run-Time error 2447 with Access 2003 for 2002 Access switchboard
6. Access 2002 Run-Time removes license from Access 97
7. Converting Access XP to Access 2003 (Run-Time error 2004)
8. Access Installer Runs Each Time Access is Executed
9. Access 2003 >> Access 2007 (Run-time error 2467)
10. MS - Access Application to be run on mechines without MS Access installed
11. Running Access 97 after installing Access 2003.
12. Running an Access DB on a computer w/out access installed
13. How do I access a file without changing Last Access time?
14. How to change report sort order at run-time in access 2002
15. Changing Text Box Size and Location on a form, at run time with Access Xp