If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Command button to Print/View Customer
I have a form named Orders by Customer that has a subform with all the
customer's orders and I want to add a command button on the bottom so that when an individual customer is showing along with all their information I can print/view that info for that customer showing. Is there a way I can do this? Thanks in Advance |
#2
|
|||
|
|||
Command button to Print/View Customer
Design the report for Customer Orders using the report wizard. Then, add
your command button to the form and use the openreport method to open for the customer that is current. See VB Help for the openreport method use. Damon "teelee" wrote in message ... I have a form named Orders by Customer that has a subform with all the customer's orders and I want to add a command button on the bottom so that when an individual customer is showing along with all their information I can print/view that info for that customer showing. Is there a way I can do this? Thanks in Advance |
#3
|
|||
|
|||
Command button to Print/View Customer
I already have a report with customers orders and added the command button,
but when I click on it I get all the customers showing on the report. I only need the customer that is showing in the subform. Thanks "Damon Heron" wrote: Design the report for Customer Orders using the report wizard. Then, add your command button to the form and use the openreport method to open for the customer that is current. See VB Help for the openreport method use. Damon "teelee" wrote in message ... I have a form named Orders by Customer that has a subform with all the customer's orders and I want to add a command button on the bottom so that when an individual customer is showing along with all their information I can print/view that info for that customer showing. Is there a way I can do this? Thanks in Advance |
#4
|
|||
|
|||
Command button to Print/View Customer
Okay, On the command button's properties, you will find the click event.
click on the (...) dots to go to the VB Editor. Add this code, substituting your field and report names as needed.. Private Sub Command1_Click() ' your button may have a different name DoCmd.OpenReport "Report1", acViewPreview, , "CustomerID= " & Text0, acWindowNormal '(in this case, the field Text0 holds the CustomerID on your form. "CustomerID" is the name of the field in the table and on your 'report.) This restricts the report to the customerID of your current form. End Sub Damon "teelee" wrote in message ... I already have a report with customers orders and added the command button, but when I click on it I get all the customers showing on the report. I only need the customer that is showing in the subform. Thanks "Damon Heron" wrote: Design the report for Customer Orders using the report wizard. Then, add your command button to the form and use the openreport method to open for the customer that is current. See VB Help for the openreport method use. Damon "teelee" wrote in message ... I have a form named Orders by Customer that has a subform with all the customer's orders and I want to add a command button on the bottom so that when an individual customer is showing along with all their information I can print/view that info for that customer showing. Is there a way I can do this? Thanks in Advance |
#5
|
|||
|
|||
Command button to Print/View Customer
Ok this is what I have: Private Sub Preview_Report_Click()
DoCmd.OpenReport "Rpt Customer" acViewPreview , , "CustomerID=" & Text0, acWindowNormal End Sub and this is the error message I'm getting: Compile error Invalid use of Property Any Suggestions of what I'm doing wrong? Thanks DoCmd.OpenReport "Rpt Customer" acViewPreview , , "CustomerID=" & Text0, acWindowNormal End Sub "Damon Heron" wrote: Okay, On the command button's properties, you will find the click event. click on the (...) dots to go to the VB Editor. Add this code, substituting your field and report names as needed.. Private Sub Command1_Click() ' your button may have a different name DoCmd.OpenReport "Report1", acViewPreview, , "CustomerID= " & Text0, acWindowNormal '(in this case, the field Text0 holds the CustomerID on your form. "CustomerID" is the name of the field in the table and on your 'report.) This restricts the report to the customerID of your current form. End Sub Damon "teelee" wrote in message ... I already have a report with customers orders and added the command button, but when I click on it I get all the customers showing on the report. I only need the customer that is showing in the subform. Thanks "Damon Heron" wrote: Design the report for Customer Orders using the report wizard. Then, add your command button to the form and use the openreport method to open for the customer that is current. See VB Help for the openreport method use. Damon "teelee" wrote in message ... I have a form named Orders by Customer that has a subform with all the customer's orders and I want to add a command button on the bottom so that when an individual customer is showing along with all their information I can print/view that info for that customer showing. Is there a way I can do this? Thanks in Advance |
#6
|
|||
|
|||
Command button to Print/View Customer
On Sun, 4 May 2008 15:43:00 -0700, teelee
wrote: Ok this is what I have: Private Sub Preview_Report_Click() DoCmd.OpenReport "Rpt Customer" acViewPreview , , "CustomerID=" & Text0, acWindowNormal End Sub and this is the error message I'm getting: Compile error Invalid use of Property Any Suggestions of what I'm doing wrong? Thanks DoCmd.OpenReport "Rpt Customer" acViewPreview , , "CustomerID=" & Text0, acWindowNormal If you have a textbox named Text0 on the form, change Text0 in the above to Me!Text0 That's a default name for a control, but it's a really bad name from a usability and documentation standpoint; consider renaming the control and using the new name in the Me! expression. -- John W. Vinson [MVP] |
#7
|
|||
|
|||
Command button to Print/View Customer
As I said: "substituting your field and report names as needed"- do you
really have a "text0" textbox with the recordsource set to CustomerID? If not, change the line to your textbox name. and take John's advice and include the "me." although it will work without it. Also, the line beginning "DoCmd." should all be on one line, hopefully that is what you did, sometimes its hard to tell with News posts. Damon "teelee" wrote in message ... Ok this is what I have: Private Sub Preview_Report_Click() DoCmd.OpenReport "Rpt Customer" acViewPreview , , "CustomerID=" & Text0, acWindowNormal End Sub and this is the error message I'm getting: Compile error Invalid use of Property Any Suggestions of what I'm doing wrong? Thanks DoCmd.OpenReport "Rpt Customer" acViewPreview , , "CustomerID=" & Text0, acWindowNormal End Sub "Damon Heron" wrote: Okay, On the command button's properties, you will find the click event. click on the (...) dots to go to the VB Editor. Add this code, substituting your field and report names as needed.. Private Sub Command1_Click() ' your button may have a different name DoCmd.OpenReport "Report1", acViewPreview, , "CustomerID= " & Text0, acWindowNormal '(in this case, the field Text0 holds the CustomerID on your form. "CustomerID" is the name of the field in the table and on your 'report.) This restricts the report to the customerID of your current form. End Sub Damon "teelee" wrote in message ... I already have a report with customers orders and added the command button, but when I click on it I get all the customers showing on the report. I only need the customer that is showing in the subform. Thanks "Damon Heron" wrote: Design the report for Customer Orders using the report wizard. Then, add your command button to the form and use the openreport method to open for the customer that is current. See VB Help for the openreport method use. Damon "teelee" wrote in message ... I have a form named Orders by Customer that has a subform with all the customer's orders and I want to add a command button on the bottom so that when an individual customer is showing along with all their information I can print/view that info for that customer showing. Is there a way I can do this? Thanks in Advance |
Thread Tools | |
Display Modes | |
|
|