Results 1 to 6 of 6
  1. #1
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2007
    Join Date
    Mar 2012
    Posts
    528

    help in VBA

    Hello Guys
    Is it possible to help in VBA
    Has a button on a form when you pressure him to show me the message
    Click image for larger version. 

Name:	1.PNG 
Views:	12 
Size:	18.5 KB 
ID:	16143
    I put this code
    But show me an error message
    When the rice back to the macro does not show me the error FLIGHT
    As explained to you that the text of the message is not in English Is it possible is the reason


    Are there changes in the settings of VBA I do it ?


    MsgBox "تم عمل هذا المشروع من قبل طالبات كلية علوم الحاسوب / جامعة القادسية " & _
    vbCrLf & "الطالبة انظار صالح صاحب" & vbCrLf & "الطالبة حنان شناوة عريبي " & vbCrLf & "الطالبه سارة رشيد طالب", , "About"

  2. #2
    John_G is offline VIP
    Windows XP Access 2003
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    Where did you put this Msgbox code? You cannot put it in the On Click property for the button - you have to set the On Click property to [Event Procedure], and then put your code in the VBA Sub that is created.

    John

  3. #3
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2007
    Join Date
    Mar 2012
    Posts
    528
    Thank you John
    I already did that
    On Click property to [Event Procedure]

  4. #4
    send2steph is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2014
    Posts
    6
    Also, be sure to compile your code. Perhaps you are missing a reference? (Tools|References in the VBA editor).

  5. #5
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2007
    Join Date
    Mar 2012
    Posts
    528
    Thank you send2steph
    Yes
    And why he chose ?
    Click image for larger version. 

Name:	2.PNG 
Views:	10 
Size:	23.9 KB 
ID:	16146

  6. #6
    send2steph is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2014
    Posts
    6
    Those are the main four and look correct.
    I was able to attach your code to a button on a form in my current project and it worked for me.
    Sorry I couldn't help more.

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

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