 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Programming Forms / July 2006How do you create dropdowns in a form using Microsoft Outlook?
I've tried creating forms and want to lock down the specific selections from my team. I figured the dropdown would be my best bet. But I can't get beyond one selection to put into the box. > I've tried creating forms and want to lock down the specific selections from > my team. I figured the dropdown would be my best bet. But I can't get > beyond one selection to put into the box. If you go into the properties of the listbox, you can type in initial values, which will then show when they drop the list down. You can also initialize the listbox.List() property to an array that you have constructed, and they will show in the form. Hollis D. Paul [MVP - Outlook] Hollis@outhousebythesound.com Mukilteo, WA USA Use the AddItem or (better yet) List method to populate the combo box. See http://www.outlookcode.com/d/formcontrols.htm#listcombo  SignatureSue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx > I've tried creating forms and want to lock down the specific selections from > my team. I figured the dropdown would be my best bet. But I can't get > beyond one selection to put into the box. Sue, Sorry...I'm wondering if you could give me a quick click by click description...I want to create a list of clients (stored either within Outlook or somewhere else like Access) which will come up in my list box. Do I go -> right click on list box - properties - values - choose field? (and if so where from there)? (I appreciate any answer...you seem busy!) Slappy > Use the AddItem or (better yet) List method to populate the combo box. See http://www.outlookcode.com/d/formcontrols.htm#listcombo > > > I've tried creating forms and want to lock down the specific selections from > > my team. I figured the dropdown would be my best bet. But I can't get > > beyond one selection to put into the box. Choose Field allows you to bind a control on your form to an Outlook property, so that the data the user enters is stored in the item when it's saved. It doesn't have a lot to do with populating a list box, unless you want a static list that doesn't change. That doesn't sound like what you want, but you really haven't sketched out enough of your scenario for me to make concrete suggestions. Did you look at the custom form sample on the page I suggested? Maybe that will give you some context to describe what you want. Other key issues are what type of form (message, contact, etc.), whether you're using Exchange as your mail server, where you plan to publish the form, etc. SignatureSue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx > Sue, > [quoted text clipped - 11 lines] >> > my team. I figured the dropdown would be my best bet. But I can't get >> > beyond one selection to put into the box. Sue, Thanks for the reply. I run a small law practise. Essentially I want a way to create notes that are capable of being assigned to different clients (the notes would be linked to an Access database where they can be better analyzed and stored). The list box should show an ever changing list of current clients. I tried to modify the template for Business Notes but that doesn't seem to be working. I then tried to modify a Journal Entry Form. Can you offer any suggestions or assistance? Slappy > Choose Field allows you to bind a control on your form to an Outlook property, so that the data the user enters is stored in the item when it's saved. It doesn't have a lot to do with populating a list box, unless you want a static list that doesn't change. That doesn't sound like what you want, but you really haven't sketched out enough of your scenario for me to make concrete suggestions. Did you look at the custom form sample on the page I suggested? Maybe that will give you some context to describe what you want. > [quoted text clipped - 14 lines] > >> > my team. I figured the dropdown would be my best bet. But I can't get > >> > beyond one selection to put into the box. Do you mean notes as in email messages? Notes as in journal entries? "template for Business Notes"? Are you talking about Business Contact Manager? Where would the list of clients come from? An external database? If so, then you'll need to write ADO code behind the form to do the lookup; see http://www.outlookcode.com/d/database.htm That page also has tools for exposing an existing database in Outlook. "notes linked to an Access database"? Are you thinking of storing information from the notes in the database? Using the built-in linking to OUtlook that Access has? These are also key issues still: >> Other key issues are what type of form (message, contact, etc.), whether you're using Exchange as your mail server, where you plan to publish the form, etc As you're probably catching on, what you're describing is not a simple step-by-step operation. SignatureSue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx > Sue, > [quoted text clipped - 27 lines] >> >> > my team. I figured the dropdown would be my best bet. But I can't get >> >> > beyond one selection to put into the box. Thanks...yes I intend to store the information from the notes in the external database. I'll look into learning more about ADO code. If I write back I'll try to have more precise terminology. Thanks for pointing me in the right direction. > Do you mean notes as in email messages? Notes as in journal entries? > [quoted text clipped - 41 lines] > >> >> > my team. I figured the dropdown would be my best bet. But I can't get > >> >> > beyond one selection to put into the box. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.