value cannot be null. parameter name objecttype. Handles refer to controls which do not exist

 
 
Form designer will not open
Problem is that some code handles refer to controls that do not exist
Resolve these in the code then it should open.
 
I also found near this time that all of my BindingNavigator controls had been deleted
 
Advertisements

Late Binding e.g. to Office, Excel, Word etc

 
Option Strict Off
‘Early binding would require COM reference to Excel which brings in
‘   Microsoft.Office.Core
‘   Microsoft.Office.Interop.Excel
‘Imports Microsoft.Office.Interop
‘However late binding requires Option Strict Off
 
Public Class cls
    Private Sub CopyClipboardToExcel(Optional ByVal MyNewFileName As String = "")
        ‘Late Binding or distribute reference
        ‘http://msdn.microsoft.com/en-us/library/0tcf61s1.aspx
        Try
            ‘Dim xlApp As Excel.Application
            Dim xlApp As Object = CreateObject("Excel.Application")
            Dim xlBook As Object = xlApp.Workbooks.Add
            Dim xlSheet As Object = xlBook.Worksheets(1)
            xlSheet.Range("A1").Select()
            xlSheet.Paste()
            Call FormatExcelSheet(xlApp)
            ‘xlSheet.Cells(2, 2) = "This is column B row 2"
            xlSheet.Application.Visible = True
            If MyNewFileName <> "" Then
                xlSheet.SaveAs(MyNewFileName)
                ‘ Optionally, you can call xlApp.Quit to close the workbook.
            End If
        Catch ex As Exception
            If IsT1 Then
                Throw New ApplicationException(ex.Message, ex)
            End If
        End Try
    End Sub
End Class
 

SSIS fails 64-bit dts_e_cannotacquireconnectionfromconnectionmanager acquireconnection method call to the connection manager “sourceconnectionoledb” failed

Occured trying to connect on 64-bit computer to MSAccess
ssis error code dts_e_cannotacquireconnectionfromconnectionmanager.  the acquireconnection method call to the connection manager “sourceconnectionoledb” failed with error code 0xc0209303.  there may be error messages posted before this with more information on why the acquireconnection method call failed.
Answer:
Got to SSIS Project property page > Configuration Properties > Debugging > Run64BitRuntime change from True to False
Superhero answer here: