Wednesday, October 10, 2007

how can I display tooltip in cell at excel

In excel how can I display tooltip sort of information while typing in a cell in excel.

Select the cells, choose Data->Validation from the menu, then enter your message on the 'Input message' tab and OK out

Error: There is no MTS object context

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: There is no MTS object context


Source Error:


Line 36:
Line 37: // Save to memory. All parameters omitted
Line 38: int Count = objUpload.Save(Missing.Value, Missing.Value, Missing.Value);
Line 39:
Line 40:


Here is exception details given by VISUAL STUDIO.NET 2005

System.Runtime.InteropServices.COMException was unhandled by user code
Message="There is no MTS object context\r\n"
Source="Persits.Upload.1"
ErrorCode=-2146828221
StackTrace:
at ASPUPLOADLib.UploadManagerClass.Save(Object Path, Object Key, Object Ext)
at ASP.admin_upload_aspx.Page_Load(Object Source, EventArgs E) in e:\some folder name\some folder name\Upload_Sites.aspx:line 38
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


Solution:
1.Add < aspcompact="true"> the beginning of the aspx file like this..
2. Add Transaction="Required" the beginning of the aspx file like this..

example
<%@ Page Language="vb" SmartNavigation="true" AutoEventWireup="false" Codebehind="Form25NoticeCessation.aspx.vb" Inherits="Licensing.Form25NoticeCessation" Transaction="Required"%>