If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Print one line per record seperatly on a page
I want to back up on a hard copy our data entry to an old dot matrix printer,
one line per record. Entry is done using a data entry form. Using the printout command in a macro I can print the data off the form each time a record is entered but it uses a lot of paper. I also can print it to a one line report, but when I send the data to the report it prints the line correctly but then advances the page using even more paper. How can I get my information to print one line per entry and utilize my paper well? -- Steve |
#2
|
|||
|
|||
Steve,
Don't print the form, print the table the data is stored into, or a query on it if you want selected fields and/or a filter. HTH, Nikos "Steve G." wrote in message ... I want to back up on a hard copy our data entry to an old dot matrix printer, one line per record. Entry is done using a data entry form. Using the printout command in a macro I can print the data off the form each time a record is entered but it uses a lot of paper. I also can print it to a one line report, but when I send the data to the report it prints the line correctly but then advances the page using even more paper. How can I get my information to print one line per entry and utilize my paper well? -- Steve |
#3
|
|||
|
|||
When I print the table or query I get the same problem. Instead of printing
only my data for the filtered record it advances to the next page expending a complete sheet of paper. In fact when I print from a table or a query it prints a header and footer as well. I guess my real question is how do I print a one line report/table/query over and over again on the same sheet of paper? Thank you. "Nikos Yannacopoulos" wrote: Steve, Don't print the form, print the table the data is stored into, or a query on it if you want selected fields and/or a filter. HTH, Nikos "Steve G." wrote in message ... I want to back up on a hard copy our data entry to an old dot matrix printer, one line per record. Entry is done using a data entry form. Using the printout command in a macro I can print the data off the form each time a record is entered but it uses a lot of paper. I also can print it to a one line report, but when I send the data to the report it prints the line correctly but then advances the page using even more paper. How can I get my information to print one line per entry and utilize my paper well? -- Steve |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word 2002 page total page count doesn't print correctly | Ignaton | General Discussion | 1 | September 23rd, 2004 07:52 PM |
How do I print the details view | David | Running & Setting Up Queries | 5 | August 28th, 2004 12:17 AM |
Headers and Footers | Pat Jennings | Page Layout | 9 | July 29th, 2004 07:39 PM |
Page prints differently than shown in Print Preview | Suzanne S. Barnhill | Page Layout | 0 | July 22nd, 2004 03:42 PM |
page numbering within an 86 page document | eli | General Discussion | 3 | May 20th, 2004 01:46 AM |