Results 1 to 3 of 3
  1. #1
    ariansman is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2013
    Posts
    57

    how to solve this error?

    I made a form over a query and added a button to go and view next records. Then I added two unbound text boxes named: delay1 and delay2. Then I put this code in the visual basic:
    Sub delay1_AfterUpdate()


    Me.delay2 = 4
    End Sub

    The above code works only for the first record of the query.when I push the “next” button, It does not work for next records and l see the following error uppon updated the text box delay1:
    “The expression after update you entered was the event property setting produced error: A problem occurred while Microsoft access was communicating with the OLE server or ActiveX control.
    This error occurs when an event has failed to run because the location of the logic for the event cannot be evaluated. For example, if the OnOpen property of a form is set to = [Field], this error occurs because a macro or event name is expected to run when the event occurs.”
    I would appreciate any guide and comment.
    Thank you
    Last edited by ariansman; 04-30-2013 at 06:16 AM.

  2. #2
    1970Novacaine is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2013
    Posts
    1
    One thing I noticed is that you misspelled delay On the Me.delay2=4..... You have it as Me.de a lay2=4

  3. #3
    ariansman is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2013
    Posts
    57
    yes, that's true. it was a misspelling i did it here. in the real work i typed it correctly

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

Similar Threads

  1. Replies: 3
    Last Post: 03-13-2013, 04:00 PM
  2. How to solve syntex Error In INSERT INTO Statement?
    By kingsoh in forum Programming
    Replies: 0
    Last Post: 06-07-2012, 12:00 PM
  3. Replies: 3
    Last Post: 12-18-2011, 04:17 AM
  4. Even Microsoft Couldn't Solve This One...Can Anyone?
    By italianfinancier in forum Reports
    Replies: 2
    Last Post: 06-01-2011, 07:21 PM
  5. can you solve my problem please?
    By grad2009 in forum Access
    Replies: 2
    Last Post: 02-16-2010, 05:02 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