Solved

Invalidate a riboon

Posted on 2014-01-20
4
193 Views
Last Modified: 2014-01-21
I have a ribbon named MyRibbon. How can I invalidate it from VBA?
0
Comment
Question by:jrmcanada2
  • 2
4 Comments
 
LVL 84
ID: 39796551
What do you mean by "invalidate"? Do you mean stop it from showing, or disable it, or what?
0
 
LVL 75
ID: 39797638
Invalidate is a VBA Ribbon command. The sample dbs that was on the link here have examples. Removing the link to the most useful Ribbon site on the planet seems a bit much :-(

mx
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 450 total points
ID: 39798111
The sample db attached from Here has examples of the Validate command.

Open the VBA editor and search for 'invalidate'

For example:

Private Sub btnSet_Click()
Dim strSQL As String

    If Nz(Me!lstData, 0) <> 0 Then
        strSQL = "UPDATE tblData SET tblData.txtName = '" & Nz(Me!txtText, " ") & "', tblData.txtSubName = '" & Nz(Me!txtSubText, " ") & "', tblData.txtImageMso = '" & Me!ComboImageMso & "', tblData.bolVisible = " & Me!chkVisible & " "
        strSQL = strSQL & "WHERE (((tblData.ID)=" & Me!lstData & ")); "
       
        CurrentDb.Execute strSQL
        Me!lstData.Requery
        Me!txtText = ""
        Me!txtSubText = ""
        Me!chkVisible = 0
        Me!lstData = Null
        Me!ComboImageMso = ""
    End If
   
    gobjRibbon.Invalidate
   
End Sub
InvalidateRibbonExample.zip
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now