2910 line of info

[pgarcia]

Hello all,
I hope I can express what I need correctly as I am a novas to Access.
I have around 2910 lines of data. The data is blocks of invoices for that
day. The invoice number do not repeat, however, the account name, address etc
do repeated. I need to create a form that will allow me or my user to print
out statement invoice for that day. The header would be the account name,
address and account number. The detail would only pick up line items with the
same account number on that page (or if it runs long, 2-3+ pages.
E.g. Company A has 5 invoices, company B has 12 and company C has 2. So I
would need only three invoice statements printed, but they should have all
the data of the invoice (Origin, Destination, Reference No (1, 2, 3), Invoice
number, date and amount.
I have created a form but it does not separate the accounts, it runs
together. The header does change but the page contains information from the
next account or previous account.

Thanks

 

[Damon Heron]

Forms are not for printing, Reports are. Try designing a report with a
query for your record source.

Damon

 

[pgarcia]

Sorry for the ignorance, but how do you create a report that does that? I
have created a report, but there is no separation for one company to the
next.
Are there any websites that could give me examples? I know for Excel there
are loads of them and they work out nicely.

Thanks for any help you can give me.

 

[pgarcia]

Ok, I read the form a little and this is what I found. I grouped the account
number and for the first 4 page it did what I need. However, on the 5th page
it list 3 accounts but keep the infomation of the first account number. Is
there a function I need to check off or a VB code I can use to separate the
pages?

 

[BruceM]

There is a Force New Page property for the group header and footer. Try
forcing a new page before the group header, or after the group footer if you
have one.

 

[pgarcia]

Thanks, I did find that, but it's just puting 1 line in infomation on the
page. Could it be my grouping? I'm grouping by acct#.

 

[pgarcia]

I got it! I looked at the grouping again and did not see the first time
around the Group Header option. I say "yes" to that and then did the Force
New Page and the did it.

Ok, so, how do you sum the amounts on the last page? Like I said, I a big
time novis when it comes to Access.

 

[BruceM]

OK, you found the group headers and footers. I forgot to mention that.

I don't know what exactly you need to sum, but if it is a field in the
record you can put the following in an unbound text box in the *form*
footer:

=Sum([YourField])

You can do the same in the group footer to get a sum for the group.

If you are looking for the sum of the total per record you need the whole
expression in the text box in the footer. For instance, you may have this
in each record:
=[Qty]*[Price]

In the footer you need:

=Sum([Qty]*[Price])

 

[pgarcia]

Cool. I used the unbound text and placed it in the group foot.
Thanks

While I got you here, do you have an expression for page numbers? I inserted
page numbers in the page footer and it gives me 1-490 pages. I moved it to
the group footer but it did not change. Do you have any ideas?

OK, you found the group headers and footers. I forgot to mention that.

I don't know what exactly you need to sum, but if it is a field in the
record you can put the following in an unbound text box in the *form*
footer:

=Sum([YourField])

You can do the same in the group footer to get a sum for the group.

If you are looking for the sum of the total per record you need the whole
expression in the text box in the footer. For instance, you may have this
in each record:
=[Qty]*[Price]

In the footer you need:

=Sum([Qty]*[Price])

I got it! I looked at the grouping again and did not see the first time
around the Group Header option. I say "yes" to that and then did the Force
New Page and the did it.

Ok, so, how do you sum the amounts on the last page? Like I said, I a big
time novis when it comes to Access.

 

[BruceM]

If you want to number starting from one for each group of records you will
need to do something like shown here:
http://www.mvps.org/access/reports/rpt0013.htm

Cool. I used the unbound text and placed it in the group foot.
Thanks

While I got you here, do you have an expression for page numbers? I
inserted
page numbers in the page footer and it gives me 1-490 pages. I moved it to
the group footer but it did not change. Do you have any ideas?

OK, you found the group headers and footers. I forgot to mention that.

I don't know what exactly you need to sum, but if it is a field in the
record you can put the following in an unbound text box in the *form*
footer:

=Sum([YourField])

You can do the same in the group footer to get a sum for the group.

If you are looking for the sum of the total per record you need the whole
expression in the text box in the footer. For instance, you may have
this
in each record:
=[Qty]*[Price]

In the footer you need:

=Sum([Qty]*[Price])

I got it! I looked at the grouping again and did not see the first time
around the Group Header option. I say "yes" to that and then did the
Force
New Page and the did it.

Ok, so, how do you sum the amounts on the last page? Like I said, I a
big
time novis when it comes to Access.
:

There is a Force New Page property for the group header and footer.
Try
forcing a new page before the group header, or after the group footer
if
you
have one.

Ok, I read the form a little and this is what I found. I grouped the
account
number and for the first 4 page it did what I need. However, on the
5th
page
it list 3 accounts but keep the infomation of the first account
number.
Is
there a function I need to check off or a VB code I can use to
separate
the
pages?

:

Forms are not for printing, Reports are. Try designing a report
with
a
query for your record source.

Damon

Hello all,
I hope I can express what I need correctly as I am a novas to
Access.
I have around 2910 lines of data. The data is blocks of invoices
for
that
day. The invoice number do not repeat, however, the account name,
address
etc
do repeated. I need to create a form that will allow me or my
user
to
print
out statement invoice for that day. The header would be the
account
name,
address and account number. The detail would only pick up line
items
with
the
same account number on that page (or if it runs long, 2-3+ pages.
E.g. Company A has 5 invoices, company B has 12 and company C has
2.
So
I
would need only three invoice statements printed, but they should
have
all
the data of the invoice (Origin, Destination, Reference No (1, 2,
3),
Invoice
number, date and amount.
I have created a form but it does not separate the accounts, it
runs
together. The header does change but the page contains
information
from
the
next account or previous account.

Thanks

 

[pgarcia]

Cool. That all most works for me. Have you used this before? Where is the
Code-Behind-Reports module? Or does he just mean a module? I typed to put
Me!ctlGrpPages in the page footer in a text box unbond, but it keeps asking
me for a parameter then it tell me it can not find Me!ctlGrpPages referred in
your expression.

Thanks!

If you want to number starting from one for each group of records you will
need to do something like shown here:
http://www.mvps.org/access/reports/rpt0013.htm

Cool. I used the unbound text and placed it in the group foot.
Thanks

While I got you here, do you have an expression for page numbers? I
inserted
page numbers in the page footer and it gives me 1-490 pages. I moved it to
the group footer but it did not change. Do you have any ideas?

OK, you found the group headers and footers. I forgot to mention that.

I don't know what exactly you need to sum, but if it is a field in the
record you can put the following in an unbound text box in the *form*
footer:

=Sum([YourField])

You can do the same in the group footer to get a sum for the group.

If you are looking for the sum of the total per record you need the whole
expression in the text box in the footer. For instance, you may have
this
in each record:
=[Qty]*[Price]

In the footer you need:

=Sum([Qty]*[Price])


I got it! I looked at the grouping again and did not see the first time
around the Group Header option. I say "yes" to that and then did the
Force
New Page and the did it.

Ok, so, how do you sum the amounts on the last page? Like I said, I a
big
time novis when it comes to Access.
:

There is a Force New Page property for the group header and footer.
Try
forcing a new page before the group header, or after the group footer
if
you
have one.

Ok, I read the form a little and this is what I found. I grouped the
account
number and for the first 4 page it did what I need. However, on the
5th
page
it list 3 accounts but keep the infomation of the first account
number.
Is
there a function I need to check off or a VB code I can use to
separate
the
pages?

:

Forms are not for printing, Reports are. Try designing a report
with
a
query for your record source.

Damon

Hello all,
I hope I can express what I need correctly as I am a novas to
Access.
I have around 2910 lines of data. The data is blocks of invoices
for
that
day. The invoice number do not repeat, however, the account name,
address
etc
do repeated. I need to create a form that will allow me or my
user
to
print
out statement invoice for that day. The header would be the
account
name,
address and account number. The detail would only pick up line
items
with
the
same account number on that page (or if it runs long, 2-3+ pages.
E.g. Company A has 5 invoices, company B has 12 and company C has
2.
So
I
would need only three invoice statements printed, but they should
have
all
the data of the invoice (Origin, Destination, Reference No (1, 2,
3),
Invoice
number, date and amount.
I have created a form but it does not separate the accounts, it
runs
together. The header does change but the page contains
information
from
the
next account or previous account.

Thanks

 

[BruceM]

I have used this before, but do not necessarily recall the details. The
Code-Behind-Reports module is the report's code module.

Be sure to follow the instructions carefully. Note in particular that you
need to change Me!Salesperson in the code to the control bound to the field
on which you are grouping.

ctlGrpPages is the name of an unbound text box in the page footer. You can
give it another name as long as you change the name in the code to
correspond. Do not place a value in its Control Source. It is blank until
the code populates it.

Note too that the code goes in the Page Footer Format event. Be sure
PageFooter is named exactly as it is in the code. If it is not you can
change either the code or the name of the footer.

Cool. That all most works for me. Have you used this before? Where is the
Code-Behind-Reports module? Or does he just mean a module? I typed to put
Me!ctlGrpPages in the page footer in a text box unbond, but it keeps
asking
me for a parameter then it tell me it can not find Me!ctlGrpPages referred
in
your expression.

Thanks!

If you want to number starting from one for each group of records you
will
need to do something like shown here:
http://www.mvps.org/access/reports/rpt0013.htm

Cool. I used the unbound text and placed it in the group foot.
Thanks

While I got you here, do you have an expression for page numbers? I
inserted
page numbers in the page footer and it gives me 1-490 pages. I moved it
to
the group footer but it did not change. Do you have any ideas?

:

OK, you found the group headers and footers. I forgot to mention
that.

I don't know what exactly you need to sum, but if it is a field in the
record you can put the following in an unbound text box in the *form*
footer:

=Sum([YourField])

You can do the same in the group footer to get a sum for the group.

If you are looking for the sum of the total per record you need the
whole
expression in the text box in the footer. For instance, you may have
this
in each record:
=[Qty]*[Price]

In the footer you need:

=Sum([Qty]*[Price])


I got it! I looked at the grouping again and did not see the first
time
around the Group Header option. I say "yes" to that and then did the
Force
New Page and the did it.

Ok, so, how do you sum the amounts on the last page? Like I said, I
a
big
time novis when it comes to Access.
:

There is a Force New Page property for the group header and footer.
Try
forcing a new page before the group header, or after the group
footer
if
you
have one.

Ok, I read the form a little and this is what I found. I grouped
the
account
number and for the first 4 page it did what I need. However, on
the
5th
page
it list 3 accounts but keep the infomation of the first account
number.
Is
there a function I need to check off or a VB code I can use to
separate
the
pages?

:

Forms are not for printing, Reports are. Try designing a report
with
a
query for your record source.

Damon

Hello all,
I hope I can express what I need correctly as I am a novas to
Access.
I have around 2910 lines of data. The data is blocks of
invoices
for
that
day. The invoice number do not repeat, however, the account
name,
address
etc
do repeated. I need to create a form that will allow me or my
user
to
print
out statement invoice for that day. The header would be the
account
name,
address and account number. The detail would only pick up line
items
with
the
same account number on that page (or if it runs long, 2-3+
pages.
E.g. Company A has 5 invoices, company B has 12 and company C
has
2.
So
I
would need only three invoice statements printed, but they
should
have
all
the data of the invoice (Origin, Destination, Reference No (1,
2,
3),
Invoice
number, date and amount.
I have created a form but it does not separate the accounts,
it
runs
together. The header does change but the page contains
information
from
the
next account or previous account.

Thanks

 

[pgarcia]

Sorry, I guess I just don't understand. I going to leave this for another
day. Just to let you know, this is what I did:

1) Open a new module and put the code in. Changed Me!Salesperson to Me!AcctNo
2) Went to propertys of Page Footer and in Events tab under format I put
Me!ctlGrpPages
3) I put a unbond text box in the Page Footer secetion with and without
Me!ctlGrpPages in the name. I also left it blank.

Thanks for all your help.

I have used this before, but do not necessarily recall the details. The
Code-Behind-Reports module is the report's code module.

Be sure to follow the instructions carefully. Note in particular that you
need to change Me!Salesperson in the code to the control bound to the field
on which you are grouping.

ctlGrpPages is the name of an unbound text box in the page footer. You can
give it another name as long as you change the name in the code to
correspond. Do not place a value in its Control Source. It is blank until
the code populates it.

Note too that the code goes in the Page Footer Format event. Be sure
PageFooter is named exactly as it is in the code. If it is not you can
change either the code or the name of the footer.

Cool. That all most works for me. Have you used this before? Where is the
Code-Behind-Reports module? Or does he just mean a module? I typed to put
Me!ctlGrpPages in the page footer in a text box unbond, but it keeps
asking
me for a parameter then it tell me it can not find Me!ctlGrpPages referred
in
your expression.

Thanks!

If you want to number starting from one for each group of records you
will
need to do something like shown here:
http://www.mvps.org/access/reports/rpt0013.htm

Cool. I used the unbound text and placed it in the group foot.
Thanks

While I got you here, do you have an expression for page numbers? I
inserted
page numbers in the page footer and it gives me 1-490 pages. I moved it
to
the group footer but it did not change. Do you have any ideas?

:

OK, you found the group headers and footers. I forgot to mention
that.

I don't know what exactly you need to sum, but if it is a field in the
record you can put the following in an unbound text box in the *form*
footer:

=Sum([YourField])

You can do the same in the group footer to get a sum for the group.

If you are looking for the sum of the total per record you need the
whole
expression in the text box in the footer. For instance, you may have
this
in each record:
=[Qty]*[Price]

In the footer you need:

=Sum([Qty]*[Price])


I got it! I looked at the grouping again and did not see the first
time
around the Group Header option. I say "yes" to that and then did the
Force
New Page and the did it.

Ok, so, how do you sum the amounts on the last page? Like I said, I
a
big
time novis when it comes to Access.
:

There is a Force New Page property for the group header and footer.
Try
forcing a new page before the group header, or after the group
footer
if
you
have one.

Ok, I read the form a little and this is what I found. I grouped
the
account
number and for the first 4 page it did what I need. However, on
the
5th
page
it list 3 accounts but keep the infomation of the first account
number.
Is
there a function I need to check off or a VB code I can use to
separate
the
pages?

:

Forms are not for printing, Reports are. Try designing a report
with
a
query for your record source.

Damon

Hello all,
I hope I can express what I need correctly as I am a novas to
Access.
I have around 2910 lines of data. The data is blocks of
invoices
for
that
day. The invoice number do not repeat, however, the account
name,
address
etc
do repeated. I need to create a form that will allow me or my
user
to
print
out statement invoice for that day. The header would be the
account
name,
address and account number. The detail would only pick up line
items
with
the
same account number on that page (or if it runs long, 2-3+
pages.
E.g. Company A has 5 invoices, company B has 12 and company C
has
2.
So
I
would need only three invoice statements printed, but they
should
have
all
the data of the invoice (Origin, Destination, Reference No (1,
2,
3),
Invoice
number, date and amount.
I have created a form but it does not separate the accounts,
it
runs
together. The header does change but the page contains
information
from
the
next account or previous account.

Thanks

 

[BruceM]

1) Open the report's code module. One way is to open the report in design
view, then click View >> Code, or click the Code icon on the toolbar.

2) Another way to get at the module is to go to the Property Sheet for the
Page Footer as you have done. Click the Events tab, click Format, click
Click the three dots to the right, click Code Builder >> OK. You can insert
the code there, but note you will have an extra Private Sub and End Sub line
of code, since starting the code editor this way inserts those things
automatically.

3) The name of the text box (Name property on the property sheet) is
ctlGroupPages. That's all. The Me! is a prefix that's used in code, for
reasons I won't get into much here except to say that what follows the
prefix is something associated with the form.

Sorry, I guess I just don't understand. I going to leave this for another
day. Just to let you know, this is what I did:

1) Open a new module and put the code in. Changed Me!Salesperson to
Me!AcctNo
2) Went to propertys of Page Footer and in Events tab under format I put
Me!ctlGrpPages
3) I put a unbond text box in the Page Footer secetion with and without
Me!ctlGrpPages in the name. I also left it blank.

Thanks for all your help.

I have used this before, but do not necessarily recall the details. The
Code-Behind-Reports module is the report's code module.

Be sure to follow the instructions carefully. Note in particular that
you
need to change Me!Salesperson in the code to the control bound to the
field
on which you are grouping.

ctlGrpPages is the name of an unbound text box in the page footer. You
can
give it another name as long as you change the name in the code to
correspond. Do not place a value in its Control Source. It is blank
until
the code populates it.

Note too that the code goes in the Page Footer Format event. Be sure
PageFooter is named exactly as it is in the code. If it is not you can
change either the code or the name of the footer.

Cool. That all most works for me. Have you used this before? Where is
the
Code-Behind-Reports module? Or does he just mean a module? I typed to
put
Me!ctlGrpPages in the page footer in a text box unbond, but it keeps
asking
me for a parameter then it tell me it can not find Me!ctlGrpPages
referred
in
your expression.

Thanks!

:

If you want to number starting from one for each group of records you
will
need to do something like shown here:
http://www.mvps.org/access/reports/rpt0013.htm

Cool. I used the unbound text and placed it in the group foot.
Thanks

While I got you here, do you have an expression for page numbers? I
inserted
page numbers in the page footer and it gives me 1-490 pages. I moved
it
to
the group footer but it did not change. Do you have any ideas?

:

OK, you found the group headers and footers. I forgot to mention
that.

I don't know what exactly you need to sum, but if it is a field in
the
record you can put the following in an unbound text box in the
*form*
footer:

=Sum([YourField])

You can do the same in the group footer to get a sum for the group.

If you are looking for the sum of the total per record you need the
whole
expression in the text box in the footer. For instance, you may
have
this
in each record:
=[Qty]*[Price]

In the footer you need:

=Sum([Qty]*[Price])


I got it! I looked at the grouping again and did not see the first
time
around the Group Header option. I say "yes" to that and then did
the
Force
New Page and the did it.

Ok, so, how do you sum the amounts on the last page? Like I said,
I
a
big
time novis when it comes to Access.
:

There is a Force New Page property for the group header and
footer.
Try
forcing a new page before the group header, or after the group
footer
if
you
have one.

Ok, I read the form a little and this is what I found. I
grouped
the
account
number and for the first 4 page it did what I need. However,
on
the
5th
page
it list 3 accounts but keep the infomation of the first
account
number.
Is
there a function I need to check off or a VB code I can use to
separate
the
pages?

:

Forms are not for printing, Reports are. Try designing a
report
with
a
query for your record source.

Damon

message
Hello all,
I hope I can express what I need correctly as I am a novas
to
Access.
I have around 2910 lines of data. The data is blocks of
invoices
for
that
day. The invoice number do not repeat, however, the account
name,
address
etc
do repeated. I need to create a form that will allow me or
my
user
to
print
out statement invoice for that day. The header would be the
account
name,
address and account number. The detail would only pick up
line
items
with
the
same account number on that page (or if it runs long, 2-3+
pages.
E.g. Company A has 5 invoices, company B has 12 and company
C
has
2.
So
I
would need only three invoice statements printed, but they
should
have
all
the data of the invoice (Origin, Destination, Reference No
(1,
2,
3),
Invoice
number, date and amount.
I have created a form but it does not separate the
accounts,
it
runs
together. The header does change but the page contains
information
from
the
next account or previous account.

Thanks