Re: Outlook 07 Custom Task Form and SQL

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

Never, ever use the PossibleValues property of a combo or list box control to set rows programmatically. Doing so will one-off the form. Always use regular methods to load the list.

If you want to save the list, you could put it in a StorageItem object in a mail/post public folder. Or wait until SP1 comes out, which hopefully will fix the current bug with creating StorageItem objects in non-mail/post folders.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Job" <Job@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:EAE4CFDF-FB41-4999-9B52-1DB817A79DB1@xxxxxxxxxxxxxxxx
http://support.microsoft.com/kb/929590

This did the trick. Just had to know where to look in 2007 > Trust Center.
Any thoughts on this part
"update the list
and save the list, maybe through the Possible Values? and only update when
something in the list is not found..ie project number"

Thanks

"Job" wrote:


I created the custom form, for which you've seen the code. A few of the
boxes are pulled from an SQL db (though it would be nice to update the list
and save the list, maybe through the Possible Values? and only update when
something in the list is not found..ie project number).

Here is where I'm mixed up. If I publish the custom form to the
Organizational Forms Library it is available to all as would be expected.

Because I'm using the 'People's Tasks' Shared task folder > 'EQC' If I
want to create tasks in the name of EQC I have to select this folder and
create the task. If I use the right-click>Properties>When Posting to this
folder use> Organizational Forms Library>%Published Custom Form Name% Then
when I create a new task with as EQC from the shared task folder, the code
does not work. If I choose New>Choose Form and choose the OFL published form
then the code works, but now it is under my name not the EQC. I read about
the Allow script check boxes in Outlook 2003 post you've mentioned, but I
don't have that option in 2007 and I don't see the reference to this in the
registry.

All of your help is greatly appreciated.


"Sue Mosher [MVP-Outlook]" wrote:

If you are seeking paid help, you can send a message to outlook-dev-hire at yahoogroups.com with details of your requirements, including the Outlook version(s) to be supported. Once the moderator approves your message, Outlook developers on the outlook-dev-hire list can respond directly to you if they're interested in your project.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Job" <Job@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:98D1616B-BDE9-4659-849A-19DEF9C0ABBB@xxxxxxxxxxxxxxxx
I sent you an email to your listed account, but can I hire you to help create
this form and functionality?

"Sue Mosher [MVP-Outlook]" wrote:

Not more control. The same control, but with a different architecture and your choice of programming language, instead of VBScript. Traditional COM add-ins are one solution. Add-ins built with VSTO are another. Both make the project somewhat more complex, as you get into deployment issues.

"Job" <Job@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:D51B95F2-A975-4728-8BAD-9155914A0321@xxxxxxxxxxxxxxxx
These add-ins give more control over the development of the form? are you
referring to your site http://www.outlookcode.com/article.aspx?ID=36 or is it
a different kind of add-in via vba or something?

"Sue Mosher [MVP-Outlook]" wrote:

VBScript doesn't support data typing for variable or procedure declarations. You'd need to comment out the As clauses. Also don't forget to declare your ad* constants.

The alternative, BTW, would be to develop an add-in that manages the form's UI, not with code behind the form but through the events that fire when the user interacts with the form.

"Job" <Job@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:52DC9904-BBD2-44BB-87B3-E4E7A6EA8232@xxxxxxxxxxxxxxxx
Hi Sue,

I've used your information a lot trying to solve this..can you look at the
following code. I don't use vbscript much so I'm not sure why I'm getting
the following error.
"Expected end of statement" and it is initially pointing to my dim
statment. If I comment that out it also has the same error on the variable
'e'
Here is the code

Sub FillClientData()

Dim rst As New ADODB.Recordset
Set Conn = New ADODB.Connection
Conn.Open "DSN=db_OCEANS15"

Sql = "Select pj.cl_ClientNum + '_' + cl_Client_Short_Desc From
tbl_prj_Projects pj left join tbl_cl_Clients cl On pj.cl_ClientNum =
cl.cl_ClientNum Where len(pj.cl_ClientNum + '_' + cl_Client_Short_Desc) > 4
Group By pj.cl_ClientNum + '_' + cl_Client_Short_Desc"



Set ctl = Item.GetInspector.ModifiedFormPages("PM
Task").Controls("cmbo_Client")
rst.Open Sql, Conn, adOpenKeyset, adLockOptimistic, Options:=adCmdText


rst.MoveLast
rst.MoveFirst

ReDim MyArray(rst.RecordCount - 1)

For I = 0 To rst.RecordCount - 1

MyArray(I) = rst(0)

rst.MoveNext

Next

For e = 0 To rst.RecordCount - 1

ctl.AddItem MyArray(e)
Next e

'cmbo_Client.List() = MyArray

End Sub

Any help is greatly appreciated

"Sue Mosher [MVP-Outlook]" wrote:

Correct. All code behind an Outlook form must be written in VBScript. The error you're getting suggests either a typo on the page name or the control name. You can narrow down the problem by getting just one object per statement.

"Job" <Job@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:77B141F1-E6DB-43A8-B022-4389319D0F73@xxxxxxxxxxxxxxxx
I've been searching the net finding examples of connecting to a sql db in
order to populate a custom form drop down. I've had my example code in the
vb editor...can I only use the vb script editor? Everytime I reference
Set ctl = Item.GetInspector.ModifiedFormPages("PM
Task").Controls("cmbo_Client")
for example I get the error that the object can't be found.

Cheers,

Job




.

Relevant Pages

  • Re: Updating messages posted from custom forms?
    ... >>> We have an Outlook form application that when the custom form submits it ... data and reference to the original form. ... specified folder I may be able to make the path change and update the info ... I just do not know enough about Outlook and it's ...
    (microsoft.public.outlook.program_forms)
  • Re: Creating custom replies/forward forms per folder?
    ... Customised text (per folder) which could be different depending on ... Attach a file to a 'Reply' message. ... Anyway my thought on publishing a custom form was that I could attach some ... it in Outlook code is potentially *very* complicated. ...
    (microsoft.public.outlook.program_forms)
  • Re: Changing the default form for a contact folder
    ... Did you also change the setting for "When posting to this folder, ... Sue Mosher, Outlook MVP ... Author of Configuring Microsoft Outlook 2003 ... >I have tried this solution and although the custom form is in the "associate ...
    (microsoft.public.outlook.program_forms)
  • Re: After Office XP SP3 installed - intermittent problems with forms
    ... The custom forms cache in Outlook 2002 SP3 is ... rather than the custom form. ... Is it used by items in more than one folder? ...
    (microsoft.public.outlook.program_vba)
  • Re: Re-Opening a Saved Message
    ... Sue Mosher, Outlook MVP ... > I have designed a custom form based on Message template. ... When i reopen it from the Folder [double clicking ... > get contents of the custom controls i inserted on the form in addition ...
    (microsoft.public.outlook.program_forms)