[AccessD] Increment or replace?

Rocky - it sounds a little strange to me that they can add to a field by overtyping it with an additional amount (maybe I have misunderstood). Do you mean that the field might hold eg. 100 and if they type +10 then the result should be 110? If they just type 10 then it should replace the 100 with the 10?

If that's right then I think I would separate the fields and have the additional amounts (plus or minus) in a sep. text box. They could still replace the entire amount by overwriting the original amount.

Kath
  ----- Original Message ----- 
  From: Rocky Smolin at Beach Access Software 
  To: 'Access Developers discussion and problem solving' 
  Sent: Tuesday, February 27, 2007 11:04 AM
  Subject: Re: [AccessD] Increment or replace?


  Kath:

  I need them to be able to either add to or replace the value.  This is a
  continuous form, BTW.

  Rocky
   

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
  [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kath Pelletti
  Sent: Monday, February 26, 2007 2:56 PM
  To: Access Developers discussion and problem solving
  Subject: Re: [AccessD] Increment or replace?

  Rocky - couldn't you assume the + sign as the default? Only subtract IF they
  enter a minus sign?

  Kath
    ----- Original Message -----
    From: Rocky Smolin at Beach Access Software
    To: 'Access Developers discussion and problem solving' 
    Sent: Tuesday, February 27, 2007 9:42 AM
    Subject: [AccessD] Increment or replace?


    Dear List:
     
    I have a text box on a sub form bound to a numeric field which contains,
    obviously, a numeric quantity.  
     
    If the user inputs a value in this box preceded by a '+' or '-' sign, I
  want
    to add or subtract the value entered from the current value.  If they
  enter
    a value without a preceding sign, I want to replace old the value with the
    input value.  
     
    I can obviously see if they entered a minus sign because the number is
    negative.  But how can I know if they preceded the input value with a '+'?
     
    MTIA
     
    Rocky
     
    --
    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

  --
  No virus found in this incoming message.
  Checked by AVG Free Edition.
  Version: 7.5.446 / Virus Database: 268.18.4/702 - Release Date: 2/25/2007
  3:16 PM
   

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