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 2004

Tip: Looking for answers? Try searching our database.

Outlook Form : Excel Web component in form using access Datasource

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
dave - 22 Jul 2004 10:37 GMT
hi basically im creating a custom contact form in a Public Contacts
folder.(Outlook 2002/2003,  Exchange 2000)
The aim is to insert an Excel Web component with a Datasource point to an
Access MDB(in the memo field).
This works fine in Design mode but i have 2 issues.
If i just save the form i beilive its called a 'one off' form when i try to
reopen the form i receive the following
"To help prevent malicious code from running, one or more objects in the
form where not load, for more information contact your administrator"

The form will open but minus the excel component.

If i publish the form and change a contacts form to use the custom form i
get the following
"This page access data on another domain. Do you want to allow this?"
Then
"This website is using your identity to access a data source. If you trust
this website, click OK to continue, other wise click cancel"

The form will then open after u OK these with the excel compoent correctly
displayed , the problem is if i try to save the form with an edit say in the
name field , that save wont be applied.

Which approach is best 'one off'' forms or publish a custom form, i beilieve
the latter.
I install the Outlook Security Features Administrative package correctly ( i
think)
http://www.microsoft.com/office/ork/xp/appndx/appa11.htm
The Publish form will open on other machines, i.e it will download the
component correctly but still display the message's

and selected the "Allow in Place Activiation of embedded OLE Objects" and
"Show OLE package objects" from with in that template, and using that
security admin template i trusted the OWC11.DLL office Web component file.I
also reduced marco security to Low.

Any help would be appreciated.
Sue Mosher [MVP-Outlook] - 22 Jul 2004 12:35 GMT
You must publish the form if you want code to run and ActiveX controls like
that to work. See http://www.outlookcode.com/d/ol2003problems.htm#activex

Signature

Sue Mosher, Outlook MVP
Author of
    Microsoft Outlook Programming - Jumpstart for
    Administrators, Power Users, and Developers
    http://www.outlookcode.com/jumpstart.aspx

> hi basically im creating a custom contact form in a Public Contacts
> folder.(Outlook 2002/2003,  Exchange 2000)
[quoted text clipped - 33 lines]
>
> Any help would be appreciated.
 
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.