Results 1 to 7 of 7
  1. #1
    Luzie is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    5

    Access Ribbon - getting Value from Editbox

    Hello



    my name is Luzie and i am coming from Germany.

    I have a question about Access Ribbon.

    I use Access 2010.

    How can i get the value from my editbox using a button-click

    Code:
    Sub OnActionButton(control As IRibbonControl)
        ' Callbackname in XML File "onAction"
    
        ' Callback for event button click
        ' Callback fuer Button Click
        
        Select Case control.ID
        
        Case "btn_suche"
        MsgBox "Value from Editbox"
        
      ....
    Thank you in advance for helping me.

    Luzie!

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    What is editbox - a textbox on form? Use concatenation.

    MsgBox "Value from " & Me.Editbox
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Luzie is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    5
    Hi

    no, sorry, i does not mean textbox.

    My question refers to creating Ribbon in VBA.

    Look here
    http://www.accessribbon.de/en/?Acces...ntrols:EditBox

    Is someone here who know about programming Ribbon?

    Luzie

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    I have done a little ribbon customization. This is ribbon customization I am not familiar with. What is its purpose? How do you implement it? I did get the tab to show on ribbon by calling the EditBox ribbon in form Ribbon property. Is that as far as you have gotten?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    Luzie is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    5
    My posted link is the description.
    I am familiar with ribbon customization, i have only a little problem with getting value from this editbox by using a button-control.
    No, i don't want to provide my project for analysis.

    thank you for answering.

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Another page from the referenced website http://www.accessribbon.de/index.php...Box_-_onChange

    This code worked to get the value from the EditBox:
    Public Sub MyEditBoxCallbackOnChange(control As IRibbonControl, strText As String)
    MsgBox strText
    End Sub

    You want to get the value only on button click on a form? Not on the change event of the EditBox? Not finding anything that addresses that.

    My only suggestion is to use the OnChange event above to set a global variable or a textbox on form. Then the form button click can grab value from the global variable or textbox.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    Luzie is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    5
    This was my suggestion too. If i found no other solution, i will use the OnChange event to set a global variable.
    Thank you very much for answering and thinking about my problem.

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

Similar Threads

  1. Access 2010 Ribbon
    By tcheck in forum Access
    Replies: 1
    Last Post: 11-01-2011, 08:50 AM
  2. Ribbon in access 2010
    By albealedin in forum Access
    Replies: 6
    Last Post: 09-16-2011, 11:31 AM
  3. Remove Access ribbon on start
    By azaz in forum Forms
    Replies: 2
    Last Post: 12-30-2010, 03:30 AM
  4. Access 2007 Ribbon
    By jgelpi in forum Programming
    Replies: 2
    Last Post: 07-21-2009, 04:05 PM
  5. How to add user-defined ribbon in access 2007
    By ali-gagi in forum Access
    Replies: 1
    Last Post: 07-02-2009, 07:01 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