ACCESS FEED: RE: [MS_AccessPros] Error 2427

Jumat, 02 Maret 2012

RE: [MS_AccessPros] Error 2427

I've experienced that error on timing issues with the events. If the object hasn't been instantiated yet I seem to get it.

Liz Ravenwood
Database Developer / Programmer
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
Sent: Friday, March 02, 2012 11:04 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Error 2427

Coach-

Error 2427 is:

You entered an expression that has no value. The expression may refer to an
object that has no value, such as a form, a report, or a label control.

Sounds like you have a bug in your code. If you have VBA code, does it compile?

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Nashua, NH)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Coach K
Sent: Friday, March 02, 2012 7:32 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Error 2427

I have a split application. We have 6 users that
Enter info and modify that info. At some point
In the process a manager logs in and
Approves the record by changing its status.
There are two managers that do this.
Sometimes one manager receives error 2427
When saving the record, the other mgr does
Not. Any ideas and what does 2427 really mean

Thanks

------------------------------------

Yahoo! Groups Links

------------------------------------

Yahoo! Groups Links

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.