Grid on Contacts Form

[Michelle Key]

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

 

[Sue Mosher [MVP-Outlook]]

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


--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

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?

 

[Hazem]

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?

 

[Ken Slovak - [MVP - Outlook]]

Outlook forms don't support VS.NET controls, the controls used on an Outlook
form must be ActiveX controls, like those in VS 6.

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?

 

[Ben O'connel]

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

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.