Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Programming Forms / July 2005

Tip: Looking for answers? Try searching our database.

Grid on Contacts Form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Michelle Key - 11 Jun 2004 15:44 GMT
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!!

Signature

Michelle Key

Sue Mosher [MVP-Outlook] - 14 Jun 2004 14:33 GMT
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)?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.