Bob Gajewski
rbgajewski at roadrunner.com
Wed Apr 10 06:51:22 CDT 2013
Another boy, or another problem? Bob Gajewski -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Wednesday, April 10, 2013 00:11 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Not In List Not the Right Solution No worries - it always stuns me too when I can't get the behavior I want from some basic function in my program. But I raised two boys so not being able to elicit the behavior I want shouldn't be so foreign. I've got another one brewing - but I don't want to spoil the surprise. This one will be a lot harder than Not In List. Stay tuned. R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav Sent: Tuesday, April 09, 2013 7:44 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Not In List Not the Right Solution Hey Rocky I am sorry. My comments were never supposed to be a criticism. You have been always a vital contributor to this list. It just stunned me as to your request. Tony Septav Nanaimo, BC Canada -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: April-09-13 9:05 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Not In List Not the Right Solution The short answer to Tony was that it wasn't a question of adding a new value to a list - it was adding a new record to the underlying form. But the client's happier with my alternative approach than the original so all's well. R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W Colby Sent: Tuesday, April 09, 2013 6:50 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Not In List Not the Right Solution Yea Tony! John W. Colby Reality is what refuses to go away when you do not believe in it On 4/9/2013 1:23 PM, Tony Septav wrote: > Hey Rocky > I do not understand your problem. From someone so attuned to Access. > Do you not trap for Not In List, then popup a form, asking the client > to verify they want to add the new entry to the list? Then in VBA you > add the new entry to the lookup table, requery the list and then set > focus to the new entry??? > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky > Smolin > Sent: April-09-13 11:24 AM > To: 'Access Developers discussion and problem solving' > Subject: [AccessD] Not In List Not the Right Solution > > Dear List: > > I have a request from a user that when they try to find a name in a > combo box if the name is not there, that the program go to add a new > record and place the data entered in the combo box in the last name > field and let them finish entering the new data. > > I tried the NotInList event until I realized this is to add entries to > the combo box. But I can't seem to get it to behave properly - it > goes into a loop displaying my "add then new guy now?" not in list message. > > I think Not In List is not the best way to do this, but don't know how else. > > Any ideas? > > MTIA > > Rocky Smolin > Beach Access Software > 858-259-4334 > www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com > <http://www.e-z-mrp.com/> > Skype: rocky.smolin > -- 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 message. Checked by AVG - www.avg.com Version: 2013.0.3272 / Virus Database: 3162/6235 - Release Date: 04/09/13 -- 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