PC Review Forums Newsgroups Microsoft Outlook Microsoft Outlook Form Programming Outlook for dummies or beginners

Reply

Outlook for dummies or beginners

 
Thread Tools Rate Thread
Old 22-01-2004, 01:06 AM   #1
Karen
Guest
 
Posts: n/a
Default Outlook for dummies or beginners


I am trying for the first time to dabble in the design form feature of
Outlook 2003.

Previously I've worked extensively with Access and find now that I was
really spoiled by the forms design interface.

I added a combobox to an Appointment form on the second page and tried to
select Contacts>>FullName as the value. I get the following error message
'The property does not exist. The field you want to modify is not valid for
this type of item'. If I can't even figure out how to add a combobox and
put values in it then I can't imagine to customize some of the Outlook
forms.

I could do it with VBA but, quite frankly, I don't know what to query--what
is the Outlook database called?


--
Karen
  Reply With Quote
Old 22-01-2004, 02:05 AM   #2
Sue Mosher [MVP]
Guest
 
Posts: n/a
Default Re: Outlook for dummies or beginners

Forget everything you learned about forms in Access. Virtually none of it
applies to Outlook, except the concept that the layout and data record are
separate (most of the time).

In general, you cannot add a field from one type of item to the form for
another type of item. Doing so results in the error you are experiencing.

To add a combo box, use the control toolbox. After you add the control,
right-click it, choose Properties, switch to the Value tab and use Choose
Field or New to bind the control to an existing or new custom property.
After you bind the control, you can populate the choices by using the
Possible Values text box on the Value tab, separating values with
semicolons.

See http://www.slipstick.com/dev/forms.htm for more Outlook forms resources.
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Karen" <wonderlover@funcity.com> wrote in message
news:%23NJD4PI4DHA.3576@TK2MSFTNGP11.phx.gbl...
I am trying for the first time to dabble in the design form feature of
Outlook 2003.

Previously I've worked extensively with Access and find now that I was
really spoiled by the forms design interface.

I added a combobox to an Appointment form on the second page and tried to
select Contacts>>FullName as the value. I get the following error message
'The property does not exist. The field you want to modify is not valid for
this type of item'. If I can't even figure out how to add a combobox and
put values in it then I can't imagine to customize some of the Outlook
forms.

I could do it with VBA but, quite frankly, I don't know what to query--what
is the Outlook database called?


--
Karen



  Reply With Quote
Old 22-01-2004, 02:20 AM   #3
Karen
Guest
 
Posts: n/a
Default Re: Outlook for dummies or beginners

Thanks Sue,

Is it possible to populate comboboxes dynamically? What if I wanted a combo
box to populate the names of people whose record shows a Company of Company
A.

cbocombo.value = FullName where Company.value is "CompanyA"

That kind of thing. I have found slipstick so I'm trying to digest this new
material.

Karen

"Sue Mosher [MVP]" <suemvp@outlookcode.com> wrote in message
news:uKT8PsI4DHA.2080@TK2MSFTNGP11.phx.gbl...
> Forget everything you learned about forms in Access. Virtually none of it
> applies to Outlook, except the concept that the layout and data record are
> separate (most of the time).
>
> In general, you cannot add a field from one type of item to the form for
> another type of item. Doing so results in the error you are experiencing.
>
> To add a combo box, use the control toolbox. After you add the control,
> right-click it, choose Properties, switch to the Value tab and use Choose
> Field or New to bind the control to an existing or new custom property.
> After you bind the control, you can populate the choices by using the
> Possible Values text box on the Value tab, separating values with
> semicolons.
>
> See http://www.slipstick.com/dev/forms.htm for more Outlook forms

resources.
> --
> Sue Mosher, Outlook MVP
> Author of
> Microsoft Outlook Programming - Jumpstart for
> Administrators, Power Users, and Developers
> http://www.outlookcode.com/jumpstart.aspx
>
>
> "Karen" <wonderlover@funcity.com> wrote in message
> news:%23NJD4PI4DHA.3576@TK2MSFTNGP11.phx.gbl...
> I am trying for the first time to dabble in the design form feature of
> Outlook 2003.
>
> Previously I've worked extensively with Access and find now that I was
> really spoiled by the forms design interface.
>
> I added a combobox to an Appointment form on the second page and tried to
> select Contacts>>FullName as the value. I get the following error message
> 'The property does not exist. The field you want to modify is not valid

for
> this type of item'. If I can't even figure out how to add a combobox and
> put values in it then I can't imagine to customize some of the Outlook
> forms.
>
> I could do it with VBA but, quite frankly, I don't know what to

query--what
> is the Outlook database called?
>
>
> --
> Karen
>
>
>



  Reply With Quote
Old 22-01-2004, 02:55 AM   #4
Sue Mosher [MVP]
Guest
 
Posts: n/a
Default Re: Outlook for dummies or beginners

Yes, you can populate combo boxes dynamically using either the List or
Column property or the AddItem method -- in other words by writing script
that, most likely, runs in the Item_Open event hander or in an event that
fires when the user makes a selection from another control. It can't be done
with a simple formula or query.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Karen" <wonderlover@funcity.com> wrote in message
news:eNHUd5I4DHA.2276@TK2MSFTNGP10.phx.gbl...
>
> Is it possible to populate comboboxes dynamically? What if I wanted a

combo
> box to populate the names of people whose record shows a Company of

Company
> A.
>
> cbocombo.value = FullName where Company.value is "CompanyA"



  Reply With Quote
Old 22-01-2004, 03:04 AM   #5
Karen
Guest
 
Posts: n/a
Default Re: Outlook for dummies or beginners

Sue,

Got it, thanks a lot.

Karen

"Sue Mosher [MVP]" <suemvp@outlookcode.com> wrote in message
news:OmGBmOJ4DHA.3480@TK2MSFTNGP11.phx.gbl...
> Yes, you can populate combo boxes dynamically using either the List or
> Column property or the AddItem method -- in other words by writing script
> that, most likely, runs in the Item_Open event hander or in an event that
> fires when the user makes a selection from another control. It can't be

done
> with a simple formula or query.
>
> --
> Sue Mosher, Outlook MVP
> Author of
> Microsoft Outlook Programming - Jumpstart for
> Administrators, Power Users, and Developers
> http://www.outlookcode.com/jumpstart.aspx
>
> "Karen" <wonderlover@funcity.com> wrote in message
> news:eNHUd5I4DHA.2276@TK2MSFTNGP10.phx.gbl...
> >
> > Is it possible to populate comboboxes dynamically? What if I wanted a

> combo
> > box to populate the names of people whose record shows a Company of

> Company
> > A.
> >
> > cbocombo.value = FullName where Company.value is "CompanyA"

>
>



  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off