Results 1 to 3 of 3
  1. #1
    Goodge12 is offline Novice
    Windows XP Access 97
    Join Date
    Sep 2008

    Two forms: same VBA script, different result on click

    I created a database that serves as a workflow for some of our employees. It has been working fine for a long time, but now there is an issue.

    Each employee has their own form. All the forms are identical in appearance and function. The only difference is that the forms are based on queries that pull issues only for that specific employee.

    One of the employees now receives an error message when she clicks on any of the macros or calendar pop-up buttons.

    It reads:

    The expression On Click you entered produced the following error: A problem occurred while Microsoft Office Access was communicating with the OLE server or ActiveX Control.

    It doesn't do this on any of the other forms, even though they have the exact same VBA script.

    Anyone know how to fix? Anyone run into this before?

  2. #2
    Goodge12 is offline Novice
    Windows XP Access 97
    Join Date
    Sep 2008
    No one? I mean... 65+ views and not one of you has run into this before? I find that hard to believe... Come on folks, PLEASE help me out

  3. #3
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    8300' in the Colorado Rocky Mountains
    Have you tried Compact and Repair? How about importing into a new db?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Login Script
    By theITguy in forum Access
    Replies: 2
    Last Post: 03-06-2009, 03:37 AM
  2. Search result links adding extra info
    By Vbcw in forum Programming
    Replies: 0
    Last Post: 12-19-2008, 12:19 PM
  3. Result of Count Query not known elsewhere
    By Carole in forum Access
    Replies: 1
    Last Post: 09-07-2008, 09:39 AM
  4. Replies: 2
    Last Post: 08-04-2008, 04:16 PM
  5. Open Accesss DB by batch script
    By micada in forum Access
    Replies: 0
    Last Post: 06-10-2008, 02:33 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums