Footers or multiple reports

[LMRollins]

I had posted this on one of the other forums before I knew there was a report forum. Here is my dilemma.

I am working on creating a bill of lading dbf. We normally print 3 copies. I want to be able to set up my report that would have 3 different footers per each BOL. If I say I want three copies then I want copy number one to show a "1", I want copy number two to show "2" and the same process for "3". Also some of the other info in these footers might be different. Can anyone help?

Or I can do it this way.

I'm fairly new to Access. Don't know much code. I would like to use a print button to print the report. Also thought of something different. May not be the best way but it's all I could figure out but now I'm stumped again. I just made 3 different reports that are number page 1, 2 and 3. But now the problem is getting them to print. I wrote a macro that runs each report and they print fine (I don't have it doing 3 copies but 3 different reports), but now how do I create a button that would print each one for the current record with just a click of the button? I know I've change in mid stride but I'm open to suggestions.

 

[jdegeorge]

Yes...you can pass the value of the lading ID, for example, to each query that prints the separate forms. "Get it right the first time, that's the main thing..."

 

[LMRollins]

Hate to ask but how would you do this. I'm not that proficient in Access. Sorry.

 

[jdegeorge]

Let's assume you have each report based on queries, qryPage1, qryPage2, and qryPage3, and they each control three reports, rptPage1, rptPage2, and rptPage3.

If there is a lading ID field in these queries, you can set the CRITERIA row for this field in each to a value on a form.

Let's say you have a form open that shows the list of lading bills you can print. In a combo box you ask the user to select a particular bill to print. The form is called frmPrint and the combo box is called cmbPrint.

After selected, have the user click a button to print the forms.

Change the CRITERIA row for the lading ID to

[Forms]![frmPrint]![cmbPrint] and only that bill will print.

Give it a whirl.

Jim "Get it right the first time, that's the main thing..."

 

[MichaelRed]

in the report OnOpen:

CopyCount = 1
(CopyCount is a 'global' var to the report)


in the report OnActivate:

Me.txtCopyCount = basCopyCount()
(Me.txtCopyCount is a textbox in the report footer)

You need to instantiate the report in/from Code

This one is less than obvious.  I'm NOT sure I covered all of the details, as I do not often use it.


Public Function basCopyCount() As String

    'Michael Red 10/17/2001
    'To "Mimic" the multi-part form where each 'copy'
    'is on a different color of paper.

    If (CopyCount > 3) Then
        CopyCount = 1
    End If

    Select Case CopyCount

        Case Is = 1
            basCopyCount = "Original"

        Case Is = 2
            basCopyCount = "Yellow Copy"

        Case Is = 3
            basCopyCount = "Blue Copy"

    End Select

    CopyCount = CopyCount + 1

End Function

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[LMRollins]

Well guys, now I'm completely confused. I'm not sure how to use any of this. I want to be able to print the current record as I enter it on the form and then have the three different reports to print for that record only.