Search results

  1. AlexRigholt

    Use vba to disable "show add-in user interface"

    Hi, I finally managed to get the ribbon's File menu to work by removing all of Microsoft's options and adding my own. I just found out that I have to turn off the setting "show add-in user interface" for all of my 300+ users, to avoid a "Custom UI Runtime Error". This error gets triggered by...
  2. AlexRigholt

    64 bit declarations

    Hi, a year ago or so I found a list of function declarations for 64-bit. I didn't bookmark it and can't find it again - does anybody know where I can find it? I'd like to verify this bit of code: #If VBA7 Then Public Declare PtrSafe Function GetKeyState Lib "User32" (ByVal nVirtKey As...
  3. AlexRigholt

    can't run the macro or callback function 'GetEnabled

    Hi, I'm using Access 2010. In accdb all works. In accde I get: can't run the macro or callback function 'GetEnabled'. Make sure the macro or function exists and takes the correct parameters. I click OK six times to get rid of the error message, and after that icons on the custom ribbon can...
  4. AlexRigholt

    mdb works, mde doesn't

    My VBA code works when run in mdb format, but after converting it to mde it aborts at multiple places. I use Access 2003. References are all ok. Code compiles without an error. What should I check? Alex.
  5. AlexRigholt

    Add fields to a report

    Hello, In a dialog box users select what columns will appear in a report. How to make a report that includes only the selected fields, without having gaps between the columns?
  6. AlexRigholt

    how to suppress the title in OutputTo' html table?

    I use DoCmd.OutputTo acOutputTable, sGroup, acFormatHTML, "c:\Webinventory\" & sGroup & ".htm" The resulting table starts with a centered title with whatever the sGroup variable contains. Is there a way to suppress this title?
Top Bottom