Suresh Behera

Hotkey vs .Net Application

Hi,

     This gave me big surprise when i saw a post that the Hotkey are not displaying untill u press “ALT“ button on .Net application.But any how i found solution for this. Atually , this is behaviour of OS(XP and 2000) nothing wrong with .Net application.

1. Go to Desktop and right click on properties.

2. Click on Apearance Tab ,Click “Effect“ Button

3. It will looks like given below picture.

4. Uncheck the “Hide Underlined letters for keyboard navigation untill i press ALT Key “

This will solve ur problem. 

 

On other way we can do it programatically ..here is the code for it for more find the link

http://www.partware.com/ebooks/api/ref/d/destroywindow.html

Thanks to Herfried for this code

\\\
Private Declare Function SendMessage Lib "user32.dll" _
Alias "SendMessageA" ( _
    ByVal hWnd As IntPtr, _
    ByVal wMsg As Int32, _
    ByVal wParam As Int32, _
    ByVal lParam As Int32 _
) As Int32

Public Const WM_CHANGEUISTATE As Int32 = &H127

Public Const WM_QUERYUISTATE As Int32 = &H129
Public Const WM_UPDATEUISTATE As Int32 = &H128

Public Const UIS_SET As Int32 = 1
Public Const UIS_CLEAR As Int32 = 2
Public Const UIS_INITIALIZE As Int32 = 3

Public Const UISF_HIDEFOCUS As Int16 = &H1
Public Const UISF_HIDEACCEL As Int16 = &H2
Public Const UISF_ACTIVE As Int16 = &H4  ' Erfordert Windows XP.

Public Sub MakeAcceleratorsVisible(ByVal c As Control)
    SendMessage( _
        c.Handle, _
        WM_CHANGEUISTATE, _
        MAKELONG(UIS_CLEAR, UISF_HIDEACCEL), _
        0 _
    )
End Sub

Public Function LOWORD(ByVal dw As Int32) As Int16
    If dw And &H8000 Then
        LOWORD = &H8000 Or (dw And &H7FFF)
    Else
        LOWORD = dw And &HFFFF
    End If
End Function

Public Function HIWORD(ByVal dw As Int32) As Int16
    If dw And &H80000000 Then
        HIWORD = (dw \ 65535) - 1
    Else
        HIWORD = dw \ 65535
    End If
End Function

Public Function MAKELONG( _
    ByVal wLow As Int32, _
    ByVal wHigh As Int32 _
) As Int32
    MAKELONG = _
        LOWORD(wLow) Or (&H10000 * LOWORD(wHigh))
End Function

Private Sub Button1_Click( _
    ByVal sender As System.Object, _
    ByVal e As System.EventArgs _
) Handles Button1.Click
    MakeAcceleratorsVisible(Me)
End Sub
///

Happy coding cheers....

Suresh

 

 

 

 

Excellent resource on Excel

USING ADO AND ADO.NET WITH EXCEL: Resources and Known Issues
July 2002

General
-------
Q257819 HOWTO: Use ADO with Excel Data from Visual Basic or VBA
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q257819
Q303814 HOWTO: Use ADOX with Excel Data from Visual Basic or VBA
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q303814
Q278973 SAMPLE: ExcelADO Shows How to Read/Write Data in Excel Workbooks
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q278973
Q195951 HOWTO: Query and Update Excel Data Using ADO From ASP
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q195951

Transferring Data into Excel
----------------------------
Q247412 INFO: Methods for Transferring Data to Excel from Visual Basic
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q247412
Q295646 HOWTO: Transfer Data from ADO Data Source to Excel with ADO
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q295646
Q246335 HOWTO: Transfer Data from ADO Recordset to Excel with Automation
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q246335
Q319951 HOW TO: Transfer Data to Excel by Using SQL Server DTS
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q319951
Q306125 HOW TO: Import Data from SQL Server into Microsoft Excel
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q306125

Known Issues (most recent listed first)
------------
Q319998 BUG: Memory Leak When You Query Open Excel Worksheet with ADO
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q319998
Q316831 PRB: Cannot Configure Data Connection to Excel Files in VS .NET
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q316831
Q316809 BUG: No ADO Connection Error When Excel Workbook Is Not Found
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q316809
Q316756 PRB: Error w/ ADO.NET OLEDbDataAdapter to Modify Excel Workbook
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q316756
Q314763 FIX: ADO Inserts Data into Wrong Columns in Excel
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q314763
Q316475 PRB: "Operation Must Use an Updateable Query" Error Message
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q316475
Q300948 BUG: Incorrect TABLE_TYPE Is Returned for Excel Worksheets
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q300948
Q294410 ACC2002: Nulls Replaced w/ Next Field's Data Exporting to Excel
Q293828 BUG: Excel File Size Grows When You Edit ADO Recordset
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q293828
Q288343 BUG: Excel ODBC Driver Disregards FirstRowHasNames/HDR Setting
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q288343
Q246167 PRB: Collating Sequence Error Opening XLS as ADO Recordset
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q246167
Q211378 XL2000: 'Could Not Decrypt File' Error with Password-Protected File
Q194124 PRB: Excel Values Returned as NULL Using DAO OpenRecordset (mixed
data types)
Q189897 XL97: Data Truncated to 255 Characters with Excel ODBC Driver (Rows
To Scan)

VB/VB.Net (most recent listed first)
---------
Q319180 HOWTO: Transform Dataset to Spreadsheet XML for Microsoft Excel
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q319180
Q318373 HOW TO: Use GetOleDbSchemaTable with Excel in Visual Basic .NET
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q318373
Q316934 HOW TO: Use ADO.NET to Retrieve and Modify Records in Excel
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q316934
Q311731 HOW TO: Query and Display Excel Data by Using ADO.NET, VB .NET
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q311731
Q306022 HOW TO: Transfer Data to Excel Workbook Using Visual Basic .NET
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q306022
Q302094 HOWTO: Fill/Retrieve Excel Data Using Arrays From VB .Net

ASP/ASP.Net/Web (most recent listed first)
---------------
Q317719 HOW TO: Export Data in DataGrid on an ASP. NET WebForm to Excel
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q317719
Q308247 HOW TO: Use ASP.NET to Query and Display Database Data in Excel
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q308247
Q307603 HOW TO: Write Binary Files to the Browser Using ASP.NET & VB
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q307603
Q306572 HOW TO: Query and Display Excel Data by Using ASP.NET, ADO.NET
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q306572
Q276488 HOWTO: Use ADODB.Stream to Read Binary Files to the Browser
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q276488
Q257757 INFO: Considerations for Server-Side Automation of Office
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q257757
Q199841 HOWTO: Display ASP Results Using Excel in IE with MIME Types
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q199841
Q195951 HOWTO: Query and Update Excel Data Using ADO From ASP
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q195951

SQL Server/DTS (most recent listed first)
--------------
Q321686 HOW TO: Import Data into SQL Server from Excel
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q321686
Q319951 HOW TO: Transfer Data to Excel by Using SQL Server DTS
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q319951
Q306397 HOWTO: Use Excel w/ SQL Linked Servers & Distributed Queries
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q306397
Q306125 HOW TO: Import Data from SQL Server into Microsoft Excel
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q306125
Q281517 PRB: Transfer of Data from Jet 4.0 OLEDB Source Fails w/ Error
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q281517
Q236605 PRB: DTS Wizard May not Detect Excel Column Type for Mixed Data
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q236605
Q231880 BUG: Import Wizard Fails if Excel File Open During Import/Export
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q231880t
Q207446 BUG: Cannot Import Excel 97 Spreadsheet with 256 or More Columns
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q207446

XML (most recent listed first)
---
Q319180 HOWTO: Transform Dataset to Spreadsheet XML for Microsoft Excel
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q319180
Q307021 HOW TO: Transfer XML Data to Microsoft Excel 2002 with VB .NET
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q307021
Q285891 HOWTO: Use VB or ASP to Create an XML Spreadsheet for Excel 2002
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q285891
Q278976 HOWTO: Transform Excel XML Spreadsheet for Server-Side Use
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q278976

ADO within Excel (most recent listed first)
----------------
Q291199 XL2002: "Invalid Use of New Keyword" Error Using ADODB Library
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q291199
Q263498 BUG: Run-Time Error 5 Using Add Method of QueryTables Collection
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q263498
Q244761 XL2000: How to Use ADO to Return Data to a ListBox or ComboBox
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q244761
Q228633 OFF2000: "Catastrophic Failure" Error Running Samples.xls Macro
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q228633
Q225059 XL2000: "Invalid Use of New Keyword" Error Using ADODB Library
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q225059