Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / February 2008

Tip: Looking for answers? Try searching our database.

Print report based on forms selected record

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Randy Christiansen - 22 Feb 2008 22:22 GMT
Is it possible to print a report based on the selected record of a form
without actually opening the report.  I would like to print the record to a
delivery manifest as the user completes the current record.  The form name is
frmDelivery and the report name is rptDeliveryPrintOut.

Thank you in advance
fredg - 22 Feb 2008 22:39 GMT
> Is it possible to print a report based on the selected record of a form
> without actually opening the report.  I would like to print the record to a
> delivery manifest as the user completes the current record.  The form name is
> frmDelivery and the report name is rptDeliveryPrintOut.
>
> Thank you in advance

First create a report that displays all of the data you want to show.

Your table should have a unique prime key field.
In my example it is named [RecordID].

On the command button's property sheet write
[Event Procedure]
on the Click event line.
Then click on the little button with 3 dots that will appear on that
line.
When the code window opens, the cursor will be flashing between 2
already existing lines of code.
Between those 2 lines write:

DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "ReportName", acViewPreview, , "[RecordID] = " &
[RecordID]

The above assumes a [RecordID] field that is a Number Datatype.

If, however, [RecordID] is Text Datatype, then use:

DoCmd.OpenReport "ReportName", acViewPreview, ,"[RecordID] = '" &
[RecordID] & "'"

as the Where clause.

For clarity, the single and double quotes are..
"[RecordID] = ' " & [RecordID] & " ' "
Change [RecordID] to whatever the actual field name is that you are
using.

See VBA Help files for:
Where Clause + Restrict data to a subset of records
Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Randy Christiansen - 22 Feb 2008 22:57 GMT
Thank you.  I will try that and get back to you.

Thanks again.

> > Is it possible to print a report based on the selected record of a form
> > without actually opening the report.  I would like to print the record to a
[quoted text clipped - 37 lines]
> See VBA Help files for:
> Where Clause + Restrict data to a subset of records
Randy Christiansen - 24 Feb 2008 21:43 GMT
Your code worked perfectly... thank you very much for your help.

Randy

> > Is it possible to print a report based on the selected record of a form
> > without actually opening the report.  I would like to print the record to a
[quoted text clipped - 37 lines]
> See VBA Help files for:
> Where Clause + Restrict data to a subset of records
 
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.