[AccessD] Increment or replace?

artful at rogers.com artful at rogers.com
Wed Feb 28 18:24:32 CST 2007


I thought that I already provided you a way better idea. Trap the plus and minus keys and then increment or decrement the value to suit. Along the lines of:

grab the keystroke
if it's plus
    me.control = me.control + 1
elseif it's minus
    me.control = me.control - 1
end if

Arthur 



----- Original Message ----
From: Rocky Smolin at Beach Access Software <rockysmolin at bchacc.com>
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Sent: Tuesday, February 27, 2007 12:01:27 PM
Subject: Re: [AccessD] Increment or replace?


Well, I slept on it but it didn't do any good.  It's JC's fault.  This was
working just fine as an unbound form :o)

So I think for each field where I need this capability, I have to use a
popup form triggered by the click event, collect the number from the user as
text and process it.

Any better ideas anyone?

TIA

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 4:28 PM
To: Access Developers discussion and problem solving
Subject: Re: [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
--
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


More information about the AccessD mailing list