S
Sham Yemul
Hello,
I am sorry this is re-post, last time I had wrong system date/time of my PC.
I got a report related to Patient History, we are not sure how much data
will be feed-in each times hence not sure about lines and pages. So we are
giving can grow true and looping through all fields to form a string that is
used as control source of control on a report.
My problem is I want to keep track of what was the last line no. printed by
access report so that the paper of same patient is inserted I will skip that
many lines(n lines) to continue the next time printing.
For example say For patient ABC I printed two pages and 5 lines on third
page. Now I want to use the third page when patient comes in for next visit.
So Next time I want to skip 5 lines and start printing. There is no problem
for skip line logic, I could implement it, but I am not getting how to
record 5th Line for last printing becuase there is no way to record or know
what was the last line or location of last line printed by Access Report.
Additional Information : Some fields have multi-line description so the
counting of new lines in the code may not be useful since access itself does
formating for multi-line. So my problem became more complicated.
Is there anyway to know how access formats for printing say I give input
string, Can I know how many lines access will print for this amount of data,
since character counting may not be feasible, I am searching for alternative
method.
This problem is similar to printing of Bank Pass Books, but in case of
Passbooks the lines are easily determinded by no. of records.
If you are not clear let me know, I will explain more.
Thanks in Advance.
Other Details :
OS : Win98
Database/Platform : Access2000
Printer : HP 695CCI/Epson LX300
Regards
[Sham Shrinivas Yemul]
I am sorry this is re-post, last time I had wrong system date/time of my PC.
I got a report related to Patient History, we are not sure how much data
will be feed-in each times hence not sure about lines and pages. So we are
giving can grow true and looping through all fields to form a string that is
used as control source of control on a report.
My problem is I want to keep track of what was the last line no. printed by
access report so that the paper of same patient is inserted I will skip that
many lines(n lines) to continue the next time printing.
For example say For patient ABC I printed two pages and 5 lines on third
page. Now I want to use the third page when patient comes in for next visit.
So Next time I want to skip 5 lines and start printing. There is no problem
for skip line logic, I could implement it, but I am not getting how to
record 5th Line for last printing becuase there is no way to record or know
what was the last line or location of last line printed by Access Report.
Additional Information : Some fields have multi-line description so the
counting of new lines in the code may not be useful since access itself does
formating for multi-line. So my problem became more complicated.
Is there anyway to know how access formats for printing say I give input
string, Can I know how many lines access will print for this amount of data,
since character counting may not be feasible, I am searching for alternative
method.
This problem is similar to printing of Bank Pass Books, but in case of
Passbooks the lines are easily determinded by no. of records.
If you are not clear let me know, I will explain more.
Thanks in Advance.
Other Details :
OS : Win98
Database/Platform : Access2000
Printer : HP 695CCI/Epson LX300
Regards
[Sham Shrinivas Yemul]