Re: Filling listbox on custom Contact item 1st page

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Sorry, but you lost me at "selects one or more of the list boxes." Users can select one or more items in a list box, but I don't know what you mean by selecting the list box itself. You really haven't said anything about whether you're using a multi- or single-select list box, or whether it's bound to an Outlook property, or if so, what.

--
Sue 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

"John E." <je.lodestar@xxxxxxxxxxx> wrote in message news:723EBB1D-8B70-4094-8D0D-BC0580440E37@xxxxxxxxxxxxxxxx
Sue,
I studied your FormControlsDemo approach and implemented a VBScript
adaptation of it into my custom contact form to read data into a listbox at
time of the contact form initialization. User then completes the form and
selects one or more of the list boxes before saving the inital item. I
thought everything was doing what I wanted until some more recent testing. I
discovered that whichever list boxes had NOT been checked at time of
initalization could never be checked at a later date. In other words which
ever list box selections were made at time of initialization of the contact,
they were in stone and could not be changed later. Our application requires
the flexibility of being able to select additional boxes at a later date in
the list. How can we do that? Is there another option to keep list box data
from being perishable, but still being able to check additional list itmes at
later date?
--
John E.


"Sue Mosher [MVP-Outlook]" wrote:

The user's selections are data that should be stored in the Outlook item. Your "thought about using some code" is exactly on target. My sample form at http://www.outlookcode.com/files/FormControlsDemo.zip has an example of how to do this.


"John E." <je.lodestar@xxxxxxxxxxx> wrote in message news:1A0F3508-7878-4B43-BEEB-206D1817C063@xxxxxxxxxxxxxxxx
Here is why. In our application, at time of initiating a new contact with
the custom form, the list box will be filled and the user will then select
one or more of the check boxes while completing the data in the contact form.
These check box selections need to be preserved after the new contact is
then saved and re-opened the next time. At the next time of opening of the
same contact, I need to read the data back into the list box, but those rows
that were selected in the option check boxes previously need to be reinstated
automatically without the user having to re-check the boxes. Which check
boxes are selected from the total list at time of contact initializaion and
initial list box fill will vary from contact to contact.
I thought about using some code triggered by the Write event in which the
Selected property of the list box would determine in a loop which rows in the
list box were selected and then store this as an array somehow so it could be
used on the next Open event of this specific contact to re-establish which
rows of the new fill need to be re-selected. I think this could be
accomplished, but I am struggling with how to implement it.


.



Relevant Pages

  • Re: Filling listbox on custom Contact item 1st page
    ... Author of Configuring Microsoft Outlook 2003 ... the custom form, the list box will be filled and the user will then select ... one or more of the check boxes while completing the data in the contact form. ... These check box selections need to be preserved after the new contact is ...
    (microsoft.public.outlook.program_forms)
  • Re: Unable to reset Combo Box Data Field Format.
    ... Regards to mixed data types and the combo boxes - ... controls from the target SQL statement. ... > either selecting values from the combo box row source or by typing them> it ... > based on other combo box selections of fields in the DB. ...
    (microsoft.public.access.forms)
  • Re: Using combo box selection to supply criteria for query
    ... Later if you want to come back and just use the reference to the control, ... boxes are different, some have names that I manually added. ... results will be driven by the combo box selections made on the forms. ...
    (microsoft.public.access.forms)
  • Re: Create more than 1 Message Block in a Form
    ... Whether the text boxes are bound to Outlook properties and if so, ... Author of Configuring Microsoft Outlook 2003 ... You can feel free to put as many text boxes as you like on a custom form, but if you want their information to appear in the message body, you'll have to provide code to concatenate that information. ... Whatever I type in one Message Block is ...
    (microsoft.public.outlook.program_forms)
  • Re: Form/Sub-form problem save/refresh and calculations
    ... In the BeforeUpdate event procedure of the main ... Users may make selections in the combo boxes in any order, ... Because the sub-form is dependent on all six combo boxes being populated, ...
    (microsoft.public.access.forms)