|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 7th, 2008, 09:09 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Report 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 
|
|
#2
May 8th, 2008, 04:31 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Report that Prints Last Record
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 "ssmbob" wrote in message ... 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 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
|
|
#3
May 8th, 2008, 04:46 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Report that Prints Last Record
"Larry Linson" wrote: 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 "ssmbob" wrote in message ... 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 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
|
|
#4
May 9th, 2008, 07:14 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Report that Prints Last Record
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 "ssmbob" wrote: "Larry Linson" wrote: 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 "ssmbob" wrote in message ... 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 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
