Rocky Smolin
rockysmolin at bchacc.com
Wed Nov 3 18:28:47 CDT 2010
It was a request from the user - these four percentage fields have a limited number of values, although it's not certain up front what they are. Instead of keying in the percentage in four fields for each transaction, she wanted to be able to pull that value from a combo box. Which from an ergonomic standpoint makes sense. I just want everyone to be happy. :) Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jurgen Welz Sent: Wednesday, November 03, 2010 4:04 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Not In List Event Sorry, I've been off list since my last post as I've been on remote sites and travelling for a few days. I thought this would have been wrapped up on the weekend but obviously not. My only other suggestion would have related to a display mask property or format property of the combo control but it sounds like that was covered. Is it possible you have some regional format setting that varies from what Gustav has? An example may be like the use of commas in place of decimal with European formatted numeric values or some other default format setting that gets lost in the translation? I can't help but think this is some kind of formatting issue. I don't see how it is possible that, if the error is cancelled and the value is in the table, that it should be possible to place the value in the row source by the requery and then set the combo to navigate to that particular value. I don't quite get the concept of storing a list of various scalar values in a combo box so I have a problem conceptualizing how I would work around this. My original suggestion of binding to a numeric PK in hidden column(0) can't possibly fail to work? But why keep a PK on a simple scalar value? Maybe it's not going to be a practical problem for you in the long run given the accomodating user, but it flies in the face of logic. Ciao Jürgen Welz Edmonton, Alberta jwelz at hotmail.com > From: rockysmolin at bchacc.com > To: accessd at databaseadvisors.com > Date: Wed, 3 Nov 2010 11:33:48 -0700 > Subject: Re: [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 > > > -- > 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