[AccessD] Not In List Event

Yeah, I think that settles it.  The client is one of those where there's
only one main input person and she's very accommodating.  Plus, over time,
the values that they want will be in the list - it's going to be a short
list in any event, to the amount of NotInList occasions will be relatively
rare after the initial lists get built.

Thanks again for your help.

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Wednesday, November 03, 2010 11:25 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Not In List Event

Hi Rocky

Very well.
You can input, say, 0.77 for an entry of 0.77%.

Entering .77 or 08.3 can be considered bad behaviour of the user because
such values would never exist on the list as they would be formatted to 0.77
and 8.30 respectively.

/gustav

>>> rockysmolin at bchacc.com 03-11-2010 17:33:09 >>>
Gustav:

Thanks so much for sending over that test mdb.  It still has the problem if
you enter an item not in the list which begins with a decimal point. And in
this version entering a number not in the list beginning with 0. also has
the problem.  

But if the user is going to enter percentages then they're not going to be
entering numbers less than 1.  So I think this will work around the problem.


Many Thanks.

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Wednesday, November 03, 2010 12:05 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Not In List Event

Hi Rocky

I'll zip my test db to you to study.

/gustav


>>> rockysmolin at bchacc.com 02-11-2010 18:55 >>>
Tried it but no change in behavior.

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Tuesday, November 02, 2010 10:43 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Not In List Event

Hi Rocky

Did you set the format of the table field to Percent?

/gustav


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