Search results

  1. A

    Visibility property in access 2013

    As I've said, there's no way to hide the separators. Therefore the proposal to disable the buttons to keep the layout..
  2. A

    Using DLookup to access a database

    Hi check the website of Avenius. http://www.accessribbon.de/en/ Not sure if it meets the Excel and Word
  3. A

    Visibility property in access 2013

    Well, far as I know has no control separators with attributes getVisible, so we can change. In tests I did on the 2013 version was also not possible to change the separators. I suggest disabling (getEnabled) instead of hiding the buttons.
  4. A

    Using DLookup to access a database

    Hi The link below is an excellent example available. http://www.ribbon01.com/downloads.asp It used the tag "Tab" to store the values ​​in the languages​​. Example of a button: <button id = "btSuppliers" imageMso = "DistributionListSelectMembers" getLabel="fncGetLabel" onAction =...
  5. A

    Remove or Hide File Tab on Custom Ribbon

    Hi Catalina is possible to clean the entire contents of the File Tab Add your personalized ribbon, part backstage: ... </ribbon> <!-- *** BACKSTAGE ***--> <backstage> <button idMso="FileSave" visible="false"/> <button idMso="SaveObjectAs" visible="false"/> <button...
  6. A

    Hide/Show Ribbon Tab using VBA

    Follows a small example, using the attribute getVisible to activate the Admin tab
  7. A

    Hide/Show Ribbon Tab using VBA

    Hi It has a video on the website below, which reinforces the explanation of his friend Lagbolt http://www.ribbons-access.com/ms-access/ribbon-creator-builder-and-editor-part-3.asp#inicio ..
  8. A

    Custom Ribbon is not activated on nsubform's.

    Hi Change the command to "True" that will work: Allow Full Menus = true
  9. A

    Hiding the Ribbon in A2007

    Hi Activate in VBA, the reference "Microsoft Office 12.0 object library"
  10. A

    Cancel button in input box returns error 13 = type mismatch

    Hi Sub TestInputBox() Dim x As String x = InputBox("Please enter the new production year", "Enter Production Year", Format(Date, "yyyy") + 1) If StrPtr(x) = 0 Then MsgBox "You cancel !" End If End sub
  11. A

    Question Print Preview Default Ribbon

    Hi Also create a custom ribbon for reports. <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <ribbon startFromScratch="true"> <tabs> <tab id="tabPrintPreview" label="Printer"> <group id="grpPrint" label="Printer" visible="true"> <button idMso="PrintDialogAccess"...
  12. A

    Hiding the Ribbon

    Hi See this article and watch the video http://www.ribbon01.com/tutoriais/tuto7eng.asp#inicio
  13. A

    SendKeys working incorrectly

    OR Dim ws As Object Set ws = CreateObject("WScript.shell") ws.SendKeys "{PGUP}"
  14. A

    Hiding the Ribbon

    Put the DoCmd.ShowToolbar "Ribbon", acToolbarNo command AutoExec macro that will lock the ribbon opening the application. Or upload a ribbon in the system table USysRibbons with the following XML: <customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui"> <!-- *** TAG COMMANDS...
  15. A

    Question Custom Menus

    This site has made ​​an application in Access to create ribbons at high speed. What pleased me most are the codes offered pre assembled. http://www.ribbons-access.com ..
  16. A

    or or or Question

    Or Select case me!ClientID case 147,151,187,189,190,191,193,197,198,199 .... do something case else ... end select
  17. A

    Sum not Concatenate

    Hi try (val(nz([value1];0))+val(nz([Value2];0)))
  18. A

    show the top of listbox

    Hi try me!lstBox.listindex =0 me!lstBox=-1
  19. A

    Relace Function with case sensitive

    Hi Try lResult = Replace(Me.Text1, "hotel", "motel", , , vbBinaryCompare) lResult = Replace(lResult, "Hotel", "Motel", , , vbBinaryCompare) lResult = Replace(lResult, "HOTEL", "MOTEL", , , vbBinaryCompare) Me.Text1 = lResult
  20. A

    Relace Function with case sensitive

    Hi try replace(me.text1,"hotel","motel",,,vbBinaryCompare)
Back
Top Bottom