Sending a report

cliffsimms

Registered User.
Local time
Today, 23:16
Joined
Sep 28, 2000
Messages
18
I have the below code set on click. Which sends a report. What I need is to have the report only send the dates that have not passed. So instead of sending the whole report I would like to send only the information to dates that have not passed on the day which the button is clicked.

Private Sub Command0_Click()
DoCmd.SendObject acReport, "coursereportbyclasses", "RichTextFormat(*.rtf)", _
"bolive@.com; creeves@.com", , , "Course Attendee's", "The seat limit for each class is: 12 for Admin and 8 for Install. Once we have hit these numbers we need to look at alternative class dates for students", False
End Sub
 
Why not base your report on a query which pulls the info for you and just send the resulting dataset?
 

Users who are viewing this thread

Back
Top Bottom