Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Report to PDF issue

Report to PDF issue

Report to PDF issue

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.

RE: Report to PDF issue

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?

Hook'D on Access
MS Access MVP 2001-2016

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close