Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Form Dilemma (A2k SP3)

    Attached is db in question:

    Main form is frm_Complaints with 4 subforms on a Tab Control. After the user enters the ComplaintID I would like to have the ComplaintDate updated automatically with Date. The code is in the After Update Event of the ComplaintID. When I enter a new Complaint ID, I receive the following error message:

    "The expression After Update 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."

    I am clueless. Thanks in advance

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Form Dilemma (A2k SP3)

    Your database appears to be slightly corrupt, but fortunately it's easily solved:
    - Create a blank new database.
    - Import all database objects from the problem database into the new one.
    The code should work in the new database. It does for me.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form Dilemma (A2k SP3)

    Thanks Hans. Did the trick.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •