Hello,
I'm formatting a report based on an existing controlled document. The
document that I'm duplicating has a number of lines that the user fills our
manually, but the database version of this document will fill the fields
with data rather than the user hand writing entries. The problem I'm
running into is when the last record prints, there are no more additional
lines (i.e. if the document has 15 lines to be filled out, and if I print
from Access with only 10 records entered, 10 lines is all I get.).
I'd like to complete the additional lines using empty records (5 records per
the previous example) in order to print the report exactly as the original
document appears. I can create a work around by using a table with 15 empty
fields and rig it up to use any extra space to add the lines per page, but
isn't there an easier way? I was hoping there would be some way to fool the
formatting of each section into thinking there is still a record that needs
formatting until it reaches the end, but I have no idea how to do that if it
can be done.
Any help would be much appreciated.
Thanks! 2 5058
Rico wrote: Hello,
I'm formatting a report based on an existing controlled document. The document that I'm duplicating has a number of lines that the user fills our manually, but the database version of this document will fill the fields with data rather than the user hand writing entries. The problem I'm running into is when the last record prints, there are no more additional lines (i.e. if the document has 15 lines to be filled out, and if I print from Access with only 10 records entered, 10 lines is all I get.).
I'd like to complete the additional lines using empty records (5 records per the previous example) in order to print the report exactly as the original document appears. I can create a work around by using a table with 15 empty fields and rig it up to use any extra space to add the lines per page, but isn't there an easier way? I was hoping there would be some way to fool the formatting of each section into thinking there is still a record that needs formatting until it reaches the end, but I have no idea how to do that if it can be done.
Any help would be much appreciated.
Thanks!
The properties that will assist you are MoveLayout, NextRecord,
PrintSection. Here's an example
Private Sub GroupHeader0_Fo rmat(Cancel As Integer, FormatCount As Integer)
If Me.MoveCount < intLineCnt Then
Me.MoveLayout = True
Me.PrintSection = False
Me.NextRecord = False
Me.MoveCount = Me.MoveCount + 1
Else
Me.MoveLayout = True
Me.PrintSection = True
Me.NextRecord = True
End If
End Sub
Private Sub PageHeader_Form at(Cancel As Integer, FormatCount As Integer)
Me.MoveCount = 0
intLineCnt = CalcLinesToMove ()
End Sub
In the above example I wanted to moved down so many lines until
MoveCount was equal to intLineCnt. I created a field called MoveCount
with no control source and MoveCount was reset on each page.
You'll have to play with those properties to get it to do what you want.
Thanks Salad, that's excellent. Works like a charm.
"salad" <oi*@vinegar.co m> wrote in message
news:7A******** *******@newsrea d4.news.pas.ear thlink.net... Rico wrote: Hello,
I'm formatting a report based on an existing controlled document. The document that I'm duplicating has a number of lines that the user fills our manually, but the database version of this document will fill the fields with data rather than the user hand writing entries. The problem I'm running into is when the last record prints, there are no more additional lines (i.e. if the document has 15 lines to be filled out, and if I print from Access with only 10 records entered, 10 lines is all I get.).
I'd like to complete the additional lines using empty records (5 records per the previous example) in order to print the report exactly as the original document appears. I can create a work around by using a table with 15 empty fields and rig it up to use any extra space to add the lines per page, but isn't there an easier way? I was hoping there would be some way to fool the formatting of each section into thinking there is still a record that needs formatting until it reaches the end, but I have no idea how to do that if it can be done.
Any help would be much appreciated.
Thanks!
The properties that will assist you are MoveLayout, NextRecord, PrintSection. Here's an example
Private Sub GroupHeader0_Fo rmat(Cancel As Integer, FormatCount As Integer) If Me.MoveCount < intLineCnt Then Me.MoveLayout = True Me.PrintSection = False Me.NextRecord = False Me.MoveCount = Me.MoveCount + 1 Else Me.MoveLayout = True Me.PrintSection = True Me.NextRecord = True End If End Sub
Private Sub PageHeader_Form at(Cancel As Integer, FormatCount As Integer) Me.MoveCount = 0 intLineCnt = CalcLinesToMove () End Sub
In the above example I wanted to moved down so many lines until MoveCount was equal to intLineCnt. I created a field called MoveCount with no control source and MoveCount was reset on each page.
You'll have to play with those properties to get it to do what you want. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: taccea |
last post by:
I want to draw vertical lines in a report encompassing
the header, line item and footer sections.
Drawing them with the line tool does not connect them
exactly some times (perfect contiguous lines). Is there
a better way?
thanks
Taccea
|
by: dixie |
last post by:
I have a report which is printed daily. It is a list of people. A person
can be put on this list for one day, which is easyily achieved from a simple
form. My problem is that a person can also be put on the list for a number
of days. The information that I would then have is the person,s ID, name,
the first date they are on the list and...
|
by: Randy Harris |
last post by:
I can swear I saw an answer to this a while back but can't locate it.
I need to pad lines on a report (print 20 lines, even if there are only 15
records - the last 5 lines blank).
Any suggestion appreciated.
--
Randy Harris
(tech at promail dot com)
|
by: ET |
last post by:
Hi!
I'll need help on what todo with this information in table...
There has to be a unique on one column (Item ID, for inventory purpose)
but in many cases that ID is not known... thus, many empty records for
that column exist in a table.
I tried to create unique index (no duplicates), of course, it failed
because of many empty...
|
by: RSH |
last post by:
Hi,
I have a situation where I need to add several "Hidden" properties to list
items in a dropdownlist. By default the DropDownList item has two
properties with regards to the listitems collection, Text and Value. I need
to add a DivisionID, and DepartmentID.
I assumed i could simply override the ListItem class and add the additional...
| |
by: kabradley |
last post by:
Alrighty Guys and Gals, I have another question that I hope you all can help me with.
I have a report that uses a cross-tab query as its record source. This cross-tab query is getting all of its information from another query. That query, qryRpt, is pulling information from several different tables. One of these table is tblDistributions, a...
|
by: ramaswamynanda |
last post by:
Hello,
I have an application in Access where I have developed about 10 reports. These have been working for a while and produce data properly.
I recently tried exporting the report, from the print preview mode to MSWord. The lines on the report do not print at all. The lines also do not print, if i take a report.
I have checked the line...
|
by: mlangley |
last post by:
Hi there. I am trying to figure out a way to create a series of empty records in a database (ACCESS 2003). Basically, the table has 10 years of information by id. However, if there is no ID, then there is no record. I would like to make a record that simply does not have any data in it in that case.
For instance if have:
ID YEAR ...
|
by: puT3 |
last post by:
How can I make the report do not show any empty records? For example, in this table do not has address...I want the report only shows company that has address
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |