Search results

  1. A

    Reports Context Menu

    Hi In the article below has an image for viewing a macro mounted in Access 2010. Download the sample file, and study the macro used. http://www.usandoaccess.com.br/tutoriais/criar-menus-de-atalho-com-vba-ou-macro.asp?id=1#inicio
  2. A

    Can you put a custom button on the QAT

    Hi ... <!-- ***TAG QAT***--> <qat><documentControls> <button idMso = "PublishToPdfOrEdoc" label="PDF"/> </documentControls></qat> ... OR ... <!-- ***TAG QAT***--> <qat><documentControls> <button id = "btPublishPdf" imageMso = "PublishToPdfOrEdoc" onAction = "=fncPublishPdf()"/>...
  3. A

    Reports Context Menu

    Hi https://support.office.com/en-US/Article/Create-custom-menus-and-shortcut-menus-by-using-macros-5bd538ff-19c4-4dfe-9540-3309aebf8a1a
  4. A

    Hello from Brazil!

    Cesar, Welcome !. You will find here a lot of people willing to help. My tip is that you visit the following site from Brazil: http://www.usandoaccess.com.br/tutoriais.asp#inicio
  5. A

    Disable navigation pane, not just minimize/hide it

    Hi Why not just change the extension ACCDB to ACCDR ?
  6. A

    Button to go to desktop from form

    Or Application.FollowHyperlink "C:\Users\" & environ("UserName") & \Desktop\"
  7. A

    Question Custom Toolbar

    Hi If you want learn how customize ribbons, check these two sites as reference: http://www.ribbons-access.com http://www.accessribbon.de/en
  8. A

    Disabling and security

    Hi See this site as personalizing ribbons. http://www.ribbons-access.com To disable the custom ribbons, just hold down the Shift key at startup. Use the ACCDR extension to block access structure. When you want to change the project, return to ACCDB.
  9. A

    Access Ribbon Customisation

    Hi See if this article helps you. Learn to use getImage attribute. http://www.ribbons-access.com/ms-access/ribbon-creator-builder-and-editor-part-4.asp#inicio Download the sample file ..
  10. A

    Changing RIbbons

    Hi See this article about using getVisible and Invalidate. http://www.ribbons-access.com/ms-access/ribbon-creator-builder-and-editor-part-3.asp#inicio ..
  11. A

    Disabling Ribbon prevents doCmd.SAve

    Hi Try with the command: docmd.RunCommand acCmdSaveRecord
  12. A

    2010 runtime ribbon

    Hi Add the attribute Visible = true and see if it works. <button idMso="ExportExcel" size="large" visible="true"/>
  13. A

    Custom ribbon not showing for other users

    Hi The site below is a reference for you to learn how to customize ribbons http://www.accessribbon.de/en/ This is also great because it has videos. http://www.ribbons-access.com read this great article...
  14. A

    IS THERE ANY alternative for SENDKEYS

    Hi Try using the sendkeys of the WScript. See the question 10. http://www.ribbon01.com/tutoriais/faq.asp
  15. A

    Limit on embedded IIF statement in query

    Hi If it is not possible to change the structure of your query, I suggest using the switch() function, which solves the limitation of fields. example: switch([q1]=2;"GAP";[q2]=2;"GAP";[q3]=2;"GAP";...;[q17]=2;"GAP")
  16. A

    Access 2013 Calculated Field Help

    Hi Another way is to convert to minutes. Example: datediff("n",#05/08/2014 01:08#,#05/12/2014 15:07#) :::> 9599 minutes Make the necessary calculations on the basis of minutes which is pretty easy, because it is integer type In the end, then just convert the minutes to the format "hh:mm"...
  17. A

    Remarks with number

    Hi One other way to lead a horse to the source. Copy and paste the function below to a global module: Public Function fncGrade(intNum%) As String Select Case intNum Case 0 To 32: fncGrade = "C-1" Case 33 To 40: fncGrade = "C-2" Case 41 To 50: fncGrade = "C-3" Case 51 To 60...
  18. A

    IIF/Switch: The expression you entered is too complex

    Hello! For this case I suggest you use a function. Something like: Public function fncFileStatus(strStatus as string) as striing select case strStatus case "Application": fncFileStatus = "02. Application" case "Sent To Processing": fncFileStatus = "03. Sent To Processing" case "HMDA...
  19. A

    INSERT INTO Or UPDATE Multivalued field

    Hi See if this example helps you. (use google translator) http://www.usandoaccess.com.br/tutoriais/tuto61.asp?id=1#inicio
  20. A

    Current time and date on msgbox

    Hi Msgbox now or Msgbox time & " - " & date()
Back
Top Bottom