J
Jeff Wimer
Why would VBA coding give different results on the printer from the print
preview?
preview?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Pat Hartman
The printed results should be correct. If you go page by page through the
report the preview results should also be correct. If you just skip
immediately to the end, you could end up with a discrepancy. Access doesn't
run the code to create each intermediate page.
report the preview results should also be correct. If you just skip
immediately to the end, you could end up with a discrepancy. Access doesn't
run the code to create each intermediate page.
J
Jeff Wimer
The report is a single page report. The VBA code is in the report to run a
YTD total across the page. It works great for the first couple of years, but
in 2005, since there is no data for Nov and Dec., it gives the answer for
the previous year.
YTD total across the page. It works great for the first couple of years, but
in 2005, since there is no data for Nov and Dec., it gives the answer for
the previous year.
P
Pat Hartman
Is your selection criteria correct? What about the report's grouping?
L
Larry Linson
What's the code? What is the data and how is it stored/accessed? It is
difficult, at best, to debug remotely; with only general information, it is
not possible.
Larry Linson
Microsoft Access MVP
difficult, at best, to debug remotely; with only general information, it is
not possible.
Larry Linson
Microsoft Access MVP