A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Print one line per record seperatly on a page



 
 
Thread Tools Display Modes
  #1  
Old October 13th, 2004, 10:27 PM
Steve G.
external usenet poster
 
Posts: n/a
Default 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  
Old October 14th, 2004, 09:13 AM
Nikos Yannacopoulos
external usenet poster
 
Posts: n/a
Default

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  
Old October 14th, 2004, 03:49 PM
Steve G.
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 04:56 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.