J
JACK GUNAWAN via AccessMonster.com
Al,
Hi, I tried using your code but does not work, the printcount does
not
increase in increment and i followed your instructions. the code is in macro
but does not work, I am amatuer about programing. Thanks.
Jack
From the previous thread that reads:
I responded with a solution, (see 3/31 @ 1:34) so let's stay with this
problem...
Once we get each Order record to display how many times it has printed, we
can move on to
the "slow response" problem.
*Now let me restate my solution. This will be easier to implement, and may
also cure
the speed problem.
Your previous posts indicates to me that the Order form that you are
printing is
"open" during the report print.
If that's true... and it should be... then...
1. Add a new field to your main Orders table called PrintCount
(Numeric -
Integer - Default = 0)
2. Place that field on your main Order form. (ex. name = frmOrders)
and name it
PrintCount
3. On the OnClose event of your report run this code...
Forms!frmOrders!PrintCount = NZ(Forms!frmOrders!PrintCount) +
1
4. Every time the report prints, it will directly update the value of
that
specific OrderID record by 1.
Try that, and post back... If you have problems, please include all details,
and your
code.
Signature
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
[quoted text clipped - 4 lines]
Jack,
I really have to question why you are doing this. What difference would it
make if an
OrderID were printed once or 20 times?
Try adding a field to your Order table called PrintCount, and each time
that particular
report prints against that OrderID, increment it's PrintCount field by 1.
Use the same logic on your report as when you updated the seprate table you
created,
but... call out the tblOrders, AND the OrderID being reported on.
Signature
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
[quoted text clipped - 10 lines]
Hi, I tried using your code but does not work, the printcount does
not
increase in increment and i followed your instructions. the code is in macro
but does not work, I am amatuer about programing. Thanks.
Jack
From the previous thread that reads:
I responded with a solution, (see 3/31 @ 1:34) so let's stay with this
problem...
Once we get each Order record to display how many times it has printed, we
can move on to
the "slow response" problem.
*Now let me restate my solution. This will be easier to implement, and may
also cure
the speed problem.
Your previous posts indicates to me that the Order form that you are
printing is
"open" during the report print.
If that's true... and it should be... then...
1. Add a new field to your main Orders table called PrintCount
(Numeric -
Integer - Default = 0)
2. Place that field on your main Order form. (ex. name = frmOrders)
and name it
PrintCount
3. On the OnClose event of your report run this code...
Forms!frmOrders!PrintCount = NZ(Forms!frmOrders!PrintCount) +
1
4. Every time the report prints, it will directly update the value of
that
specific OrderID record by 1.
Try that, and post back... If you have problems, please include all details,
and your
code.
Signature
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
[quoted text clipped - 4 lines]
Reply to this message Al Camp - 03-31-2006 18:38
Jack,
I really have to question why you are doing this. What difference would it
make if an
OrderID were printed once or 20 times?
Try adding a field to your Order table called PrintCount, and each time
that particular
report prints against that OrderID, increment it's PrintCount field by 1.
Use the same logic on your report as when you updated the seprate table you
created,
but... call out the tblOrders, AND the OrderID being reported on.
Signature
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
[quoted text clipped - 10 lines]
Reply to this message JACK GUNAWAN - 04-10-2006 10:52