Gary Kjos
garykjos at gmail.com
Tue Feb 27 12:30:59 CST 2007
You got some kind of input mask or format on it? GK On 2/27/07, Rocky Smolin at Beach Access Software <rockysmolin at bchacc.com> wrote: > Gary: > > No, the "+" sign is not part of the input. Access is stripping it off. > > I entered +50 and in the before update event tried both > > MsgBox Left(Me.QuantityDue, 1) > > and > > MsgBox Left(Trim(str(Me.QuantityDue)), 1) > > and both printed 5. > > Rocky > > > > > > > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos > Sent: Tuesday, February 27, 2007 9:56 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Increment or replace? > > You can't just do an instring function in the before update event for the > control and if you find a + or - sign add the value and if you don't you > replace it? > > Or even a left or a right to compare for a + or - sign? then do the > corresponding math or replacement? > > GK > > On 2/27/07, Rocky Smolin at Beach Access Software <rockysmolin at bchacc.com> > wrote: > > 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 > > > > > -- > Gary Kjos > garykjos at gmail.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/703 - Release Date: 2/26/2007 > 2:56 PM > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Gary Kjos garykjos at gmail.com