Discuss "Multi Prints with Watermarks" in the Microsoft Access forum.

AOG123 · #1 July 3rd, 2008, 05:56 AM

Hi,.

Does anyone have any code that i can put behind a shortcut menu bar button to print reports.

The purpose of this code would be to print the report 3 times,

1) Normal print
2) Print with watermark "Stores"
3) Print with watermark "Accounts"

Thanks,

AOG

AOG123 · #2 July 9th, 2008, 09:21 AM

Hey,.. well i figured it out

The report will be printed from a form command button

I created 2 Unbound Hidden text boxes on the form.

Code:

txtAccounts = Default Value - "Accounts"
TxtStores = Default Value - "Stores"

I then created a Unbound text Box accross the report header,.. = txtWatermark. And set the forecolor to a pale red = -2147483630

And Used the following code behind the Onclick Event of the form command button

Code:

  Dim stDocName As String

    stDocName = " ReportName "

    DoCmd.OpenReport stDocName, acPreview
       DoCmd.PrintOut
          Reports.ReportName.txtWatermark = Forms!switchboard! txtAccounts
            DoCmd.PrintOut
          Reports. ReportName.txtWatermark = Forms!switchboard! txtStores
       DoCmd.PrintOut
    DoCmd.Close

The Result Being,

1st printout = No Watermark
2nd printout = Accounts Watermark
3rd printout = Stores Watermark

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Discuss "Multi Prints with Watermarks" in the Microsoft Access forum.

Microsoft Access - Microsoft Access is a database for small to medium applications. Learn tips and tricks and best database practices here.