A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Outlook » Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Using an Excel spreadsheet as a custom control in the design a for



 
 
Thread Tools Display Modes
  #1  
Old October 15th, 2008, 03:06 PM posted to microsoft.public.outlook.contacts
IT Girl
external usenet poster
 
Posts: 1
Default Using an Excel spreadsheet as a custom control in the design a for

I am using Office XP Profesional, outlook 2002.

I am desiging a custom form, using the contact template. On one of the
pages I have imbeded an Excel Spreadsheet by selecting it from the Custom
Controls tool box.

When I publish my newly redesigned contact it retains all the information I
need, however. When I open the new contact enter information into the spread
sheet save and close the contact. Then reopen to view the information on the
contacts spreadsheet all the data in the spreadsheet is gone.

How do I get the spreadsheet to save the date when I save a close my contact?
  #2  
Old October 15th, 2008, 05:46 PM posted to microsoft.public.outlook.contacts
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 7,177
Default Using an Excel spreadsheet as a custom control in the design a for

You must put code behind the form to store the data when the item is saved
and read it into the control when the item opens. See
http://www.outlookcode.com/article.aspx?id=69

FYI, there is a newsgroup specifically for Outlook forms issues "down the
hall" at microsoft.public.outlook.program_forms or, via web interface, at
http://www.microsoft.com/office/comm...rogram_f orms

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


"IT Girl" wrote:

I am using Office XP Profesional, outlook 2002.

I am desiging a custom form, using the contact template. On one of the
pages I have imbeded an Excel Spreadsheet by selecting it from the Custom
Controls tool box.

When I publish my newly redesigned contact it retains all the information I
need, however. When I open the new contact enter information into the spread
sheet save and close the contact. Then reopen to view the information on the
contacts spreadsheet all the data in the spreadsheet is gone.

How do I get the spreadsheet to save the date when I save a close my contact?

  #3  
Old October 15th, 2008, 07:32 PM posted to microsoft.public.outlook.contacts
It Girl
external usenet poster
 
Posts: 3
Default Using an Excel spreadsheet as a custom control in the design a

Thanks Sue... This is great information.. Now the problem i have is the code
itself. I am at a loss as to how to create a code to do this. I thought
after reading the information you link I could copy and paste the code for
the handleing Data header in you first link but I get error mesages when I
chose the form I have just pubilshed.

In this contact as well I have other custom feilds that matain data in the
form of mulitiline notes fields and message feilds and i do not want to
dsirupt the data in these feilds.

Any suggestions for me, I really am new at this sort of thing.



"Sue Mosher [MVP-Outlook]" wrote:

You must put code behind the form to store the data when the item is saved
and read it into the control when the item opens. See
http://www.outlookcode.com/article.aspx?id=69

FYI, there is a newsgroup specifically for Outlook forms issues "down the
hall" at microsoft.public.outlook.program_forms or, via web interface, at
http://www.microsoft.com/office/comm...rogram_f orms

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


"IT Girl" wrote:

I am using Office XP Profesional, outlook 2002.

I am desiging a custom form, using the contact template. On one of the
pages I have imbeded an Excel Spreadsheet by selecting it from the Custom
Controls tool box.

When I publish my newly redesigned contact it retains all the information I
need, however. When I open the new contact enter information into the spread
sheet save and close the contact. Then reopen to view the information on the
contacts spreadsheet all the data in the spreadsheet is gone.

How do I get the spreadsheet to save the date when I save a close my contact?

 




Thread Tools
Display Modes

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 Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:12 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.