Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-10-2019, 06:03 AM   #1
Confuseduk
Newly Registered User
 
Join Date: May 2019
Location: Somerset UK
Posts: 10
Thanks: 11
Thanked 0 Times in 0 Posts
Confuseduk is on a distinguished road
Printing help Please

Hi
I have a working database my work (self employed driver).
Up to now I have been using a hand written form to record my jobs but I would like to have all this computerized.
I have a Customer Table (CustT) with Customer Details And a Job Table (BookingJobT) with Details of my runs.
My relationship is a one to many between [CustT] [CustID]and [BookingJobT] [BookingJobID].
I have a working form (thanks to some help from Mike60Smart) which has customer details as the main form with a subform within for the job details.
To display my jobs I can Select Customer and cycle through that customers jobs using the navigation keys.
I have designed a Report to display the results as per my old written forms via a print button on the customer form.
However every time i try to print the job my printer prints a list of each of that customers jobs.
How do I program the button to print only the job that is on display on my screen with its heading?
Thanks.

Confuseduk is offline   Reply With Quote
Old 07-10-2019, 06:41 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 3,063
Thanks: 36
Thanked 729 Times in 712 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Printing help Please

Hi. What does the code for the print button look like? You should be able to modify it to add a criteria or where condition to limit the report to the current record.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
Confuseduk (07-11-2019)
Old 07-10-2019, 09:48 PM   #3
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,674
Thanks: 2
Thanked 2,060 Times in 2,015 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: Printing help Please

Or post your database with some sample data + name of the form where the button is.
Zip the database because you haven't post 10 post yet.

__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
The Following User Says Thank You to JHB For This Useful Post:
Confuseduk (07-11-2019)
Old 07-11-2019, 09:12 AM   #4
Confuseduk
Newly Registered User
 
Join Date: May 2019
Location: Somerset UK
Posts: 10
Thanks: 11
Thanked 0 Times in 0 Posts
Confuseduk is on a distinguished road
Re: Printing help Please

Thanks for both of your prompt responses.
Here is a copy of the Db

I am not too sure what is behind the buttons but it is the print record button on the customer form.
I have tried writing code to make the button work specifically using the me. Statement in vba (thinking this is what i need) but I am still in very early days of learning the complexities of Access and it would be nice to have a working db meanwhile.
Thanks everyone.
Attached Files
File Type: zip Copy to Send.zip (869.6 KB, 10 views)
Confuseduk is offline   Reply With Quote
Old 07-11-2019, 10:25 AM   #5
KHallmark
Newly Registered User
 
Join Date: Jul 2019
Posts: 13
Thanks: 0
Thanked 1 Time in 1 Post
KHallmark is on a distinguished road
Re: Printing help Please

In your report you can group your jobs by client. Right click on the client's name and click group on. It will show all the client's jobs, but not show the client's name over and over.
KHallmark is offline   Reply With Quote
The Following User Says Thank You to KHallmark For This Useful Post:
Confuseduk (07-12-2019)
Old 07-11-2019, 11:48 AM   #6
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 7,203
Thanks: 57
Thanked 2,313 Times in 2,219 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Printing help Please

add an Unbound textbox that will hold the JobNumber and include this as Criteria on your macro.

see the form in design view, also the macro that runs the report for the changes I made.
Attached Files
File Type: zip Copy to Send.zip (872.4 KB, 8 views)
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
Confuseduk (07-12-2019)
Old 07-12-2019, 12:55 PM   #7
Confuseduk
Newly Registered User
 
Join Date: May 2019
Location: Somerset UK
Posts: 10
Thanks: 11
Thanked 0 Times in 0 Posts
Confuseduk is on a distinguished road
Re: Printing help Please

Thank you all so much for your inputs and help, especially Arnelgp who has made it work for me for the first time in about 6 months (I'm obviously a slow learner).
I shall Study the changes that yu have made and try to learn for myself for the future. Meanwhile I can begin to update the tables again.
Thank you again
Nigel


Confuseduk is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing code slowing down printing reports Chrisopia Modules & VBA 1 02-25-2014 09:58 AM
Hide printing information when start printing/exporting access 2007 junior3000 Modules & VBA 0 08-26-2010 09:55 AM
Printing Product Labels - Batch Printing lots. Spam Reports 1 12-21-2008 11:11 PM
printing stu96art Tables 1 03-06-2003 01:03 AM
Printing mark curtis Reports 1 02-05-2002 06:44 AM




All times are GMT -8. The time now is 02:33 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World