Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. You receive an error message when you start Visual Basic for Applications code in an Access database

You receive an error message when you start Visual Basic for Applications code in an Access database

Symptoms

When you start Microsoft Visual Basic for Applications (VBA) code in a Microsoft Access database, you may receive an error message that resembles the following:
The expression On Click you entered as the event property setting produced the following error: A problem occurred while Microsoft Access was communicating with the OLE Server or ActiveX Control.

↑ Back to the top

Cause

This issue may occur if the following conditions are true:
  • You create an event handler, a function, or a subroutine to start the VBA code in an Access form or report.
  • You run the VBA code on a computer that uses different non-Unicode language settings than the computer on which you created the event handler, the function, or the subroutine.
Note This issue may also occur if the VBA code contains accented characters or special characters. Additionally, this issue may occur if an object name in the Access database contains accented characters or special characters.

↑ Back to the top

Resolution

To resolve this issue, use the appropriate method.

Method 1: Verify the non-Unicode language

If you are running the VBA code on a Microsoft Windows XP-based computer or on a Windows 2000-based computer, you may be able to resolve this issue by changing the non-Unicode language setting on the computer where you are running the VBA code. To verify and to change the non-Unicode language setting, follow these steps.

Note Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.
  1. Click Start, click Run, type Intl.cpl, and then click
    OK.
  2. Under Language for non-Unicode programs on the Advanced tab, verify that the language matches the language on the computer on which you created the event handler, the function, or the subroutine. If the language differs, click the language that you want, and then click OK.
  3. Restart the computer.

Method 2: Remove accented characters or special characters from the VBA code and from database objects

To resolve this issue, remove any accented characters or special characters that appear in the VBA code or in database objects. For example, form sections and report sections that were created in localized versions of Access may contain accented characters or special characters.

To rename an Access object, or a section in an Access object, that contains accented characters or special characters, follow these steps:
  1. Start Access, and then open the database that you want.
  2. Right-click the form or report that you want, and then click Design view.
  3. Right-click the object that you want, and then click
    Properties.
  4. On the All tab in the
    Name box, type a name that does not contain accented characters or special characters.
  5. After you rename the objects, open Visual Basic Editor to determine whether your changes appear in the VBA code. The objects may retain the original names. If this behavior occurs, you must manually rename the objects in the VBA code.

↑ Back to the top

Steps to reproduce the issue

  1. Start Access on a computer where the Russian versions of Windows XP and Microsoft Office 2003 are installed.
  2. Create a new Access database.
  3. Add a form to the database. By default, a form that is named Form1 is created.
  4. In Design view, add a command button to the form.
  5. Right-click the command button that you added in step 4, and then add the following code example to the Click event for the command button.
      
    On Error GoTo Err_cmdMsgBox_Click
    MsgBox "Hello World"
    Exit_cmdMsgBox_Click:
    Exit Sub
    Err_cmdMsgBox_Click:
    MsgBox Err.Description
    Resume Exit_cmdMsgBox_Click
  6. Compile the Access database.
  7. Close the Visual Basic code window, and then close the Access database.
  8. On a computer where the English versions of Windows XP and Office 2003 are installed, verify that the non-Unicode language is set to English (United States).
  9. Copy the Access database that you created in step 2 to the computer in step 8.
  10. Open the Access database, open the form that contains the command button, and then click the command button to run the VBA code.

↑ Back to the top

Keywords: kbentirenet, kbtshoot, kbbug, kbprb, kb, kbarchive

↑ Back to the top

Article Info
Article ID : 907337
Revision : 1
Created on : 1/7/2017
Published on : 10/30/2008
Exists online : False
Views : 996