Search results

Be sure your query isn't Distinct, Access property Unique Rows. If your query has unique rows selected it can't be used in a form to update.

I struggled with this for a couple days. It seems you need to close the current window and then open the report in Print Preview. I have a button on a pivotchart embedded in a Report. (Access2010) When i tried to just print the report- any filtering on the pivot chart didn't get carried over...

Thank you! I just needed to look at this from a different angle. I coded my print button Option Compare Database the save in unnecessary for the print but I added it so the report would open at the same point next time. Private Sub Command1_Click() DoCmd.Save acReport, "R-BPChart"...

I filter the report by using the Pivot Table/Chart filter. The chart is on a report that I am viewing in report view. I just tried filtering the report going to print preview (both from the View tab and backstage from Print-print preview and it works.) This is a workable solution, but it...

I have a report with a Pivot Chart tracking weight. There are several clients that I can filter the pivot chart on. When I open the report, the chart prints fine with the original chart. When I filter the report on a different client it looks fine on the screen but still prints the original...