By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,482 Members | 2,411 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,482 IT Pros & Developers. It's quick & easy.

invoice report - original + copies

P: 38
I've created an invoice form which generates a report.
I've also created a form in which the user defines how many copies he wants to print with the original (with a loop to the number of copies etc).
I need to join this form to the print button in the invoice so after the user states he's willing to save, this form pops up and the user states the copies number he's interested in.
How do I do it please?
The end result I'm aimint at is the caption to change once "original" and then "/
copy".
Thanks.
Oct 14 '07 #1
Share this Question
Share on Google+
5 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
I've created an invoice form which generates a report.
I've also created a form in which the user defines how many copies he wants to print with the original (with a loop to the number of copies etc).
I need to join this form to the print button in the invoice so after the user states he's willing to save, this form pops up and the user states the copies number he's interested in.
How do I do it please?
The end result I'm aimint at is the caption to change once "original" and then "/
copy".
Thanks.
Just have the code to open the other form on the Print button on the Invoice form. Have all the Print code on a command button on the other form.
Oct 14 '07 #2

nico5038
Expert 2.5K+
P: 3,072
Trouble with triggering a report is the fact that the printer can jam...

Personally I've used a form print as an invoice order (no report), allowing me after the first buttonpress to show a messagebox is presented asking the print was OK. When that's the case the DatePrinted is filled.
All other copies will show "Copy" when that date is filled and only a special button will allow a new "Original".

Nic;o)
Oct 14 '07 #3

P: 38
Thanks guys.
The report works well - it needs the addition of the "copy" caption.
The thing is that the form I'm trying to connect is using 3 queries : del, add 0 + add 1 so when user writes how many copies, the 1's are the copy caption.

When I passed the printing procedure, the form didn't recognize this -
"strCriteria = "[invoice_no]= " & Me![INVOICE_NO]"
so I have to debug it all the time.
Can you assist please?
Oct 15 '07 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
You need to change your link criteria to ...

Expand|Select|Wrap|Line Numbers
  1. strCriteria = "[invoice_no]= " & Forms![MainFormName]![INVOICE_NO]
where MainFormName is the name of the Invoice form which must remain open in the background during this operation.
Oct 15 '07 #5

P: 38
Thanks' it works.

Hope it's ok for me to continue here as the report itself is only in copy header.
I'm using this code :

If Forms![FRM_COPIES]![COPY] = 0 Then (defines qry add 0)
Me.ORG_OR_COPY = "original"
Else
Me.ORG_OR_COPY = "copy" (for every copy the user states)
End If
End Sub

Appreciate any help here.
Oct 15 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.