Results 1 to 3 of 3
  1. #1
    Akchayan is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Aug 2022
    Posts
    102

    Error Code when i click a Button

    I have this error as soon as i click a button:
    You have entered the expression On click as the setting of the event property. This expression has caused an error: A problem occurred while Microsoft Access was communicating with the OLE server or the AvitveX control.

    And this is the code i have:



    Code:
    Private Sub Befehl109_Click()If IsNull(Me!cmbMitarbeiter) Then
                MsgBox "Fülle das Feld Mitarbeiter aus "
             Else
       DoCmd.ApplyFilter , "[IDPersonal] = [Forms]![foLohnabrechnungsKontrolle]![cmbMitarbeiter]"
    End Sub
    And i dont understand at all why the error occures, can somebody help?

  2. #2
    Akchayan is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Aug 2022
    Posts
    102
    I solved it.

  3. #3
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,933
    Quote Originally Posted by Akchayan View Post
    I solved it.
    So please tell us how. After all these forums are here to help others?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

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

Similar Threads

  1. Button On click change VBA code
    By sparky23 in forum Programming
    Replies: 1
    Last Post: 08-24-2019, 03:40 PM
  2. Replies: 6
    Last Post: 11-10-2017, 05:00 PM
  3. Replies: 2
    Last Post: 09-21-2017, 05:34 AM
  4. Skip section of code on button click
    By NovoRapid in forum Modules
    Replies: 2
    Last Post: 02-05-2015, 02:43 PM
  5. Replies: 2
    Last Post: 10-09-2014, 11:37 AM

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