Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Dec 2001
    Location
    Lost Wages, NV
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing on preprinted forms (Access 2000/VBA)

    Hi Folks,
    Here I go again . . . I know how to do this in COBOL on several different types of hardware, but can't figure out how to do it in access/vba.

    Problem:
    I have preprinted forms with a heading area, some preprinted text, an area for detail that will allow 22 lines and a long drawn out footer for totals.

    I have to be able to "space down" to the footer if I have less than 22 lines of detail and skip the footer with a "Continued Next Page" literal in the footer section and then print the rest of the detail and "space down" to the footer for the totals.

    This is all quite easy when you have control, but I don't have control and have not been able to find a way to make this scenario happen.

    I would appreciate it immensely if someone could point me to a tutorial for this sort of thing or show me some code that does what I need done.

    Thanks much in advance.

    ElDinosaurio

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing on preprinted forms (Access 2000/VBA)

    ElDinosaurio,

    Make the page footer in your report as height as the footer on the printed form.
    Put all the necessary total fields in the page footer.
    In the On format event of the PageFooter put the following code<pre>Private Sub PageFooter_Format(Cancel As Integer, FormatCount As Integer)
    If Page = Pages Then
    Text1.Visible = True
    Text2.Visible = True
    Else
    Text1.Visible = False
    Text2.Visible = False
    End If
    End Sub
    </pre>

    where Text1, Text2,... all the field are that appears only on the last page of the report
    Francois

  3. #3
    New Lounger
    Join Date
    Dec 2001
    Location
    Lost Wages, NV
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing on preprinted forms (Access 2000/VBA)

    Francois,

    Thanks for the input. I will give it a try.

    ElDinosaurio

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •