[AccessD] Not In List Event

Rocky Smolin rockysmolin at bchacc.com
Tue Nov 2 12:30:39 CDT 2010


I'm sure it works there.  I've never had this problem with a NotInList
before.  Very strange.  I put the Undo in as well - but that's  only if the
user declines to add the value - doesn't affect adding it to the table.

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:08 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Not In List Event

Hi Rocky

Strange.
It works here - and doubles don't have leading zeroes ...

And inserting the Undo as mention by Jürgen corrected a cancelled entry in
the combo.

/gustav


>>> rockysmolin at bchacc.com 02-11-2010 17:48:28 >>>
Ah, yes.  Forgot that.  But now, since there's no way to get that leading
zero in there, every value I enter gives the error message.  

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 9:31 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Not In List Event

Hi Rocky

Yes. If you wish to display and enter percentage, you will have to enter
percentage as 1.7 or 1.70, not 0.017.

/gustav


>>> rockysmolin at bchacc.com 02-11-2010 17:19:27 >>>
Gustav:

Changing to  dblNewVal = Val(NewData) / 100 and entering 0.017 gives .00017.
dblNewVal is too small by factor of 100 now.

Rocky


--
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