Form Problem "MichaelR" <u47950[ at ]uwe> 12/2/2008 9:34:43 PM I have a form created that currently uses a combo box to validate the records. I would like to switch this to a text box and have it validate against the same table. Table name is: part/description Field name is: partnum Basically once the user enters a value into the textbox and tabs out of that textbox I want it to verify that they entered a valid part number. If they do not enter a valid number I would like to see an error message "Please enter a valid part number or see the systems administrator." Thank you in advance for all of your assistance. Mike R. ERP Consultant

Re: Form Problem "Jeff Boyce" <nonsense[ at ]nonsense.com> 12/3/2008 12:17:23 AM Mike I think I understand what you are trying to do, but I don't see how forcing users to remember valid part numbers and chiding them when their memory (or keyboarding skills) fail will help your users get their jobs done. What is it about the combobox setup you already have that isn't working for you/your users? Regards Jeff Boyce Microsoft Office/Access MVP "MichaelR" <u47950[ at ]uwe> wrote in message news:8e13ffecb8f91[ at ]uwe... [Quoted Text] >I have a form created that currently uses a combo box to validate the >records. > I would like to switch this to a text box and have it validate against the > same table. > > Table name is: part/description > Field name is: partnum > > Basically once the user enters a value into the textbox and tabs out of > that > textbox I want it to verify that they entered a valid part number. If > they > do not enter a valid number I would like to see an error message "Please > enter a valid part number or see the systems administrator." > > Thank you in advance for all of your assistance. > > Mike R. > ERP Consultant >

Re: Form Problem "MichaelR via AccessMonster.com" <u47950[ at ]uwe> 12/3/2008 3:11:44 PM Actually this is for a physical inventory that we perfom every 6 months. The users are basically doing data entry from a count tag that is given to them. The combo box caused issues during the last physical inventory because of the "autofill, or autocomplete" For example - We have part number 12345 and we have 12345RM , 12345/CFM - Etc. SO during the entry they would start with 13245 and it would add the RM or CFM etc.... While reconciling the inventory numbers we found that we were not tying out due to that issue. Management decided that they would just like the data entry staff to enter the numbers and then once they tab off the field it would validate.... I hope that explanation makes sense..... Mike Jeff Boyce wrote: [Quoted Text] >Mike > >I think I understand what you are trying to do, but I don't see how forcing >users to remember valid part numbers and chiding them when their memory (or >keyboarding skills) fail will help your users get their jobs done. > >What is it about the combobox setup you already have that isn't working for >you/your users? > >Regards > >Jeff Boyce >Microsoft Office/Access MVP > >>I have a form created that currently uses a combo box to validate the >>records. >[quoted text clipped - 15 lines] >> Mike R. >> ERP Consultant -- Michael R. ERP Consultant Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200812/1

Re: Form Problem "Jeff Boyce" <nonsense[ at ]nonsense.com> 12/3/2008 5:31:28 PM Mike If I have a combobox with those kind of "part numbers" and I have the autocomplete on, and I enter "12345R", I don't get the "/CFM" item. Perhaps typing one more symbol (or using the dropdown to select the correct item) would suffice? By the way, doing data entry of 6 characters ("12345R" or "12345/") less work that typing up to 9 (??) characters ("12345/CFM"), and you get the benefit of only seeing valid values (no validation required). Did management consider ALL the costs/benefits? Regards Jeff Boyce Microsoft Office/Access MVP "MichaelR via AccessMonster.com" <u47950[ at ]uwe> wrote in message news:8e1d3a85ce5e2[ at ]uwe... [Quoted Text] > Actually this is for a physical inventory that we perfom every 6 months. > The > users are basically doing data entry from a count tag that is given to > them. > The combo box caused issues during the last physical inventory because of > the > "autofill, or autocomplete" > For example - We have part number 12345 and we have 12345RM , 12345/CFM - > Etc. > SO during the entry they would start with 13245 and it would add the RM or > CFM etc.... While reconciling the inventory numbers we found that we were > not tying out due to that issue. Management decided that they would just > like the data entry staff to enter the numbers and then once they tab off > the > field it would validate.... > > I hope that explanation makes sense..... > > Mike > > Jeff Boyce wrote: >>Mike >> >>I think I understand what you are trying to do, but I don't see how >>forcing >>users to remember valid part numbers and chiding them when their memory >>(or >>keyboarding skills) fail will help your users get their jobs done. >> >>What is it about the combobox setup you already have that isn't working >>for >>you/your users? >> >>Regards >> >>Jeff Boyce >>Microsoft Office/Access MVP >> >>>I have a form created that currently uses a combo box to validate the >>>records. >>[quoted text clipped - 15 lines] >>> Mike R. >>> ERP Consultant > > -- > Michael R. > ERP Consultant > > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200812/1 >

Re: Form Problem "MichaelR via AccessMonster.com" <u47950[ at ]uwe> 12/3/2008 5:55:19 PM Trust me - You are preaching to the choir here. LOL Let me ask you this.... Is there a way to turn the autocomplete off? I personally like typing the first 1 or 2 characters and then using the dropdown box to select the appropriate number. I am not sure why they really want to pursue typing in every number....doesn't make much sense to me either. Jeff Boyce wrote: [Quoted Text] >Mike > >If I have a combobox with those kind of "part numbers" and I have the >autocomplete on, and I enter "12345R", I don't get the "/CFM" item. Perhaps >typing one more symbol (or using the dropdown to select the correct item) >would suffice? > >By the way, doing data entry of 6 characters ("12345R" or "12345/") less >work that typing up to 9 (??) characters ("12345/CFM"), and you get the >benefit of only seeing valid values (no validation required). > >Did management consider ALL the costs/benefits? > >Regards > >Jeff Boyce >Microsoft Office/Access MVP > >> Actually this is for a physical inventory that we perfom every 6 months. >> The >[quoted text clipped - 38 lines] >>>> Mike R. >>>> ERP Consultant -- Michael R. ERP Consultant Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200812/1

Re: Form Problem "Jeff Boyce" <nonsense[ at ]nonsense.com> 12/3/2008 7:54:30 PM So after you present the additional typing/cost and error-reminding validation you are told "just do what I say" ... hmmm, does your boss have pointy hair?<g> Yes, you can open the form in design view, select the combobox control and turn off the autocomplete property. Good luck! Regards Jeff Boyce Microsoft Office/Access MVP "MichaelR via AccessMonster.com" <u47950[ at ]uwe> wrote in message news:8e1ea8416e16a[ at ]uwe... [Quoted Text] > Trust me - You are preaching to the choir here. LOL > Let me ask you this.... Is there a way to turn the autocomplete off? > > I personally like typing the first 1 or 2 characters and then using the > dropdown box to select the appropriate number. I am not sure why they > really > want to pursue typing in every number....doesn't make much sense to me > either. > > > Jeff Boyce wrote: >>Mike >> >>If I have a combobox with those kind of "part numbers" and I have the >>autocomplete on, and I enter "12345R", I don't get the "/CFM" item. >>Perhaps >>typing one more symbol (or using the dropdown to select the correct item) >>would suffice? >> >>By the way, doing data entry of 6 characters ("12345R" or "12345/") less >>work that typing up to 9 (??) characters ("12345/CFM"), and you get the >>benefit of only seeing valid values (no validation required). >> >>Did management consider ALL the costs/benefits? >> >>Regards >> >>Jeff Boyce >>Microsoft Office/Access MVP >> >>> Actually this is for a physical inventory that we perfom every 6 months. >>> The >>[quoted text clipped - 38 lines] >>>>> Mike R. >>>>> ERP Consultant > > -- > Michael R. > ERP Consultant > > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200812/1 >

Re: Form Problem "MichaelR via AccessMonster.com" <u47950[ at ]uwe> 12/3/2008 8:53:34 PM No pointy hair but close! How do you turn the autocomplete off...I went to the design view of the form, went to that combo field and was unable to locate where you turn that off.... Thanks again! Jeff Boyce wrote: [Quoted Text] >So after you present the additional typing/cost and error-reminding >validation you are told "just do what I say" ... hmmm, does your boss have >pointy hair?<g> > >Yes, you can open the form in design view, select the combobox control and >turn off the autocomplete property. > >Good luck! > >Regards > >Jeff Boyce >Microsoft Office/Access MVP > >> Trust me - You are preaching to the choir here. LOL >> Let me ask you this.... Is there a way to turn the autocomplete off? >[quoted text clipped - 29 lines] >>>>>> Mike R. >>>>>> ERP Consultant -- Michael R. ERP Consultant Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200812/1

Re: Form Problem "Jeff Boyce" <nonsense[ at ]nonsense.com> 12/4/2008 12:40:56 AM Mike You and I agree that "auto complete" would make more sense. Microsoft decided to call it "Auto Expand". Regards Jeff "MichaelR via AccessMonster.com" <u47950[ at ]uwe> wrote in message news:8e2036c0c9bb0[ at ]uwe... [Quoted Text] > No pointy hair but close! > > How do you turn the autocomplete off...I went to the design view of the > form, > went to that combo field and was unable to locate where you turn that > off.... > > Thanks again! > > Jeff Boyce wrote: >>So after you present the additional typing/cost and error-reminding >>validation you are told "just do what I say" ... hmmm, does your boss have >>pointy hair?<g> >> >>Yes, you can open the form in design view, select the combobox control and >>turn off the autocomplete property. >> >>Good luck! >> >>Regards >> >>Jeff Boyce >>Microsoft Office/Access MVP >> >>> Trust me - You are preaching to the choir here. LOL >>> Let me ask you this.... Is there a way to turn the autocomplete off? >>[quoted text clipped - 29 lines] >>>>>>> Mike R. >>>>>>> ERP Consultant > > -- > Michael R. > ERP Consultant > > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200812/1 >

Re: Form Problem "MichaelR via AccessMonster.com" <u47950[ at ]uwe> 12/4/2008 2:32:29 PM Auto expand.....got it... Thank you! Jeff Boyce wrote: [Quoted Text] >Mike > >You and I agree that "auto complete" would make more sense. > >Microsoft decided to call it "Auto Expand". > >Regards > >Jeff > >> No pointy hair but close! >> >[quoted text clipped - 24 lines] >>>>>>>> Mike R. >>>>>>>> ERP Consultant -- Michael R. ERP Consultant Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200812/1