09 August 2004, Access 2000, Reports, How to know last line no. printed by Access Report

[Van T. Dinh]

Potential repondents probably wait until you post with the correct date/time
of posting.

 

[Sham Yemul]

Hello,

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]

 

[Douglas J. Steele]

Your system date may be correct, but is your timezone? (Control Panel -->
Date/Time)

I don't know what time you posted, but right now it's 07:57 where I am
(Eastern time zone), and your post says it was posted at 10:55. Perhaps you
forgot to change it from the default Pacific Time.


--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

Hello,

I am sorry, I could not get you, I got a habit of writing day month and year
format time string in subject are you objecting for that ?
I checked my system date its perfect.

Regards
[Sham]

Potential repondents probably wait until you post with the correct date/time
of posting.

--
HTH
Van T. Dinh
MVP (Access)

Hello,

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]

 

[Sham Yemul]

Hello,

I am sorry, I could not get you, I got a habit of writing day month and year
format time string in subject are you objecting for that ?
I checked my system date its perfect.

Regards
[Sham]

Potential repondents probably wait until you post with the correct date/time
of posting.

--
HTH
Van T. Dinh
MVP (Access)

Hello,

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]

 

[Van T. Dinh]

If you look at your original message, you posted about 6.5 hours AFTER I
replied to your message.

--
HTH
Van T. Dinh
MVP (Access)

Hello,

I am sorry, I could not get you, I got a habit of writing day month and year
format time string in subject are you objecting for that ?
I checked my system date its perfect.

Regards
[Sham]

Potential repondents probably wait until you post with the correct date/time
of posting.

--
HTH
Van T. Dinh
MVP (Access)

Hello,

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]

 

[Sham Yemul]

Hello ,

I appologize for the mistake, How it happened I don't know, but I found I
set a wrong Time Zone, My place is India(Bombay, Culcultta..). Probably we
tried a new software that is related to Time Zone.

Once again sorry for the mis-understanding and thanks for updating.

I will try re-posting now.

Regards
[Sham Shrinivas Yemul]

Your system date may be correct, but is your timezone? (Control Panel -->
Date/Time)

I don't know what time you posted, but right now it's 07:57 where I am
(Eastern time zone), and your post says it was posted at 10:55. Perhaps you
forgot to change it from the default Pacific Time.


--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

Hello,

I am sorry, I could not get you, I got a habit of writing day month and year
format time string in subject are you objecting for that ?
I checked my system date its perfect.

Regards
[Sham]

Potential repondents probably wait until you post with the correct date/time
of posting.

--
HTH
Van T. Dinh
MVP (Access)



Hello,

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]

 

[Douglas J. Steele]

If my theory is correct, and his machine is on Pacific time (courtesy of
Microsoft being located in Seattle), it probably has something to do with
the fact that the International Date Line is between Seattle and your home,
Van.

I must confess, though, that I can never remember how to adjust times in my
head, other than knowing that it must be time for a beer somewhere in the
world right now! <g>

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

If you look at your original message, you posted about 6.5 hours AFTER I
replied to your message.

--
HTH
Van T. Dinh
MVP (Access)

Hello,

I am sorry, I could not get you, I got a habit of writing day month and year
format time string in subject are you objecting for that ?
I checked my system date its perfect.

Regards
[Sham]

Potential repondents probably wait until you post with the correct date/time
of posting.

--
HTH
Van T. Dinh
MVP (Access)



Hello,

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]