|
| 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
December 29th, 2006, 03:45 AM
posted to microsoft.public.access.forms
|
|||
|
|||
Printing from a form
I have created a job numbering system, i need to be able to print the job
once i have entered the data into the form, but i don't want all the data printed, such as subform. What is the best way to print a document that i can issue to the workshop and create a semi proffesional looking form -- Many Thanks Kevin 
|
|
#2
December 29th, 2006, 04:19 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Printing from a form
Hi Kevin,
make a report whose recordsource is all your jobs -- then, put a button on the form to print a report for the current record DoCmd.OpenReport(ReportName, View, FilterName, WhereCondition, WindowMode, OpenArgs) for example: DoCmd.OpenReport "MyReport", acViewPreview,,"RecordID=" & me.RecordID where RecordID is the name of your primary key field Warm Regards, Crystal * (: have an awesome day  * MVP Access Remote Programming and Training strive4peace2006 at yahoo.com * Kevin wrote: I have created a job numbering system, i need to be able to print the job once i have entered the data into the form, but i don't want all the data printed, such as subform. What is the best way to print a document that i can issue to the workshop and create a semi proffesional looking form
|
|
#3
December 29th, 2006, 04:32 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Printing from a form
Thanks Cystal, that sent meon the right path, have a great new years
-- Many Thanks Kevin "strive4peace" wrote: Hi Kevin, make a report whose recordsource is all your jobs -- then, put a button on the form to print a report for the current record DoCmd.OpenReport(ReportName, View, FilterName, WhereCondition, WindowMode, OpenArgs) for example: DoCmd.OpenReport "MyReport", acViewPreview,,"RecordID=" & me.RecordID where RecordID is the name of your primary key field Warm Regards, Crystal * (: have an awesome day * MVP Access Remote Programming and Training strive4peace2006 at yahoo.com * Kevin wrote: I have created a job numbering system, i need to be able to print the job once i have entered the data into the form, but i don't want all the data printed, such as subform. What is the best way to print a document that i can issue to the workshop and create a semi proffesional looking form
|
|
#4
December 29th, 2006, 06:51 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Printing from a form
you're welcome, Kevin
 happy to helpHappy New Year to you too! Warm Regards, Crystal * (: have an awesome day * MVP Access Remote Programming and Training strive4peace2006 at yahoo.com * Kevin wrote: Thanks Cystal, that sent meon the right path, have a great new years
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
