Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 202
  • Last Modified:

Invalidate a riboon

I have a ribbon named MyRibbon. How can I invalidate it from VBA?
0
jrmcanada2
Asked:
jrmcanada2
  • 2
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
What do you mean by "invalidate"? Do you mean stop it from showing, or disable it, or what?
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now