[AccessD] Text Box Control Source Problem

Andy,
   
  You didn't and it did! :-)
   
  Many thanks. Go home in twenty minutes and would have worried about it all night.
   
  Out of curiosity, why doesn't the other work?
   
  Many thanks,
   
  Can go to the pub now
   
  Chris

Andy Lacey <andy at minstersystems.co.uk> wrote:
  I may be missing the point here Chris, in which case I apologise, but
wouldn't

=DSum("DBAdminEventTime","qryIG_Wed")

do it?

--
Andy Lacey
http://www.minstersystems.co.uk




--------- Original Message --------
From: "Access Developers discussion and problem solving"

To: "Access Developers discussion and problem solving"

Subject: [AccessD] Text Box Control Source Problem
Date: 28/11/06 15:42


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

________________________________________________
Message sent using UebiMiau 2.7.2

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


 
---------------------------------
Check out the all-new Yahoo! Mail beta - Fire up a more powerful email and get things done faster.