One last record and one previous.

[scu]

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 Hookom]

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?

 

[oh oh]

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

 

[Duane Hookom]

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?

 

[fly]

You're right.

I have a primary key as an autonumber to specify the
last-in. So can it be done?
Thanks

 

[Duane Hookom]

Use the TOP option in your query. You can select the TOP 2 and ORDER BY
[YourAutonumberIDField] Desc.

 

[hello]

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 of
an autonumber or a

.

 

[Duane Hookom]

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
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


.



.

.

 

[oh]

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


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


.



.



.



.

.

 

[Duane Hookom]

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

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


.



.



.



.

.

 

[oh rara]

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


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?

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


.



.



.



.



.

.

 

[Duane Hookom]

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

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


.



.



.



.



.

.

 

[Daser]

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


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


.



.



.



.



.



.

.

 

[Duane Hookom]

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
--

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


.



.



.



.



.



.

.

 

[veeare]

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
--

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?

--
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


.



.



.



.



.



.



.

.

 

[Duane Hookom]

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?

--
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


.



.



.



.



.



.



.

.

 

[Thanks it's work! Great Duane HOOkom]

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


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?

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 Hookom]

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!

--
Duane Hookom
MS Access MVP

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


.



.



.



.



.



.



.



.

.

 

[Marshall Barton]

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!

Well, Duane, this kinda looks like a babblefish thingy, so I
think we should just let it slide . . . this time ;-)

Besides, I've seen you in person and know that "pretty"
doesn't really apply <gdr>

 

[Duane Hookom]

Back from a little time away and you are already picking on me!

It's a darn good thing our kids and grandkids look more like their mothers
and grandmothers!