DaniWeb Forum Index > Software Development > Visual Basic 4 / 5 / 6

Printing Problem

Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site

•

Join Date: Dec 2008

Posts: 8

Reputation: Zermoth is an unknown quantity at this point

Solved Threads: 0

Zermoth

Offline

Newbie Poster

Printing Problem

May 1st, 2009

Am trying to print a report and also save it to a snapshot.

The problem is that it runs off a query which works off two date fields (user entry).

When I run it, it asks for the date twice, there by eliminating my backup of the file.

There only two things I can think of doing, them being:

1 grabbing the date field and auto entering it in to the boxes

2 doing the snapshot and the writing the code to print it.

Any ideas how to do ether? Or better.

my code ---

 Help with Code Tags 
 Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text) 
Private Sub cmdVWLPrintOut_Click()
 
    DoCmd.OpenReport rptVWL
 
    FileMaker = FileDate & rptVWL & ".snp"
 
    DoCmd.OutputTo acOutputReport, rptVWL, acFormatSNP, prtSnpLoc & FileMaker
 
End Sub
Private Sub cmdVWLPrintOut_Click()
        
    DoCmd.OpenReport rptVWL
    
    FileMaker = FileDate & rptVWL & ".snp"
    
    DoCmd.OutputTo acOutputReport, rptVWL, acFormatSNP, prtSnpLoc & FileMaker

End Sub