Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report to PDF issue

Status
Not open for further replies.

ronwmon

Programmer
Jul 13, 2007
97
US
I am struggling with a problem with an Access report.

The code I am trying to use is currently in use in another Access database that is doing exactly the same thing. Over the years the older database has gone through many changes. I am attempting to create a new database that has less unnecessary code.

I have a large table that original was a csv file from a service provider we use. I have multiple queries and a few tables that are used in the database.

The report I am struggling with will show detail based on individual dealer (customer). The table needs to show the subscriber account number, the item number, the fee for the service provided and any overage charges form our provider. At the top of the report we want the dealer name and the invoice date.

Attached is the code that I have been using for the old database to accomplish the report I want but this doesn’t work for my new database. Also attached is the report. I would be happy to send the complete database with all of the data to anybody who wants to look at this but I don’t want to attach the complete database to this message. The two items that are commented are the Dealer List name, the new database is using a different name and the DealerID is text in the new database.

The results I am experiencing is that there is no separation between dealers. Every report is exactly the same, even the dealer name does not change. Every report has all of the history covering all of the dealer activity.

The PDF report name is correct, it has the dealer name followed by “.PDF”. So this element works correctly.

Any help is appreciated.
 
I see you have taken advantage of Debug.Print. Are the results in the debug window what you expect? Are you suggesting there is no filtering of the report or always filtering for the same one dealer?

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top