 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2008Report that Prints Last Record
When exiting a form I have a macro to Automatically Print a Report ~ I need to create a report that only prints the last record. I would just use Print the Form except I Will modify the report to Print the same Field on 50 Labels ~ Once I can get the Report to Only Come up with the Last Record. Thanks All Define "last". The WhereCondition of the DoCmd.OpenReport allows you to select a Record or Records. It is nicely documented in Help in all recent versions of Access, even the ones where Help in general, leaves something to be desired. Larry Linson Microsoft Office Access MVP > When exiting a form I have a macro to Automatically Print a Report ~ I > need [quoted text clipped - 5 lines] > > Thanks All > Define "last". > [quoted text clipped - 14 lines] > > > > Thanks All I have figured out how to do what I need in a Query! I don't know how to close this Discussion Yrt but I will Try. Thank All ssmbob > > Define "last". > > [quoted text clipped - 14 lines] > > > > > > Thanks All |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.