rusty.hammond at cpiqpc.com
rusty.hammond at cpiqpc.com
Tue Nov 28 10:37:25 CST 2006
How about just referencing the field name: =Sum([DBAdminEventTime]) -----Original Message----- From: Chris Enright [mailto:cclenright at yahoo.com] Sent: Tuesday, November 28, 2006 10:04 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Text Box Control Source Problem Thanks Rusty, but tried that. Exactly the same results except for dot read bang! Chris rusty.hammond at cpiqpc.com wrote: Chris, Try =Sum([qryIG_Wed]![DBAdminEventTime]) HTH Rusty -----Original Message----- From: Chris Enright [mailto:cclenright at yahoo.com] Sent: Tuesday, November 28, 2006 9:41 AM To: Access Developers discussion and problem solving Subject: [AccessD] Text Box Control Source Problem I am doing a small job on Access 2K and having strange happenings! I have a series of Text Boxes in the Form Footer which should add up minutes spent by employees on different tasks. However they are all showing #Error If I enter into the Control Source of one Text Box: =Sum([qryIG_Wed].[DBAdminEventTime]) and try to save it, it changes to =Sum(qryIG_Wed.DBAdminEventTime) If I enter =Sum(qryIG_Wed.DBAdminEventTime) and press Enter, it changes to =Sum([qryIG_Wed].[DBAdminEventTime]) If I View the Form I have #Error, however if I have the Properties Box open in View Mode and enter =Sum(qryIG_Wed.DBAdminEventTime) it converts it to =Sum([qryIG_Wed].[DBAdminEventTime]) and the correct figure is shown in the Text Box. I have spent 4 hours on this problem and it is driving me crazy! I have tried importing everything into a new database. Compacted and repaired. In fact everything I can think of short of using a hammer on the computer. (within the next hour). I am sure I am missing something very easy. Someone help me please Chris --------------------------------- Everyone is raving about the all-new Yahoo! Mail beta. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ********************************************************************** WARNING: All e-mail sent to and from this address will be received, scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc. corporate e-mail system and is subject to archival, monitoring or review by, and/or disclosure to, someone other than the recipient. ********************************************************************** -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com --------------------------------- Everyone is raving about the all-new Yahoo! Mail beta. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ********************************************************************** WARNING: All e-mail sent to and from this address will be received, scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc. corporate e-mail system and is subject to archival, monitoring or review by, and/or disclosure to, someone other than the recipient. **********************************************************************