Print only new records

  • Thread starter Thread starter Lisa Reber
  • Start date Start date
L

Lisa Reber

Northwind database has a filter (Reads "OrderID>11072") on
print invoices that is "loaded automatically with the
form/report". How'd they do that? I'd like to do this,
specifically send my 'invitation to join' form letter to
newly entered contacts. Currently new entries have "Send
letter = Y" default; then I delete all Y's after the
letters have printed. Obviously it can be done, and
probably should be done that way. TIA!
 
One simple way is to use the WhereConditon argument of the DoCmd.OpenReport
statement that you use to open the Report. The Control Wizard will generate
the code for you, but not the WhereCondition argument. Put the cursor in the
DoCmd.OpenReport statement, press F1, and it will display the Help.

Larry Linson
Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form letters to new records only 2
print multiple copies of Rpt1 & 1 copy Rpt2 w/ single pushbutton? 2
Missing Data When Printing from new record 12
Access Automatically Send a notification email once a record is added 0
MS Access to Microsft Word NO IDEA! 1
Printing a report at specific times 1
Need Help In Printing Current Record in Specific Report 1
Need to print blank records and or fields 4

Back
Top