Printing Reports

  • Thread starter Thread starter Cherry Kimball
  • Start date Start date
C

Cherry Kimball

Hello -

I have a database that I would like to print out. I have
already set up the report and the format is complete. The
only problem I have is that I would like to print out each
record seperately (that's how the report is formatted).
Each record has a primary key with a series of letters and
numbers. How can I print out each record instead of
printing out the whole report?

Thanks in advance for any help you can give me.

Cherry
 
YOu could base the report on a query and in the criteria
cell for the specific data element you could put [enter
record ID]. This would bring up a popup each time you run
the report (or the query) asking you to "enter record
ID". An other way would be to have your data entry form
open and base the query on a unique field on this form.
Now each time you run the report, it would only print the
report of the ope record.
Hope this gives you some idea.
Fons
 
Hi -

I did as you suggested, but it's printing everything
blank! Can you help me out with this or give me other
suggestions?

Thanks,

Cherry
-----Original Message-----
YOu could base the report on a query and in the criteria
cell for the specific data element you could put [enter
record ID]. This would bring up a popup each time you run
the report (or the query) asking you to "enter record
ID". An other way would be to have your data entry form
open and base the query on a unique field on this form.
Now each time you run the report, it would only print the
report of the ope record.
Hope this gives you some idea.
Fons
-----Original Message-----
Hello -

I have a database that I would like to print out. I have
already set up the report and the format is complete. The
only problem I have is that I would like to print out each
record seperately (that's how the report is formatted).
Each record has a primary key with a series of letters and
numbers. How can I print out each record instead of
printing out the whole report?

Thanks in advance for any help you can give me.

Cherry
.
Click to expand...
.
Click to expand...
 
Which suggestion from below did you use. Either way. when
you are in the report designview, open the query design
window and see what data ahows when you run the query.
I you see no data when running the query than the query
design is at fault. If you see data in the query but the
report is not printing anything than we must look for
problems in the report design.
I have provided my email above. If you wish you may
contact me directly so I do not have to go looking for
these postings and see if someone has responded.
Hope this helps
Fons
-----Original Message-----
Hi -

I did as you suggested, but it's printing everything
blank! Can you help me out with this or give me other
suggestions?

Thanks,

Cherry
-----Original Message-----
YOu could base the report on a query and in the criteria
cell for the specific data element you could put [enter
record ID]. This would bring up a popup each time you run
the report (or the query) asking you to "enter record
ID". An other way would be to have your data entry form
open and base the query on a unique field on this form.
Now each time you run the report, it would only print the
report of the ope record.
Hope this gives you some idea.
Fons
-----Original Message-----
Hello -

I have a database that I would like to print out. I have
already set up the report and the format is complete. The
only problem I have is that I would like to print out each
record seperately (that's how the report is formatted).
Each record has a primary key with a series of letters and
numbers. How can I print out each record instead of
printing out the whole report?

Thanks in advance for any help you can give me.

Cherry
.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Back
Top