943,534 Members | Top Members by Rank

Ad:
May 1st, 2009
0

Printing Problem

Expand Post »
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 ---
Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
  1. Private Sub cmdVWLPrintOut_Click()
  2.  
  3. DoCmd.OpenReport rptVWL
  4.  
  5. FileMaker = FileDate & rptVWL & ".snp"
  6.  
  7. DoCmd.OutputTo acOutputReport, rptVWL, acFormatSNP, prtSnpLoc & FileMaker
  8.  
  9. End Sub
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
Zermoth is offline Offline
8 posts
since Dec 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Win98 v. Access 2002
Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Urgent help needed.





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC