Recent content by msadiqrajani

  1. M

    Question Sync Pivot chart/Pivot table Filter

    Hi All, I one of my project I need to show a Pivot table and Pivot chart in a same report. For now, I have created a PivotTable and PivotChart using this method: techrepublic.com/article/add-a-pivot-chart-to-your-access-reports/6097020 And have successfully added in same report side by side...
  2. M

    Store SpecialCharacters eg: (<>+;,)in database and use in query

    Hi, I had large excel files which I imported to Excel database. The data contains special characters with stings..Eg: sometexr<var> + othertext<othervar>. The data is imported in access tables successfully, But I am unable to use these as a criteria in query. Query eg: update datatable set...
  3. M

    Query to filter data with some dates are null

    Hi, I have Access table with some null values in date column. I am trying to filter data based on date and name like date >= 1/1/2010 AND name = "Some Item" But problem is that, some I need to show data without any date filtering. So it shows all data with dates and without dates with only name...
  4. M

    Access Ribbon Callback

    I found my answer... Call back in access works differently from excel. In xml Typed onAction function this way <button id="BOMImport" label="Import Data" enabled="true" size="large" imageMso = "ImportExcel" onAction="=RibImportData()"/> And in VbA I created Public function this way...
  5. M

    Access Ribbon Callback

    Hello all. I am trying to add a callback to buttons on a custom tab but following error occurs. Microsoft Office Access Can't run the macro or callback function 'RibExportData'. Make sure the macro or function exists and takes the correct parameters. Heres my Ribbon XML which is generating...
See more
Top Bottom