JWColby
jwcolby at colbyconsulting.com
Mon Feb 19 12:53:17 CST 2007
LOL, yep. No attachments allowed, as I discovered the other day. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of artful at rogers.com Sent: Monday, February 19, 2007 1:49 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Value verses OldValue I posted a zipped Access file demonstrating how this works. It was only 14k as a zip but apparently it's being held up by the anti-terrorist squad. Arthur Fuller Technical Writer, Data Modeler, SQL Sensei Artful Databases Organization www.artfulsoftware.com ----- Original Message ---- From: Lonnie Johnson <prodevmg at yahoo.com> To: Access Developers discussion and problem solving <accessd at databaseadvisors.com> Sent: Monday, February 19, 2007 12:18:35 PM Subject: Re: [AccessD] Value verses OldValue Susan, Did you find anything else about this? Actually I did not know the property existed. I have always used variables or the tag property to store this. I was going to start using it and an associate says there are also problems with checkbox booleans and comboxes. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us ----- Original Message ---- From: Susan Harkins <ssharkins at setel.com> To: Access Developers discussion and problem solving <accessd at databaseadvisors.com> Sent: Sunday, February 18, 2007 6:12:37 PM Subject: [AccessD] Value verses OldValue I ran into something interesting with the following expression: If ctl.Value <> ctl.OldValue Then It appears that unless you've changed the value, ctl.Value is empty. If there's been no change, shouldn't Value and OldValue been the same? Why is Value empty? This is in a form's Before Update event, which might matter. Susan H. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ____________________________________________________________________________ ________ Now that's room service! Choose from over 150,000 hotels in 45,000 destinations on Yahoo! Travel to find your fit. http://farechase.yahoo.com/promo-generic-14795097 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com