|
tech
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
User friendly combo boxHi,
I have created a combo box that if the user enters a number, the combo box will pull out the form. However, I would like the box to promp the valid selections when users click on the arrow. Can anyone please tell me how to do so? Thank you! -- Keck Graduate Institute As a guess as to what you mean, you would rather have the user select a name
than a number. In that case, make a two-column query with the number in the first column and the name in the second. Use the query as the combo box Row Source. Set the combo box Column count to 2, the Bound Column to 1, and the Column Widths to something like 0;1.5. Any code in the combo box After Update event will probably work as before, but the user can select the name rather than the number. If you need more information, or if the guess is incorrect, please provide more details. Show quoteHide quote "Sandra Teng" <SandraT***@discussions.microsoft.com> wrote in message news:250932B2-927C-44B5-936D-194A043EC288@microsoft.com... > Hi, > I have created a combo box that if the user enters a number, the combo box > will pull out the form. However, I would like the box to promp the valid > selections when users click on the arrow. Can anyone please tell me how to > do > so? Thank you! > -- > Keck Graduate Institute Hi Bruce,
Thank you for your response, I am sorry that I didn't address the problem clearly. I would like to write a program so that everytime, in the form view, the user can select an item from a pull-down menu, and the combo box will spit out any forms that contains anything that matches the selection. Can you help me with that? Thank you so much! -- Show quoteHide quoteKeck Graduate Institute "BruceM" wrote: > As a guess as to what you mean, you would rather have the user select a name > than a number. In that case, make a two-column query with the number in the > first column and the name in the second. Use the query as the combo box Row > Source. Set the combo box Column count to 2, the Bound Column to 1, and the > Column Widths to something like 0;1.5. Any code in the combo box After > Update event will probably work as before, but the user can select the name > rather than the number. > > If you need more information, or if the guess is incorrect, please provide > more details. > > "Sandra Teng" <SandraT***@discussions.microsoft.com> wrote in message > news:250932B2-927C-44B5-936D-194A043EC288@microsoft.com... > > Hi, > > I have created a combo box that if the user enters a number, the combo box > > will pull out the form. However, I would like the box to promp the valid > > selections when users click on the arrow. Can anyone please tell me how to > > do > > so? Thank you! > > -- > > Keck Graduate Institute > > > Your terminology is colorful but imprecise. I don't understand what you
mean about Access spitting out forms. I suspect you mean records or reports rather than forms. A review of some terminology may help: http://allenbrowne.com/casu-01.html Another thing that may help is if you describe your database's structure and purpose, and in non-database terms describe the desired outcome after selecting an item from the combo box.. Show quoteHide quote "Sandra Teng" <SandraT***@discussions.microsoft.com> wrote in message news:7E5480C1-B165-49D3-99F8-617AF6B6438F@microsoft.com... > Hi Bruce, > Thank you for your response, I am sorry that I didn't address the problem > clearly. > I would like to write a program so that everytime, in the form view, the > user can select an item from a pull-down menu, and the combo box will spit > out any forms that contains anything that matches the selection. > Can you help me with that? Thank you so much! > -- > Keck Graduate Institute > > > "BruceM" wrote: > >> As a guess as to what you mean, you would rather have the user select a >> name >> than a number. In that case, make a two-column query with the number in >> the >> first column and the name in the second. Use the query as the combo box >> Row >> Source. Set the combo box Column count to 2, the Bound Column to 1, and >> the >> Column Widths to something like 0;1.5. Any code in the combo box After >> Update event will probably work as before, but the user can select the >> name >> rather than the number. >> >> If you need more information, or if the guess is incorrect, please >> provide >> more details. >> >> "Sandra Teng" <SandraT***@discussions.microsoft.com> wrote in message >> news:250932B2-927C-44B5-936D-194A043EC288@microsoft.com... >> > Hi, >> > I have created a combo box that if the user enters a number, the combo >> > box >> > will pull out the form. However, I would like the box to promp the >> > valid >> > selections when users click on the arrow. Can anyone please tell me how >> > to >> > do >> > so? Thank you! >> > -- >> > Keck Graduate Institute >> >> >> Hi Bruce,
Thank you. I have one table imported from an excel file that contains 128 rows. Each row has an information about a person. In each row, there is an ID, the person's contact information, and special notes. I have created a combo box in a form that allows me to enter an ID #. However, I intend to make this combo box feature a search bar. So that when I click on the textbox or combo box, it'll have me enter any text, and then show me display any row in the table that contains the text that I have entered. I hope this helps to explain what I want Access to do. Thank you agian, -- Show quoteHide quoteKeck Graduate Institute "BruceM" wrote: > Your terminology is colorful but imprecise. I don't understand what you > mean about Access spitting out forms. I suspect you mean records or reports > rather than forms. A review of some terminology may help: > http://allenbrowne.com/casu-01.html > > Another thing that may help is if you describe your database's structure and > purpose, and in non-database terms describe the desired outcome after > selecting an item from the combo box.. > > "Sandra Teng" <SandraT***@discussions.microsoft.com> wrote in message > news:7E5480C1-B165-49D3-99F8-617AF6B6438F@microsoft.com... > > Hi Bruce, > > Thank you for your response, I am sorry that I didn't address the problem > > clearly. > > I would like to write a program so that everytime, in the form view, the > > user can select an item from a pull-down menu, and the combo box will spit > > out any forms that contains anything that matches the selection. > > Can you help me with that? Thank you so much! > > -- > > Keck Graduate Institute > > > > > > "BruceM" wrote: > > > >> As a guess as to what you mean, you would rather have the user select a > >> name > >> than a number. In that case, make a two-column query with the number in > >> the > >> first column and the name in the second. Use the query as the combo box > >> Row > >> Source. Set the combo box Column count to 2, the Bound Column to 1, and > >> the > >> Column Widths to something like 0;1.5. Any code in the combo box After > >> Update event will probably work as before, but the user can select the > >> name > >> rather than the number. > >> > >> If you need more information, or if the guess is incorrect, please > >> provide > >> more details. > >> > >> "Sandra Teng" <SandraT***@discussions.microsoft.com> wrote in message > >> news:250932B2-927C-44B5-936D-194A043EC288@microsoft.com... > >> > Hi, > >> > I have created a combo box that if the user enters a number, the combo > >> > box > >> > will pull out the form. However, I would like the box to promp the > >> > valid > >> > selections when users click on the arrow. Can anyone please tell me how > >> > to > >> > do > >> > so? Thank you! > >> > -- > >> > Keck Graduate Institute > >> > >> > >> > > >  
Other interesting topics
|
|||||||||||||||||||||||
