User Profile

Collapse

Profile Sidebar

Collapse
RogerThisToo
RogerThisToo
Last Activity: Jan 22 '14, 09:44 PM
Joined: Mar 20 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • RogerThisToo
    replied to MS Access Passing a Filter to a Graph using VBA
    in Access
    Thanks for the fast reply... ok about the code.

    The query is filtered dynamically just before the report is called. I do refere to it, but the filter is not applied. Do I need to create a new query or even table, from the dynamic filtered query, then refer to that new query/table in rowsource?
    See more | Go to post

      Leave a comment:

    • RogerThisToo
      started a topic MS Access Passing a Filter to a Graph using VBA
      in Access

      MS Access Passing a Filter to a Graph using VBA

      I use this code to build a filter to apply to the data (qry) in a report and it works great:

      Code:
      strCriteria = strCriteria & " AND [Standard] = " & "'" & cboStandard & "'"
DoCmd.OpenReport stDocName, acPreview, , strCriteria
      .. the report includes a Graph with the following RowSource

      Code:
      SELECT qryAuditHistoryList.Year, 
   Sum(qryAuditHistoryList.[NCR-Count])
      ...
      See more | Go to post
      Last edited by zmbd; Mar 20 '13, 01:11 PM. Reason: [Z{Please use the [CODE/] button to format posted code/html/sql - Please read the FAQ}{stepped the SQL}]
      No activity results to display
      Show More
      Working...