Fix Error Code 2147467259

Learn to fix the runtime error code 2147467259 by reading this tutorial. This error is most commonly associated with Microsoft Access and to an extent Microsoft Excel.

When Does The Runtime Error -2147467259 Occur?

When you open Microsoft Access and a form through Automation and set focus to the form’s custom menu bar, you receive the following Microsoft Visual Basic error message:

Fix Runtime Error ‘-2147467259 (80004005)’ – Microsoft Access

The following steps are to be performed by professionals who are able to do code and work with coding terms accordingly. (Skip ahead if you’re not tech savvy)

Method 1: Trap For The Error

Enter a function similar to the following:

Function AutomationTest()
   On Error GoTo AutomationErr

   <Automation code goes here>

AutomationExit:
   Exit Function

AutomationErr:
   If Err.Number = -2147467259 Then
      Resume    'until control is visible.
   Else
      <handle any other errors>
   End If
End Function

Set focus by using code behind the form instead of the Automation code. For example, set the form's TimerInterval to 1000 (the value assigned may vary), and then add the following code to the form:

Private Sub Form_Timer()
   Me.TimerInterval = 0
   Application.CommandBars.ActiveMenuBar.Controls(1).SetFocus
End Sub

The run-time error that is mentioned in the “Symptoms” section occurs only when you use Automation. The occurrence varies based on whether or not Access is idle after the form opens, but before the Automation code attempts to set focus to a control. Variations in CPU speeds, program timing, and operating systems may cause this behavior to occur on some computers, but not others. Let’s see how to resolve it on the next page.

For Person’s Not Familiar With Coding

If you’re not tech savvy then you can try a simple and straightforward method to resolve the issue.

• Uninstall MS Access and Visual Basic
• Reinstall both of MS Access and Visual Basic

Sometimes this can help resolve the issue and saves you the time of having to go through all the coding. That is the workaround for the error code if it appears in Microsoft Access, now, let’s talk about the error code with regard to Microsoft Excel.

Microsoft Excel Runtime Error

If you encounter the error while using Microsoft Excel then consider the following:

• You have a macro that sets a property of a chart in Microsoft Excel. For example, the macro sets the MaximumScale, MinimumScale, Title, Axis, or Legend property of a chart.
• You protect the worksheet. When you do this, you click to select the Edit objects check box in the Protect Sheet dialog box.
• You run the macro.

In any of the above scenarios you will most likely encounter an error message that looks something like:

Error message 1