I'm developing a custom Contact form in OL '03. I have added a tab for "notes" and would like a grid with three fields: a "created date" field with a default value of the system date, a "user" field with the default value of the logged on user, and a notes field with a memo-sized property. I want it to look like the table view on the "All fields tab" of a contact.
I tried to add a MS FlexGrid 6.0 control, but when I try to add it to the form, I get the message that "the control couldn't be created because it's not properly licensed." (All of my MS products are fully licensed and activated with an MSDN license).
I tried inserting an Excel spreadsheet object. It is inserted, but when I type in a cell, save and close the contact, and then open it back up again, whatever I typed wasn't saved.
My question is multi-part:
1) do I want to use a FlexGrid control? Since I couldn't add it, I couldn't play with it to see if it had the properties I need.
2) if I do want to use a FlexGrid control, how do I go about "properly licensing" it so I can use it? Is it only in a developer's pack? Does it not belong in the OL standard class of controls?
3) if I don't want a FlexGrid control, what do I want?
4) just out of curiousity, why won't it save the info I type into the Excel object - does it need to be bound to a specific spreadsheet saved on a drive somewhere? If so, will it show notes for all contacts on one spreadsheet?
Thanks in advance for the help!!
1) Only if you want to have to distribute the installation program to every
user.
2) You can create a proper setup program with VB6.
3) A flex grid is probably as good as any solution.
4) Because you didn't provide anywhere for Outlook to save the data.
Remember that an ActiveX control itself doesn't store any data. See
http://www.outlookcode.com/d/spreadsheetcontrol.htm

Signature
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx
> I'm developing a custom Contact form in OL '03. I have added a tab for "notes" and would like a grid with three fields: a "created date" field with
a default value of the system date, a "user" field with the default value of
the logged on user, and a notes field with a memo-sized property. I want it
to look like the table view on the "All fields tab" of a contact.
> I tried to add a MS FlexGrid 6.0 control, but when I try to add it to the form, I get the message that "the control couldn't be created because it's
not properly licensed." (All of my MS products are fully licensed and
activated with an MSDN license).
> I tried inserting an Excel spreadsheet object. It is inserted, but when I type in a cell, save and close the contact, and then open it back up again,
whatever I typed wasn't saved.
> My question is multi-part:
>
> 1) do I want to use a FlexGrid control? Since I couldn't add it, I couldn't play with it to see if it had the properties I need.
>
> 2) if I do want to use a FlexGrid control, how do I go about "properly licensing" it so I can use it? Is it only in a developer's pack? Does it
not belong in the OL standard class of controls?
> 3) if I don't want a FlexGrid control, what do I want?
>
> 4) just out of curiousity, why won't it save the info I type into the Excel object - does it need to be bound to a specific spreadsheet saved on a
drive somewhere? If so, will it show notes for all contacts on one
spreadsheet?
> Thanks in advance for the help!!
Hazem - 10 Jul 2004 12:52 GMT
I am getting an error saying that I am not Licensed to use MS FLEX Grid when I try to put the control on a form. Everything I have is licensed and activated. What do I do?
I am using Visual Baic .NET 2003.
What is the most convenient way for a user (not developer) to enter tabular data? It seems that the List View is designed strictly for "View" and not for data entry by the user and the DataGrid seems complicated. Suggestions?
> 1) Only if you want to have to distribute the installation program to every
> user.
[quoted text clipped - 39 lines]
> >
> > Thanks in advance for the help!!
Ken Slovak - [MVP - Outlook] - 12 Jul 2004 13:56 GMT
Outlook forms don't support VS.NET controls, the controls used on an Outlook
form must be ActiveX controls, like those in VS 6.

Signature
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm
> I am getting an error saying that I am not Licensed to use MS FLEX Grid when I try to put the control on a form. Everything I have is licensed and
activated. What do I do?
> I am using Visual Baic .NET 2003.
>
> What is the most convenient way for a user (not developer) to enter tabular data? It seems that the List View is designed strictly for "View"
and not for data entry by the user and the DataGrid seems complicated.
Suggestions?
> > 1) Only if you want to have to distribute the installation program to every
> > user.
[quoted text clipped - 39 lines]
> > >
> > > Thanks in advance for the help!!
Ben O'connel - 15 Jul 2005 04:26 GMT
Hi, my question is virtually the same as the above two, but in both cases the
answers didn't make sense/present a solution to me.
I've a licensed version of Access 2003 professional, and have been trying to
use the MS FlexGrid 6.0 control like people in the previous two posts.
I know this control was not packaged with the Access 2003;
My questions are;
1) Is it possible to get licences to use this control with any of the Access
products? ie ‘Access 2003 developers extensions’
2) If not possible, is there any other control available with the Access
2003 professional version which will act as a data grid (and can be used
unbound)?
Ken Slovak - [MVP - Outlook] - 15 Jul 2005 14:48 GMT
To use the MS Flex you would need a version of Visual Studio or Visual Basic
6 to get a redistribution license for that control. I know of no Access
control that can be used like that.

Signature
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm
> Hi, my question is virtually the same as the above two, but in both cases
> the
[quoted text clipped - 15 lines]
> 2003 professional version which will act as a data grid (and can be used
> unbound)?