Solved Printing Help (1 Viewer)

[OfficialChad]

Hi... being extremely new to Access, i am sitting here frustrated as anything trying to make this work. I will attempt to explain what I am trying to do.

I have a Main form that has subform. This Subform references a qry and pulls in all the checks info from the table but in the Main form I selected property sheets and linked a master field and a child field to display all the past checks of that selected client (as Shown in Image 1). What I am trying to do is add a print button on the form, so that the users can print off all the past check information on of just that client. Now I can use the normal print report feature and this prints of the entire report of all the checks of everyone, but what i would really like is the print button just to print that certain client check information and not all them just like it displays it on the Main form.
Ive had a look in the event field for the print button, but I have no idea of the commands to make it print like it shows in image 1. It prints like Image 2


I truly am lost, and seeking guidance from the masters here at Access World.

My printing problem is in your hands! Cheers!
from Chad!

 

[theDBguy]

Hi Chad. Welcome to AWF!

Are you using a button to print your report? If so, you could try something along this line:

DoCmd.OpenReport "ReportName", acViewPreview, , "ID=" & Nz(Me.ID,0)

The above code passes a filter to the report where the ID field matches the current ID on the form. So, make sure you use the correct name for your ID field when you try it. Cheers!

 

[OfficialChad]

Hi Chad. Welcome to AWF!

Are you using a button to print your report? If so, you could try something along this line:

DoCmd.OpenReport "ReportName", acViewPreview, , "ID=" & Nz(Me.ID,0)

The above code passes a filter to the report where the ID field matches the current ID on the form. So, make sure you use the correct name for your ID field when you try it. Cheers!

Thank you!
but I'm not quite understanding I tried it doing it but it asks for perimeters ID=
sorry if its a some what dumb question

 

[theDBguy]

Thank you!
but I'm not quite understanding I tried it doing it but it asks for perimeters ID=
sorry if its a some what dumb question

It will ask for a parameter "ID" if you don't have a field named ID. You will need to use the actual name of your field.

 

[OfficialChad]

It will ask for a parameter "ID" if you don't have a field named ID. You will need to use the actual name of your field.

In the clients table I have an ID field but I dont really wanna have the User memorize the clients ID's any other way i can do it ?

 

[theDBguy]

In the clients table I have an ID field but I dont really wanna have the User memorize the clients ID's any other way i can do it ?

You or your users don't have to memorize it. The code will take whatever is the ID on the form and use it.

Here's another place showing what I am saying. Maybe they can explain it better.

Reports: Print only the current record to a report

 

[OfficialChad]

Ohh I get now. Thank you! I would just need to add the Id field to the report qry? becouse it seems to still to "print" all the data

 

[theDBguy]

Ohh I get now. Thank you! I would just need to add the Id field to the report qry? becouse it seems to still to "print" all the data

Yes, give it a try and come back if it still doesn't work. Cheers!

 

[OfficialChad]

Yes, give it a try and come back if it still doesn't work. Cheers!

seems to still "print" all the data

 

[theDBguy]

seems to still "print" all the data

Hi. Are you able to post a sample copy of your db with test data?

 

[OfficialChad]

Hi. Are you able to post a sample copy of your db with test data?

Yes it not out to public so everything is a sample where can I upload it?

 

[theDBguy]

Yes it not out to public so everything is a sample where can I upload it?

Do a C&R and then zip up your db and then click on the Attach files button when you post a reply.

 

[OfficialChad]

Do a C&R and then zip up your db and then click on the Attach files button when you post a reply.

its still to large to upload it with a ZIP

 

[AccessBlaster]

Maybe this will help. Print the record in the form

 

[OfficialChad]

Maybe this will help. Print the record in the form

That Still still somewhat the same as the previous code just if and elses

 

[theDBguy]

That Still still somewhat the same as the previous code just if and elses

Hi. Yes, it's the same because that's what we're saying you will need to do/use. To demonstrate what we mean, I created a small demo file for you. Open the attached file and run the report first. You will see there are more than one record displayed when the report opens. Now, open the form and click on the button to open the same report again. You should see that it only prints one record when you click on the button. Hope that helps...

 

[AccessBlaster]

Chad, I feel like your table design needs more work before moving on to printing. I am not an expert by any means but, I do not think you need zip code as a stand alone table. Countries might not need its own table, contacts might be another word for customers. Compare your table to a normalized structure.

Northwind

HTH good luck with your project.

 

[OfficialChad]

Chad, I feel like your table design needs more work before moving on to printing. I am not an expert by any means but, I do not think you need zip code as a stand alone table. Countries might not need its own table, contacts might be another word for customers. Compare your table to a normalized structure.

Northwind

HTH good luck with your project.

Kinda wanted to have it on its own table becouse i have combo boxes that call to that zip when adding companies. same wiht countries when verifying what ID they have showed us. so those combo boxed call to the different tables so you dont have to type it all out. and yes Contacts is name for clients. if you have any way to help improve it im all ears! thanks again for the help!

 

[OfficialChad]

Hi. Yes, it's the same because that's what we're saying you will need to do/use. To demonstrate what we mean, I created a small demo file for you. Open the attached file and run the report first. You will see there are more than one record displayed when the report opens. Now, open the form and click on the button to open the same report again. You should see that it only prints one record when you click on the button. Hope that helps...

OH I see! ok ok. I think i found why it's doing this maybe.
the ID was different from ID in the report I just changed it to look at the client ID and make sure it matches to the ID on form and it worked! thank you guys so much! you guys are the Best!!!

 

[theDBguy]

OH I see! ok ok. I think i found why it's doing this maybe.
the ID was different from ID in the report I just changed it to look at the client ID and make sure it matches to the ID on form and it worked! thank you guys so much! you guys are the Best!!!

Hi. Glad to hear you got it to work. Good luck with your project.