Search results

Hi strUpdate = "UPDATE Expiration Set Removed = '" & Exp2 & "' , RemovedBy = '" & Exp3 & "' WHERE ExpirtionID = " & Exp1

Hi You use a folder in c drive (c:\YourFolder\YourBe.accdb) or this using the Program Files folder?

Hi strCreditCheck = "TermsId IN (SELECT TermsID FROM companies WHERE company_id = " & strCompany_id & ")"

Hi Create a shortcut to open your application and use the EXCL command in the calling line. example: c:\YourFolder\YourBd.accdb /EXCL

Hi environ("computername")

Hi <group id="grpClose" label="Close Preview"> <button idMso="PrintPreviewClose" size="large" label="Close" /> </group>

Hi <group idMso="GroupPrintPreviewClosePreview"/> We can not have nested groups. Position out of any group.

Hi To load a form on startup just enter it in the "Options" Access> current database. You can also use the AutoExec macro. The simplest way to disable the ribbon and navigation pane is changing the extension from ACCDB to ACCDR. To reactivate the ribbon and navigation pane, go back to ACCDB...

Hi XML is written with errors. See the correct writing and compare with yours. <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <ribbon startFromScratch="true" /> </customUI>

Hi You have to build a ribbon for each version of Access (2007, 2010 and 2013). Access 2007 does not have the File Tab (backstage) . View a graphic representation of the differences in mounting for XML. http://www.ribbon01.com/tutoriais/tuto6eng.asp#inicio The backstage differs between...

Hi Watch this video and download the sample. http://www.ribbon01.com/tutoriais/tuto11eng.asp#inicio Good study!

Hi look at question number two of how to call for a macro. http://www.ribbon01.com/tutoriais/faq.asp If you do not know to mount custom ribbon, has the option of setting up a shortcut menu. See how in this article...

Hi Paste here the XML of your ribbon to the reports.

Hi Disable through the event "Open" form Private Sub Form_Open(Cancel As Integer) Me.ShortcutMenu = False End Sub

Hi The Group Sort and filter not attend? <group idMso="GroupSortAndFilter" />

Hi Are you using the schema version 2007. <customUI xmlns="://schemas.microsoft.com/office/2006/01/customui"> For versions 2010 and 2013 use the scheme below: <customUI xmlns="://schemas.microsoft.com/office/2009/07/customui"> This site below has great videos about the ribbons...

Hi Might work if you store the flag in the list of properties (or in a field of a table). To create a property, run only once the following code: Dim prpNew as Property Set prpNew = CurrentDb.CreateProperty("isHidden", dbBoolean, 0) CurrentDb.Properties.Append prpNew Change your code to...

Hi You can choose to load the group "Sort and Filter", as described in the XML code below: customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui"> <ribbon startFromScratch="true"> <tabs> <tab id = "tabForm" label = "Form" > <group idMso = "GroupSortAndFilter" /> </tab> </tabs>...

Hi In your case it is better to apply the reverse, ie, disables all tabs with startFromScratch = "true" and then enable only the desired tab. example: <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <ribbon startFromScratch="true"> <tabs> <tab...

I apologize. The getVisible works for saparator in Access 2013. Here's an example. I think just use the same criteria for the corresponding button. Public Sub fncGetVisible(control As IRibbonControl, ByRef visible) Select Case control.id Case "sp100" visible = (booStatus = False)...