-----Original Message-----
Use the TOP option in your query. You can select the TOP 2 and ORDER BY
[YourAutonumberIDField] Desc.
--
Duane Hookom
MS Access MVP
You're right.
I have a primary key as an autonumber to specify the
last-in. So can it be done?
Thanks of
an autonumber or a
.
hello said:hello
If something happened, when I have entered new 3 records
or more than than at a time, then something should be
flexible to make it display on the screen of the print-out.
That is I would like to make it flexible if for new 3
records entered, then these 3 new records should be come
out with another last preceding ones.
Thanks
-----Original Message-----
Use the TOP option in your query. You can select the TOP 2 and ORDER BY
[YourAutonumberIDField] Desc.
--
Duane Hookom
MS Access MVP
You're right.
I have a primary key as an autonumber to specify the
last-in. So can it be done?
Thanks
-----Original Message-----
Once a record has been added to a table, there is no way
to determine if it
was the last added unless you are storing some value in
the table that can
be used to determine the last. This might be the value of
an autonumber or a
time stamp.
Do you have such a field?
--
Duane Hookom
MS Access MVP
--
message
sorry
There 's no particular record about to appear.
I'd like only to have it appear when there's an addding
new record into the table. When the new record is added
into the table, that new record is to be shown up in the
print-out , not all the others. No need of any sorting.
Only the "Last added up" and the "Previous" to be show
up.
Thanks
-----Original Message-----
There is no such thing as first or last record in a
table. A query might
have first and last records if you supply an ORDER BY.
Do
you have some
field to sort by? Are you particular about the order the
two records appear
in?
--
Duane Hookom
MS Access MVP
message
Hoo Hoo Hoo
Excuse me.
I just want the report to print out only the last
record
and the previous one from my selected table. So, the
report needed no to have on all the records.
Thanks
.
.
.
-----Original Message-----
I have absolutely no idea what you are asking for. Consider entering a few
records from your report's record source and then how you would expect them
to display.
--
Duane Hookom
MS Access MVP
wo :
Thanks alot.
The previous requirement was the success, Thanks.
But there is something new in the way to come out.
I'd like to have another requirement that is to make it
show as a distinct row.
For examples, the "textbox12", it shows all enumerated two
records : the one just added-up, and the one preceding it.
That's okey, but I 'd like to show as a distinct one that
is I would have another "textbox13" to show only the one
just added-up, and the "textbox12" to show only the one
preceding it. So the both of them can represent in
different places freely.
Thanks.
on-----Original Message-----
Define "at a time"? How does Access understand "at a time"?
Is this the extent of your requirements or do you plan
revealing them oneprint-at a time as the previous gets answered?
--
Duane Hookom
MS Access MVP
hello
If something happened, when I have entered new 3 records
or more than than at a time, then something should be
flexible to make it display on the screen of the
out.That is I would like to make it flexible if for new 3
records entered, then these 3 new records should be come
out with another last preceding ones.
Thanks
-----Original Message-----
Use the TOP option in your query. You can select the TOP
2 and ORDER BY
[YourAutonumberIDField] Desc.
--
Duane Hookom
MS Access MVP
message
You're right.
I have a primary key as an autonumber to specify the
last-in. So can it be done?
Thanks
-----Original Message-----
Once a record has been added to a table, there is no way
to determine if it
was the last added unless you are storing some value in
the table that can
be used to determine the last. This might be the value
of
an autonumber or a
time stamp.
Do you have such a field?
--
Duane Hookom
MS Access MVP
--
message
sorry
There 's no particular record about to appear.
I'd like only to have it appear when there's an
addding
new record into the table. When the new record is
added
into the table, that new record is to be shown up in
the
print-out , not all the others. No need of any
sorting.
Only the "Last added up" and the "Previous" to be show
up.
Thanks
-----Original Message-----
There is no such thing as first or last record in a
table. A query might
have first and last records if you supply an ORDER BY.
Do
you have some
field to sort by? Are you particular about the order
the
two records appear
in?
--
Duane Hookom
MS Access MVP
message
Hoo Hoo Hoo
Excuse me.
I just want the report to print out only the last
record
and the previous one from my selected table. So, the
report needed no to have on all the records.
Thanks
.
.
.
.
.
oh said:oh,
A Sample of the view on the print-out should like :
Placing texbox13 on the right top of the page here:
textbox13
And Placing textbox12 on the left bottom of the page here:
textbox12
For textbox13 I'd like to present only the last entered
record. And the textbox12 is only to present only the one
preceding it. Suppose there are 5 records so the last
autonumer field is "5" and the preceding it is "4". So I
like to have the textbox13 placed on top right of the page
to show only the record "5" (not including record "4").
There after, the texbox12 should come out only the
record "4" (not to include the record "5" as well).
Thanks
-----Original Message-----
I have absolutely no idea what you are asking for. Consider entering a few
records from your report's record source and then how you would expect them
to display.
--
Duane Hookom
MS Access MVP
wo :
Thanks alot.
The previous requirement was the success, Thanks.
But there is something new in the way to come out.
I'd like to have another requirement that is to make it
show as a distinct row.
For examples, the "textbox12", it shows all enumerated two
records : the one just added-up, and the one preceding it.
That's okey, but I 'd like to show as a distinct one that
is I would have another "textbox13" to show only the one
just added-up, and the "textbox12" to show only the one
preceding it. So the both of them can represent in
different places freely.
Thanks.
-----Original Message-----
Define "at a time"? How does Access understand "at a
time"?
Is this the extent of your requirements or do you plan on
revealing them one
at a time as the previous gets answered?
--
Duane Hookom
MS Access MVP
message
hello
If something happened, when I have entered new 3 records
or more than than at a time, then something should be
flexible to make it display on the screen of the print-
out.
That is I would like to make it flexible if for new 3
records entered, then these 3 new records should be come
out with another last preceding ones.
Thanks
-----Original Message-----
Use the TOP option in your query. You can select the TOP
2 and ORDER BY
[YourAutonumberIDField] Desc.
--
Duane Hookom
MS Access MVP
message
You're right.
I have a primary key as an autonumber to specify the
last-in. So can it be done?
Thanks
-----Original Message-----
Once a record has been added to a table, there is no
way
to determine if it
was the last added unless you are storing some value
in
the table that can
be used to determine the last. This might be the value
of
an autonumber or a
time stamp.
Do you have such a field?
--
Duane Hookom
MS Access MVP
--
message
sorry
There 's no particular record about to appear.
I'd like only to have it appear when there's an
addding
new record into the table. When the new record is
added
into the table, that new record is to be shown up in
the
print-out , not all the others. No need of any
sorting.
Only the "Last added up" and the "Previous" to be
show
up.
Thanks
-----Original Message-----
There is no such thing as first or last record in a
table. A query might
have first and last records if you supply an ORDER
BY.
Do
you have some
field to sort by? Are you particular about the order
the
two records appear
in?
--
Duane Hookom
MS Access MVP
message
Hoo Hoo Hoo
Excuse me.
I just want the report to print out only the last
record
and the previous one from my selected table. So,
the
report needed no to have on all the records.
Thanks
.
.
.
.
.
-----Original Message-----
You can use code in the on format event of the detail section to set the
position of the control to anywhere you want in the section. If you have two
records they will each use textbox12 which you can set the top and left
properties of the text box. If your detail section is about 1/2 page in
height, you can move your text box to appear in the top right and bottom
left of your page.
--
Duane Hookom
MS Access MVP
oh,
A Sample of the view on the print-out should like :
Placing texbox13 on the right top of the page here:
textbox13
And Placing textbox12 on the left bottom of the page here:
textbox12
For textbox13 I'd like to present only the last entered
record. And the textbox12 is only to present only the one
preceding it. Suppose there are 5 records so the last
autonumer field is "5" and the preceding it is "4". So I
like to have the textbox13 placed on top right of the page
to show only the record "5" (not including record "4").
There after, the texbox12 should come out only the
record "4" (not to include the record "5" as well).
Thanks
you-----Original Message-----
I have absolutely no idea what you are asking for. Consider entering a few
records from your report's record source and then how
would expect themwroteto display.
--
Duane Hookom
MS Access MVP
wo :
Thanks alot.
The previous requirement was the success, Thanks.
But there is something new in the way to come out.
I'd like to have another requirement that is to make it
show as a distinct row.
For examples, the "textbox12", it shows all enumerated two
records : the one just added-up, and the one preceding it.
That's okey, but I 'd like to show as a distinct one that
is I would have another "textbox13" to show only the one
just added-up, and the "textbox12" to show only the one
preceding it. So the both of them can represent in
different places freely.
Thanks.
-----Original Message-----
Define "at a time"? How does Access understand "at a
time"?
Is this the extent of your requirements or do you plan on
revealing them one
at a time as the previous gets answered?
--
Duane Hookom
MS Access MVP
message
hello
If something happened, when I have entered new 3 records
or more than than at a time, then something should be
flexible to make it display on the screen of the print-
out.
That is I would like to make it flexible if for new 3
records entered, then these 3 new records should be come
out with another last preceding ones.
Thanks
-----Original Message-----
Use the TOP option in your query. You can select the TOP
2 and ORDER BY
[YourAutonumberIDField] Desc.
--
Duane Hookom
MS Access MVP
message
You're right.
I have a primary key as an autonumber to specify the
last-in. So can it be done?
Thanks
-----Original Message-----
Once a record has been added to a table, there is no
way
to determine if it
was the last added unless you are storing some value
in
the table that can
be used to determine the last. This might be the value
of
an autonumber or a
time stamp.
Do you have such a field?
inupmessage
sorry
There 's no particular record about to appear.
I'd like only to have it appear when there's an
addding
new record into the table. When the new record is
added
into the table, that new record is to be shown
ininthe
print-out , not all the others. No need of any
sorting.
Only the "Last added up" and the "Previous" to be
show
up.
Thanks
-----Original Message-----
There is no such thing as first or last record
awrotetable. A query might
have first and last records if you supply an ORDER
BY.
Do
you have some
field to sort by? Are you particular about the order
the
two records appear
in?
--
Duane Hookom
MS Access MVP
"scu" <[email protected]>
inmessage
Hoo Hoo Hoo
Excuse me.
I just want the report to print out only the last
record
and the previous one from my selected table. So,
the
report needed no to have on all the records.
Thanks
.
.
.
.
.
.
oh rara said:oh, sorry
I can't see the picture from you.Thanks
-----Original Message-----
You can use code in the on format event of the detail section to set the
position of the control to anywhere you want in the section. If you have two
records they will each use textbox12 which you can set the top and left
properties of the text box. If your detail section is about 1/2 page in
height, you can move your text box to appear in the top right and bottom
left of your page.
--
Duane Hookom
MS Access MVP
oh,
A Sample of the view on the print-out should like :
Placing texbox13 on the right top of the page here:
textbox13
And Placing textbox12 on the left bottom of the page here:
textbox12
For textbox13 I'd like to present only the last entered
record. And the textbox12 is only to present only the one
preceding it. Suppose there are 5 records so the last
autonumer field is "5" and the preceding it is "4". So I
like to have the textbox13 placed on top right of the page
to show only the record "5" (not including record "4").
There after, the texbox12 should come out only the
record "4" (not to include the record "5" as well).
Thanks
-----Original Message-----
I have absolutely no idea what you are asking for.
Consider entering a few
records from your report's record source and then how you
would expect them
to display.
--
Duane Hookom
MS Access MVP
message
wo :
Thanks alot.
The previous requirement was the success, Thanks.
But there is something new in the way to come out.
I'd like to have another requirement that is to make it
show as a distinct row.
For examples, the "textbox12", it shows all enumerated
two
records : the one just added-up, and the one preceding
it.
That's okey, but I 'd like to show as a distinct one
that
is I would have another "textbox13" to show only the one
just added-up, and the "textbox12" to show only the one
preceding it. So the both of them can represent in
different places freely.
Thanks.
-----Original Message-----
Define "at a time"? How does Access understand "at a
time"?
Is this the extent of your requirements or do you plan
on
revealing them one
at a time as the previous gets answered?
--
Duane Hookom
MS Access MVP
message
hello
If something happened, when I have entered new 3
records
or more than than at a time, then something should be
flexible to make it display on the screen of the
print-
out.
That is I would like to make it flexible if for new 3
records entered, then these 3 new records should be
come
out with another last preceding ones.
Thanks
-----Original Message-----
Use the TOP option in your query. You can select the
TOP
2 and ORDER BY
[YourAutonumberIDField] Desc.
--
Duane Hookom
MS Access MVP
message
You're right.
I have a primary key as an autonumber to specify the
last-in. So can it be done?
Thanks
-----Original Message-----
Once a record has been added to a table, there is no
way
to determine if it
was the last added unless you are storing some value
in
the table that can
be used to determine the last. This might be the
value
of
an autonumber or a
time stamp.
Do you have such a field?
--
Duane Hookom
MS Access MVP
--
in
message
sorry
There 's no particular record about to appear.
I'd like only to have it appear when there's an
addding
new record into the table. When the new record is
added
into the table, that new record is to be shown up
in
the
print-out , not all the others. No need of any
sorting.
Only the "Last added up" and the "Previous" to be
show
up.
Thanks
-----Original Message-----
There is no such thing as first or last record in
a
table. A query might
have first and last records if you supply an ORDER
BY.
Do
you have some
field to sort by? Are you particular about the
order
the
two records appear
in?
--
Duane Hookom
MS Access MVP
in
message
Hoo Hoo Hoo
Excuse me.
I just want the report to print out only the
last
record
and the previous one from my selected table. So,
the
report needed no to have on all the records.
Thanks
.
.
.
.
.
.
-----Original Message-----
What "picture" do you expect to see? Are you asking me to write the code for
you?
--
Duane Hookom
MS Access MVP
--
oh, sorry
I can't see the picture from you.Thanks
new-----Original Message-----
You can use code in the on format event of the detail section to set the
position of the control to anywhere you want in the section. If you have two
records they will each use textbox12 which you can set the top and left
properties of the text box. If your detail section is about 1/2 page in
height, you can move your text box to appear in the top right and bottom
left of your page.
--
Duane Hookom
MS Access MVP
oh,
A Sample of the view on the print-out should like :
Placing texbox13 on the right top of the page here:
textbox13
And Placing textbox12 on the left bottom of the page here:
textbox12
For textbox13 I'd like to present only the last entered
record. And the textbox12 is only to present only the one
preceding it. Suppose there are 5 records so the last
autonumer field is "5" and the preceding it is "4". So I
like to have the textbox13 placed on top right of the page
to show only the record "5" (not including record "4").
There after, the texbox12 should come out only the
record "4" (not to include the record "5" as well).
Thanks
-----Original Message-----
I have absolutely no idea what you are asking for.
Consider entering a few
records from your report's record source and then how you
would expect them
to display.
--
Duane Hookom
MS Access MVP
message
wo :
Thanks alot.
The previous requirement was the success, Thanks.
But there is something new in the way to come out.
I'd like to have another requirement that is to make it
show as a distinct row.
For examples, the "textbox12", it shows all enumerated
two
records : the one just added-up, and the one preceding
it.
That's okey, but I 'd like to show as a distinct one
that
is I would have another "textbox13" to show only the one
just added-up, and the "textbox12" to show only the one
preceding it. So the both of them can represent in
different places freely.
Thanks.
-----Original Message-----
Define "at a time"? How does Access understand "at a
time"?
Is this the extent of your requirements or do you plan
on
revealing them one
at a time as the previous gets answered?
--
Duane Hookom
MS Access MVP
message
hello
If something happened, when I have entered new 3
records
or more than than at a time, then something should be
flexible to make it display on the screen of the
print-
out.
That is I would like to make it flexible if for
3isrecords entered, then these 3 new records should be
come
out with another last preceding ones.
Thanks
-----Original Message-----
Use the TOP option in your query. You can select the
TOP
2 and ORDER BY
[YourAutonumberIDField] Desc.
--
Duane Hookom
MS Access MVP
message
You're right.
I have a primary key as an autonumber to specify the
last-in. So can it be done?
Thanks
-----Original Message-----
Once a record has been added to a table, there
noway
to determine if it
was the last added unless you are storing some value
in
the table that can
be used to determine the last. This might be the
value
of
an autonumber or a
time stamp.
Do you have such a field?
--
Duane Hookom
MS Access MVP
--
in
message
sorry
There 's no particular record about to appear.
I'd like only to have it appear when there's an
addding
new record into the table. When the new record is
added
into the table, that new record is to be shown up
in
the
print-out , not all the others. No need of any
sorting.
Only the "Last added up" and the "Previous" to be
show
up.
Thanks
-----Original Message-----
There is no such thing as first or last record in
a
table. A query might
have first and last records if you supply an ORDER
BY.
Do
you have some
field to sort by? Are you particular about the
order
the
two records appear
in?
--
Duane Hookom
MS Access MVP
in
message
Hoo Hoo Hoo
Excuse me.
I just want the report to print out only the
last
record
and the previous one from my selected table. So,
the
report needed no to have on all the records.
Thanks
.
.
.
.
.
.
.
Daser said:Oh, oh oh
I 'd like to have the codes. Would you write the codes for
me?
Thanks.
-----Original Message-----
What "picture" do you expect to see? Are you asking me to write the code for
you?
--
Duane Hookom
MS Access MVP
--
oh, sorry
I can't see the picture from you.Thanks
-----Original Message-----
You can use code in the on format event of the detail
section to set the
position of the control to anywhere you want in the
section. If you have two
records they will each use textbox12 which you can set
the top and left
properties of the text box. If your detail section is
about 1/2 page in
height, you can move your text box to appear in the top
right and bottom
left of your page.
--
Duane Hookom
MS Access MVP
message
oh,
A Sample of the view on the print-out should like :
Placing texbox13 on the right top of the page here:
textbox13
And Placing textbox12 on the left bottom of the page
here:
textbox12
For textbox13 I'd like to present only the last entered
record. And the textbox12 is only to present only the
one
preceding it. Suppose there are 5 records so the last
autonumer field is "5" and the preceding it is "4". So I
like to have the textbox13 placed on top right of the
page
to show only the record "5" (not including record "4").
There after, the texbox12 should come out only the
record "4" (not to include the record "5" as well).
Thanks
-----Original Message-----
I have absolutely no idea what you are asking for.
Consider entering a few
records from your report's record source and then how
you
would expect them
to display.
--
Duane Hookom
MS Access MVP
message
wo :
Thanks alot.
The previous requirement was the success, Thanks.
But there is something new in the way to come out.
I'd like to have another requirement that is to make
it
show as a distinct row.
For examples, the "textbox12", it shows all enumerated
two
records : the one just added-up, and the one preceding
it.
That's okey, but I 'd like to show as a distinct one
that
is I would have another "textbox13" to show only the
one
just added-up, and the "textbox12" to show only the
one
preceding it. So the both of them can represent in
different places freely.
Thanks.
-----Original Message-----
Define "at a time"? How does Access understand "at a
time"?
Is this the extent of your requirements or do you plan
on
revealing them one
at a time as the previous gets answered?
--
Duane Hookom
MS Access MVP
message
hello
If something happened, when I have entered new 3
records
or more than than at a time, then something should
be
flexible to make it display on the screen of the
print-
out.
That is I would like to make it flexible if for new
3
records entered, then these 3 new records should be
come
out with another last preceding ones.
Thanks
-----Original Message-----
Use the TOP option in your query. You can select the
TOP
2 and ORDER BY
[YourAutonumberIDField] Desc.
--
Duane Hookom
MS Access MVP
message
You're right.
I have a primary key as an autonumber to specify
the
last-in. So can it be done?
Thanks
-----Original Message-----
Once a record has been added to a table, there is
no
way
to determine if it
was the last added unless you are storing some
value
in
the table that can
be used to determine the last. This might be the
value
of
an autonumber or a
time stamp.
Do you have such a field?
--
Duane Hookom
MS Access MVP
--
"oh oh" <[email protected]>
wrote
in
message
sorry
There 's no particular record about to appear.
I'd like only to have it appear when there's an
addding
new record into the table. When the new record
is
added
into the table, that new record is to be shown
up
in
the
print-out , not all the others. No need of any
sorting.
Only the "Last added up" and the "Previous" to
be
show
up.
Thanks
-----Original Message-----
There is no such thing as first or last record
in
a
table. A query might
have first and last records if you supply an
ORDER
BY.
Do
you have some
field to sort by? Are you particular about the
order
the
two records appear
in?
--
Duane Hookom
MS Access MVP
"scu" <[email protected]>
wrote
in
message
Hoo Hoo Hoo
Excuse me.
I just want the report to print out only the
last
record
and the previous one from my selected table.
So,
the
report needed no to have on all the records.
Thanks
.
.
.
.
.
.
.
-----Original Message-----
So, you have two records and one field that you want to display in a text
box where in the first record the text box is positioned at the top right of
the page and the second record has the text box positioned on the bottom
left of the same page.
Is this correct?
One more question: Why are you trying to accomplish with a report formatted
like this?
--
Duane Hookom
MS Access MVP
Oh, oh oh
I 'd like to have the codes. Would you write the codes for
me?
Thanks.
to-----Original Message-----
What "picture" do you expect to see? Are you asking me
write the code forwroteyou?
--
Duane Hookom
MS Access MVP
--
oh, sorry
I can't see the picture from you.Thanks
-----Original Message-----
You can use code in the on format event of the detail
section to set the
position of the control to anywhere you want in the
section. If you have two
records they will each use textbox12 which you can set
the top and left
properties of the text box. If your detail section is
about 1/2 page in
height, you can move your text box to appear in the top
right and bottom
left of your page.
--
Duane Hookom
MS Access MVP
message
oh,
A Sample of the view on the print-out should like :
Placing texbox13 on the right top of the page here:
textbox13
And Placing textbox12 on the left bottom of the page
here:
textbox12
For textbox13 I'd like to present only the last entered
record. And the textbox12 is only to present only the
one
preceding it. Suppose there are 5 records so the last
autonumer field is "5" and the preceding it is "4". So I
like to have the textbox13 placed on top right of the
page
to show only the record "5" (not including record "4").
There after, the texbox12 should come out only the
record "4" (not to include the record "5" as well).
Thanks
-----Original Message-----
I have absolutely no idea what you are asking for.
Consider entering a few
records from your report's record source and then how
you
would expect them
to display.
--
Duane Hookom
MS Access MVP
message
wo :
Thanks alot.
The previous requirement was the success, Thanks.
But there is something new in the way to come out.
I'd like to have another requirement that is to make
it
show as a distinct row.
For examples, the "textbox12", it shows all enumerated
two
records : the one just added-up, and the one preceding
it.
That's okey, but I 'd like to show as a distinct one
that
is I would have another "textbox13" to show only the
one
just added-up, and the "textbox12" to show only the
one
preceding it. So the both of them can represent in
different places freely.
Thanks.
-----Original Message-----
Define "at a time"? How does Access understand "at a
time"?
Is this the extent of your requirements or do you plan
on
revealing them one
at a time as the previous gets answered?
--
Duane Hookom
MS Access MVP
"hello" <[email protected]>
inwrotemessage
hello
If something happened, when I have entered new 3
records
or more than than at a time, then something should
be
flexible to make it display on the screen of the
print-
out.
That is I would like to make it flexible if for new
3
records entered, then these 3 new records should be
come
out with another last preceding ones.
Thanks
-----Original Message-----
Use the TOP option in your query. You can select the
TOP
2 and ORDER BY
[YourAutonumberIDField] Desc.
--
Duane Hookom
MS Access MVP
"fly" <[email protected]>
inmessage
You're right.
I have a primary key as an autonumber to specify
the
last-in. So can it be done?
Thanks
-----Original Message-----
Once a record has been added to a table, there is
no
way
to determine if it
was the last added unless you are storing some
value
in
the table that can
be used to determine the last. This might be the
value
of
an autonumber or a
time stamp.
Do you have such a field?
--
Duane Hookom
MS Access MVP
--
"oh oh" <[email protected]>
wrote
in
message
sorry
There 's no particular record about to appear.
I'd like only to have it appear when there's an
addding
new record into the table. When the new record
is
added
into the table, that new record is to be shown
up
in
the
print-out , not all the others. No need of any
sorting.
Only the "Last added up" and the "Previous" to
be
show
up.
Thanks
-----Original Message-----
There is no such thing as first or last record
in
a
table. A query might
have first and last records if you supply an
ORDER
BY.
Do
you have some
field to sort by? Are you particular about the
order
the
two records appear
in?
--
Duane Hookom
MS Access MVP
"scu" <[email protected]>
wrote
in
message
[email protected]...
Hoo Hoo Hoo
Excuse me.
I just want the report to print out only the
last
record
and the previous one from my selected table.
So,
the
report needed no to have on all the records.
Thanks
.
.
.
.
.
.
.
.
veeare said:veeare
Yes, because it was the position that was the matter. It
was the layout of the dates to be displayed in a different
position as to mention at different places. The last
actions to find out what was done the late time before the
the last actions taken place.
voowoo
-----Original Message-----
So, you have two records and one field that you want to display in a text
box where in the first record the text box is positioned at the top right of
the page and the second record has the text box positioned on the bottom
left of the same page.
Is this correct?
One more question: Why are you trying to accomplish with a report formatted
like this?
--
Duane Hookom
MS Access MVP
Oh, oh oh
I 'd like to have the codes. Would you write the codes for
me?
Thanks.
-----Original Message-----
What "picture" do you expect to see? Are you asking me to
write the code for
you?
--
Duane Hookom
MS Access MVP
--
message
oh, sorry
I can't see the picture from you.Thanks
-----Original Message-----
You can use code in the on format event of the detail
section to set the
position of the control to anywhere you want in the
section. If you have two
records they will each use textbox12 which you can set
the top and left
properties of the text box. If your detail section is
about 1/2 page in
height, you can move your text box to appear in the top
right and bottom
left of your page.
--
Duane Hookom
MS Access MVP
message
oh,
A Sample of the view on the print-out should like :
Placing texbox13 on the right top of the page here:
textbox13
And Placing textbox12 on the left bottom of the page
here:
textbox12
For textbox13 I'd like to present only the last
entered
record. And the textbox12 is only to present only the
one
preceding it. Suppose there are 5 records so the last
autonumer field is "5" and the preceding it is "4".
So I
like to have the textbox13 placed on top right of the
page
to show only the record "5" (not including
record "4").
There after, the texbox12 should come out only the
record "4" (not to include the record "5" as well).
Thanks
-----Original Message-----
I have absolutely no idea what you are asking for.
Consider entering a few
records from your report's record source and then how
you
would expect them
to display.
--
Duane Hookom
MS Access MVP
message
wo :
Thanks alot.
The previous requirement was the success, Thanks.
But there is something new in the way to come out.
I'd like to have another requirement that is to make
it
show as a distinct row.
For examples, the "textbox12", it shows all
enumerated
two
records : the one just added-up, and the one
preceding
it.
That's okey, but I 'd like to show as a distinct one
that
is I would have another "textbox13" to show only the
one
just added-up, and the "textbox12" to show only the
one
preceding it. So the both of them can represent in
different places freely.
Thanks.
-----Original Message-----
Define "at a time"? How does Access understand "at a
time"?
Is this the extent of your requirements or do you
plan
on
revealing them one
at a time as the previous gets answered?
--
Duane Hookom
MS Access MVP
in
message
hello
If something happened, when I have entered new 3
records
or more than than at a time, then something should
be
flexible to make it display on the screen of the
print-
out.
That is I would like to make it flexible if for
new
3
records entered, then these 3 new records should
be
come
out with another last preceding ones.
Thanks
-----Original Message-----
Use the TOP option in your query. You can select
the
TOP
2 and ORDER BY
[YourAutonumberIDField] Desc.
--
Duane Hookom
MS Access MVP
in
message
You're right.
I have a primary key as an autonumber to specify
the
last-in. So can it be done?
Thanks
-----Original Message-----
Once a record has been added to a table, there
is
no
way
to determine if it
was the last added unless you are storing some
value
in
the table that can
be used to determine the last. This might be the
value
of
an autonumber or a
time stamp.
Do you have such a field?
--
Duane Hookom
MS Access MVP
--
"oh oh" <[email protected]>
wrote
in
message
sorry
There 's no particular record about to appear.
I'd like only to have it appear when there's
an
addding
new record into the table. When the new record
is
added
into the table, that new record is to be shown
up
in
the
print-out , not all the others. No need of any
sorting.
Only the "Last added up" and the "Previous" to
be
show
up.
Thanks
-----Original Message-----
There is no such thing as first or last record
in
a
table. A query might
have first and last records if you supply an
ORDER
BY.
Do
you have some
field to sort by? Are you particular about the
order
the
two records appear
in?
--
Duane Hookom
MS Access MVP
"scu" <[email protected]>
wrote
in
message
[email protected]...
Hoo Hoo Hoo
Excuse me.
I just want the report to print out only the
last
record
and the previous one from my selected table.
So,
the
report needed no to have on all the records.
Thanks
.
.
.
.
.
.
.
.
-----Original Message-----
Assuming a detail section of a height that produces two records per printed
page and a text box named txtCategoryName (switch to yours). Add a text box
to detail section:
Name: txtCount
Control Source: =1
Running Sum: Over All
Visible: No
Add code to the On Format event of the detail section:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.txtCount Mod 2 = 1 Then
'assuming the page is about 6.5" wide
Me.txtCategoryName.Left = 6000
Me.txtCategoryName.Top = 0
Else
Me.txtCategoryName.Left = 0
Me.txtCategoryName.Top = Me.Detail.Height - 300
End If
End Sub
If you reply, please try to standardize on a name and signature. When I
don't understand why I am coding a solution for someone I don't know, at
least I should be assured someone isn't yanking my chain.
--
Duane Hookom
MS Access MVP
--
veeare
Yes, because it was the position that was the matter. It
was the layout of the dates to be displayed in a different
position as to mention at different places. The last
actions to find out what was done the late time before the
the last actions taken place.
voowoo
-----Original Message-----
So, you have two records and one field that you want to display in a text
box where in the first record the text box is positioned at the top right of
the page and the second record has the text box positioned on the bottom
left of the same page.
Is this correct?
One more question: Why are you trying to accomplish with a report formatted
like this?
--
Duane Hookom
MS Access MVP
Oh, oh oh
I 'd like to have the codes. Would you write the codes for
me?
Thanks.
-----Original Message-----
What "picture" do you expect to see? Are you asking me to
write the code for
you?
--
Duane Hookom
MS Access MVP
--
message
oh, sorry
I can't see the picture from you.Thanks
-----Original Message-----
You can use code in the on format event of the detail
section to set the
position of the control to anywhere you want in the
section. If you have two
records they will each use textbox12 which you can set
the top and left
properties of the text box. If your detail section is
about 1/2 page in
height, you can move your text box to appear in the top
right and bottom
left of your page.
--
Duane Hookom
MS Access MVP
message
oh,
A Sample of the view on the print-out should like :
Placing texbox13 on the right top of the page here:
textbox13
And Placing textbox12 on the left bottom of the page
here:
textbox12
For textbox13 I'd like to present only the last
entered
record. And the textbox12 is only to present only the
one
preceding it. Suppose there are 5 records so the last
autonumer field is "5" and the preceding it is "4".
So I
like to have the textbox13 placed on top right of the
page
to show only the record "5" (not including
record "4").
There after, the texbox12 should come out only the
record "4" (not to include the record "5" as well).
Thanks
-----Original Message-----
I have absolutely no idea what you are asking for.
Consider entering a few
records from your report's record source and then how
you
would expect them
to display.
--
Duane Hookom
MS Access MVP
message
wo :
Thanks alot.
The previous requirement was the success, Thanks.
But there is something new in the way to come out.
I'd like to have another requirement that is to make
it
show as a distinct row.
For examples, the "textbox12", it shows all
enumerated
two
records : the one just added-up, and the one
preceding
it.
That's okey, but I 'd like to show as a distinct one
that
is I would have another "textbox13" to show only the
one
just added-up, and the "textbox12" to show only the
one
preceding it. So the both of them can represent in
different places freely.
Thanks.
-----Original Message-----
Define "at a time"? How does Access understand "at a
time"?
Is this the extent of your requirements or do you
plan
on
revealing them one
at a time as the previous gets answered?
--
Duane Hookom
MS Access MVP
in
message
hello
If something happened, when I have entered new 3
records
or more than than at a time, then something should
be
flexible to make it display on the screen of the
print-
out.
That is I would like to make it flexible if for
new
3
records entered, then these 3 new records should
be
come
out with another last preceding ones.
Thanks
-----Original Message-----
Use the TOP option in your query. You can select
the
TOP
2 and ORDER BY
[YourAutonumberIDField] Desc.
--
Duane Hookom
MS Access MVP
in
message
You're right.
I have a primary key as an autonumber to specify
the
last-in. So can it be done?
Thanks
-----Original Message-----
Once a record has been added to a table, there
is
no
way
to determine if it
was the last added unless you are storing some
value
in
the table that can
be used to determine the last. This might be the
value
of
an autonumber or a
time stamp.
Do you have such a field?the "Previous"wrote
in
message
[email protected]...
sorry
There 's no particular record about to appear.
I'd like only to have it appear when there's
an
addding
new record into the table. When the new record
is
added
into the table, that new record is to be shown
up
in
the
print-out , not all the others. No need of any
sorting.
Only the "Last added up" and
tobe
show
up.
Thanks
-----Original Message-----
There is no such thing as first or last record
in
a
table. A query might
have first and last records if you supply an
ORDER
BY.
Do
you have some
field to sort by? Are you particular about the
order
the
two records appear
in?
--
Duane Hookom
MS Access MVP
"scu"wrote
in
message
[email protected]...
Hoo Hoo Hoo
Excuse me.
I just want the report to print out only the
last
record
and the previous one from my selected table.
So,
the
report needed no to have on all the records.
Thanks
.
.
.
.
.
.
.
.
.
Thanks it's work! Great Duane HOOkom said:I love you.
You pretty!-----Original Message-----
Assuming a detail section of a height that produces two records per printed
page and a text box named txtCategoryName (switch to yours). Add a text box
to detail section:
Name: txtCount
Control Source: =1
Running Sum: Over All
Visible: No
Add code to the On Format event of the detail section:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.txtCount Mod 2 = 1 Then
'assuming the page is about 6.5" wide
Me.txtCategoryName.Left = 6000
Me.txtCategoryName.Top = 0
Else
Me.txtCategoryName.Left = 0
Me.txtCategoryName.Top = Me.Detail.Height - 300
End If
End Sub
If you reply, please try to standardize on a name and signature. When I
don't understand why I am coding a solution for someone I don't know, at
least I should be assured someone isn't yanking my chain.
--
Duane Hookom
MS Access MVP
--
veeare
Yes, because it was the position that was the matter. It
was the layout of the dates to be displayed in a different
position as to mention at different places. The last
actions to find out what was done the late time before the
the last actions taken place.
voowoo
-----Original Message-----
So, you have two records and one field that you want to
display in a text
box where in the first record the text box is positioned
at the top right of
the page and the second record has the text box
positioned on the bottom
left of the same page.
Is this correct?
One more question: Why are you trying to accomplish with
a report formatted
like this?
--
Duane Hookom
MS Access MVP
message
Oh, oh oh
I 'd like to have the codes. Would you write the codes
for
me?
Thanks.
-----Original Message-----
What "picture" do you expect to see? Are you asking me
to
write the code for
you?
--
Duane Hookom
MS Access MVP
--
message
oh, sorry
I can't see the picture from you.Thanks
-----Original Message-----
You can use code in the on format event of the detail
section to set the
position of the control to anywhere you want in the
section. If you have two
records they will each use textbox12 which you can set
the top and left
properties of the text box. If your detail section is
about 1/2 page in
height, you can move your text box to appear in the
top
right and bottom
left of your page.
--
Duane Hookom
MS Access MVP
message
oh,
A Sample of the view on the print-out should like :
Placing texbox13 on the right top of the page
here:
textbox13
And Placing textbox12 on the left bottom of the page
here:
textbox12
For textbox13 I'd like to present only the last
entered
record. And the textbox12 is only to present only
the
one
preceding it. Suppose there are 5 records so the
last
autonumer field is "5" and the preceding it is "4".
So I
like to have the textbox13 placed on top right of
the
page
to show only the record "5" (not including
record "4").
There after, the texbox12 should come out only the
record "4" (not to include the record "5" as well).
Thanks
-----Original Message-----
I have absolutely no idea what you are asking for.
Consider entering a few
records from your report's record source and then
how
you
would expect them
to display.
--
Duane Hookom
MS Access MVP
message
wo :
Thanks alot.
The previous requirement was the success, Thanks.
But there is something new in the way to come out.
I'd like to have another requirement that is to
make
it
show as a distinct row.
For examples, the "textbox12", it shows all
enumerated
two
records : the one just added-up, and the one
preceding
it.
That's okey, but I 'd like to show as a distinct
one
that
is I would have another "textbox13" to show only
the
one
just added-up, and the "textbox12" to show only
the
one
preceding it. So the both of them can represent
in
different places freely.
Thanks.
-----Original Message-----
Define "at a time"? How does Access
understand "at a
time"?
Is this the extent of your requirements or do you
plan
on
revealing them one
at a time as the previous gets answered?
--
Duane Hookom
MS Access MVP
"hello" <[email protected]>
wrote
in
message
hello
If something happened, when I have entered new 3
records
or more than than at a time, then something
should
be
flexible to make it display on the screen of the
print-
out.
That is I would like to make it flexible if for
new
3
records entered, then these 3 new records should
be
come
out with another last preceding ones.
Thanks
-----Original Message-----
Use the TOP option in your query. You can select
the
TOP
2 and ORDER BY
[YourAutonumberIDField] Desc.
--
Duane Hookom
MS Access MVP
"fly" <[email protected]>
wrote
in
message
You're right.
I have a primary key as an autonumber to
specify
the
last-in. So can it be done?
Thanks
-----Original Message-----
Once a record has been added to a table, there
is
no
way
to determine if it
was the last added unless you are storing some
value
in
the table that can
be used to determine the last. This might be
the
value
of
an autonumber or a
time stamp.
Do you have such a field?wrote
in
message
[email protected]...
sorry
There 's no particular record about to
appear.
I'd like only to have it appear when there's
an
addding
new record into the table. When the new
record
is
added
into the table, that new record is to be
shown
up
in
the
print-out , not all the others. No need of
any
sorting.
Only the "Last added up" and the "Previous"
to
be
show
up.
Thanks
-----Original Message-----
There is no such thing as first or last
record
in
a
table. A query might
have first and last records if you supply an
ORDER
BY.
Do
you have some
field to sort by? Are you particular about
the
order
the
two records appear
in?
--
Duane Hookom
MS Access MVP
"scu"wrote
in
message
[email protected]...
Hoo Hoo Hoo
Excuse me.
I just want the report to print out only
the
last
record
and the previous one from my selected
table.
So,
the
report needed no to have on all the
records.
Thanks
.
.
.
.
.
.
.
.
.
Duane said:Awww come on, don't say things like that. The other MVPs might read this and
pick on me. I will probably never hear the end of it!