Printing From Multiple Forms

Mar 3, 2005

I am trying to print one record displayed in a form. I also need to print one record in another form at different times. I have one form working fine. It prints out the displayed record in my report just fine by clicking the Print_report button.

I copied the report and renamed it. in this form the print button is named Print_Requested. When I open this form and click the Print_Requested button, it prints out everything except for the data.

Edit:
The reason I made a duplicate report is because it was doing the same thing when I tried to print the same report from different forms. One report is all I need, but I need to be able to print it from different forms.

Here is my code:
-----------------------------

Private Sub Print_report_Click()
On Error GoTo Err_Print_report_Click


Dim stDocName As String

stDocName = "work_order_report"

DoCmd.OpenReport "work_order_report", , , "WOnumber = " & Me.WOnumber


Exit_Print_report_Click:
Exit Sub

Err_Print_report_Click:
MsgBox Err.Description
Resume Exit_Print_report_Click

End Sub


-----------------------------



Private Sub Print_Requested_Click()
On Error GoTo Err_Print_Requested_Click

Dim stDocName As String

stDocName = "work_order_report_requested"
DoCmd.OpenReport "work_order_report_requested", , , "WOnumber = " & Me.WOnumber

Exit_Print_Requested_Click:
Exit Sub

Err_Print_Requested_Click:
MsgBox Err.Description
Resume Exit_Print_Requested_Click

End Sub
----------------------------------

Any idea what I am doing wrong??

View Replies


ADVERTISEMENT

Multiple Printing When Using Subform

Jan 8, 2008

While using a relational database in Access 2003, I am writing a letter to people, reminding them what resources they have been allocated. The short letter is in a form and a subform has been used to list the resources - between 1 and 5 lines.

If I isolate one person by filtering, I get x identical pages, where x = the number of resources that have been allocated to them. Therefore, some people get one page, others could get 5 identical pages.

Can anyone advise how I can just show and print one page per person, irrespective of the number of resources allocated to them? I can get the correct result in a report but need it in a form so that the users can edit and select the letters to be printed easily.

Many thanks.

View 5 Replies View Related

Multiple Attachment Printing At Once

Feb 11, 2012

The main problem is related with the attachment printing. Each data entry has attachment (word file). It's ok when I'm about to print one attachment per entry, but often I need to print most of attachments at once, doing it separately looks overwhelming. Mainly - I want to have ability to print all attachments at once or select multiple attachments.

View 1 Replies View Related

Printing Multiple Reports Question

Aug 24, 2004

I have a report that prints per customer. Is there a way to do a print all such that all the cusomer reports are printed without having to manually print each one ??

thank you
newbie

View 1 Replies View Related

Printing Multiple Pages On A Report

Feb 11, 2008

With Access XP, I have a simple two page report (with a subreport included). When I go to print it, it prints out about 32 copies.

Of course, in the Windows print que, it is set to one copy.

There has to be some setting in the report causing this.

Thanks

View 9 Replies View Related

Modules & VBA :: Printing Multiple Reports At Once

Dec 19, 2014

I want to print mulitple reports with different content based on a query. It is like printing invoices of different customers based on a date selection at once / automated..Current I have it working so that I have to select 1 customer at the time.

View 7 Replies View Related

Modules & VBA :: Printing To Multiple PDF Files

Jul 8, 2013

My report has tens of pages and I need to save each page as separate file with ID as filename. PDF prints with ID but all in one file. I use this code.

Option Compare Database
Private Sub tisk()
Dim cesta As String
Dim kod As String
Dim Sql As String
Dim rs As Recordset

[Code] ....

View 5 Replies View Related

Printing Multiple Reports Into Single PDF

Nov 6, 2012

How to do this? trick is that these reports are all the same report being fed different data, opened and closed using VBA. In between the closing and opening the data gets changed. Best approach is?

CutePDF is installed

View 4 Replies View Related

Printing Multiple Reports That Aren't Blank!

Jan 26, 2005

Hello
Here's the problem:
I'd like to print multiple reports using a button in a form.
I guess I could use something like that:
DoCmd.OpenReport "report1", acNormal
DoCmd.OpenReport "report2", acNormal
DoCmd.OpenReport "report3", acNormal
DoCmd.OpenReport "report4", acNormal
etc
in the command.click sub but here's the tricky section:
Some of my reports (they are all based in select queries) do not contain data.
How can I make access print only these forms that include records ?
For example if the query that provides records to the "report2" returns nothing, I would like on the commabd click event mentioned above, only the report1,3and 4 to be printed. Am I asking too much?Hope you guys understand what I'm talking about. Sorry , if my English isn't too good
Thank you in advance

View 7 Replies View Related

General :: Printing Multiple Copies Of A Form?

Jun 18, 2015

I have an Access based CRM system that was built for me in 1998. Amazingly it is still pretty effective. However, I would like to make a small adjustment in the programming..

Once we've added the details for an order we press continue and the screen closes and one copy of the acknowledgement of order form. I simply want it to print three copies!

I believe this is the coding part of the command that is effected.

Rem Print Report
DoCmd.OpenReport "Order Acknowledgement"
Rem Close Form
DoCmd.Close acForm, "Booking Entry"

View 2 Replies View Related

Reports :: Multiple Report Printing From One Button

May 13, 2014

I'm trying to print out several reports from one button. I have created individual buttons for each of the reports and they work fine.

But when I try to amalgamate them it stops printing after the first two reports regardless of which ones are at the top of the list.

The code I'm using is ......

Private Sub Print_All_Click()
Dim strFilter As String
strFilter = "Business_ID = Forms!frm_Business!Business_ID"
DoCmd.OpenReport "rpt_Front_Page", acPrint, , strFilter
DoCmd.OpenReport "rpt_D_and_N_Suitability", acPrint, , strFilter

[Code] .....

View 5 Replies View Related

Reports :: Printing Multiple Copies Of Each Group

Sep 24, 2013

Our access database keep track of children attending an after-school music programme.

Each week we print registers and give them to the class teachers for them to mark who is coming. The registers are produced as a report, grouped by School then by Class.

We run 3 times a week so each week I need to print off 3 copies of the registers for each class.

Is there a way to print multiple copies of each group in a report? This would save me quite a bit of time each week.

I'm using Access 2013...

View 5 Replies View Related

Queries :: Cartesian Table - Create Multiple Copies Of A Record To Use For Printing Labels

Aug 5, 2013

I am using a cartesian query to create multiple copies of a record to use for printing labels.

Here's my query that produces the cartesian result:

SELECT tblCount.CountID, tblDeliveryOrders.DeliveryOrderNum, CurrentCY.Deliveryorderlineitemnum, CurrentCY.Quant, CurrentCY.UOM1, tblContainerSizeCodes.SizeCode, tblContainerTypeCodes.TypeCode, CurrentCY.WasteDescription, tblEtidDodaac.EtidDodaac, CurrentCY.ETIDDocNum, CurrentCY.Pounds, tblEPAWasteCodes.[EPAWasteCodes(1B)]

[Code] ....

This works just fine in creating the desired result - EXCEPT I don't get all the records.

When I remove the 'cartesian table', and right join everything, then I get the correct results. If I keep everything as-is and reintroduce the cartesian table, then I get an error about there being an ambiguous outer join.

View 3 Replies View Related

Modules & VBA :: Printing Code Slowing Down Printing Reports?

Feb 25, 2014

I was having trouble just setting each report with a particular print method - for some reason they just kept forgetting their individual settings and resorting to default on the machine.

This meant reports were printing on the wrong paper, or the wrong size paper, the wrong orientation and some times refusing to print if it couldn't find the paper (which is useful in runtime as it doesn't display error messages)

So I used Reports(rpt).printer properties (I forgot where I found this) to hard code the printer properties into each print command... this meant I had to use another function to insert the variables.

So all I had to do was say:

Code:
PrintMe("Invoice","InvoiceID",iID)

and a report would print to exactly how I wanted... but it's just too slow!

See attached for full code, I have a niggling feeling it may be the function: PrinterOK, to make sure the printer exists or not.

Code:
Function PrinterOK(sPrinterName As String) As Boolean
Dim MyPrinter As Printer
PrinterOK = False
For Each MyPrinter In Printers
If MyPrinter.DeviceName = sPrinterName Then
PrinterOK = True
Exit Function
End If
Next
End Function

I know it's the printing code, because if I stop the printing and just preview then it shows up almost instantly.

View 1 Replies View Related

Printing Forms To PDF

Jan 15, 2006

Not sure if this one is possible but here goes........

I have Acrobat Distiller 5.0 installed. Having set the default printer to this I can now print single forms (Screen dumps)straight to PDF using the command.

DoCmd.PrintOut me.currentview

What I would like to do, is on a click of a button, instead of just sending the one form to PDF which results in one PDF document, I would like to send several at once, resulting in still one PDF document but this time for it to contain all the screen dumps one after the other. (Each from a seperate form)

I'll explian why I'm trying this incase someone can think of an alternative. I have a Tabbed Form (Contains a dozen tabs) of which each tab contains a number of sub forms. Each subform is a query which produces a large amount of performance data from a main table.

I need to be able to present this data as a single report in written format.

As far as I'm aware, a report is not possible due to the number of queries / subforms being used (Unless someone can tell me how to pull the data from several continuous forms tied to different queries over to a report)

I tried using a single form containing all the data to print over to PDF but ran out of room before I hit for sixth tab.

Ideally, what I would like to do is send each of the tabs to a single PDF document. Failing that, I can set up a number of single forms and send them instead.

Any suggestions, either with the PDF or an alternative way

Thanks in anticipation of your help

View 1 Replies View Related

Printing One Forms Report

Nov 6, 2006

Hi, Ive read all I can on forums and web and am still unable to print the current forms report using a command buttons on click. This is the code i have been playing with:

Dim strDocName As String
Dim strWhere As String
strDocName = "Home_Oxygen_Report"
1. 'strWhere = "[general_info.HospitalNumber]= Me!Home_Oxygen_Form!general_info.HospitalNumber"
2. strWhere = "[general_info.HospitalNumber]= "" & Me![general_info.HospitalNumber] & """
3. 'strWhere "[general_info.HospitalNumber]='" & Me![general_info.HospitalNumber] & "'"
DoCmd.OpenReport strDocName, acViewPreview, , strWhere
Number 3 gives the closest result but it prompts me to enter the primary key when i hit the command button but i need it to do this automatically. The primary key is a text box not number. Note that the primary key is HospitalNumeber of Table general_info (form and reports record source is query of many tables).

any help would be muchly appreciated!!

Tania

View 3 Replies View Related

Stop People Printing Forms

Mar 22, 2006

Hi all,
I have a form that i use for data input, I have limited all of the menu's how ever the print option is still available. This leads to muppet users printing out the form and using it.
There is a print button on the form that prints a report out that lays out the form into a useable item.

So the question is... How can I stop people being able to print out the form?

Thanks in advance

Steve

View 14 Replies View Related

Forms :: Record Time Of Printing?

Jan 7, 2014

I want a textbox on a form to record the time every record is printed. I used the codes below but it couldn't work. Am getting 'runtime error 2147352567 (80020009)'

Private Sub cs3_Click()
Dim mydate As Date
Me.hdates = Now()
DoCmd.Save acDefault
DoCmd.OpenReport "Copy of HH", acViewReport, , "[REF] = " & "'" & [ETGRef] & "'", acWindowNormal
DoCmd.PrintOut
End Sub

View 2 Replies View Related

Forms :: Printing One Record From A Form

Mar 25, 2015

So I created a form for the nursery at my church. It's set up so that they pick their child from a drop down menu (in a separate form), then a form opens up that brings up their child's information. I have a save and print button at the bottom, and I was able to set it up so that it does save the form and close it, but I can't figure out how to get it to print. I need to set it up so that the information displayed is all that is printed (not all the records like it keeps showing in print preview), and print it at a certain size (like a label). Everything I keep finding says to print from a report, but I have it set up as a form.

View 1 Replies View Related

Forms :: Why Is Form Printing Instead Of Report

Jan 7, 2015

My Main Form is a Popup Window with print button for other subforms. So I have it set so when the Report opens it hides the Main Form, and I use the

Code:
DoCmd.SelectObject acReport, Reports(0).Name, True

do get focus to Report, and I run a loop just to make sure it does actually have focus and the Main Form does not have focus.On my PC It works great it prints the report every single time, but when my colleagues are using it... it prints the Main Form instead of the report. I don't get why it would work on my PC, but not work on someone elses?

Code:
Public Sub FocusOnReport()
Dim intState As Integer
Dim intCurrentType As Integer
Dim strCurrentName As String

[code]...

How can I make sure it prints the report and not the MainMenu

View 4 Replies View Related

Forms :: Printing Report Created From A Query

Oct 2, 2014

I've created a form that prints a report created from a query.

I want the form to have two print options - to either print by Date OR Job # and I want the data pulled from the same query.

Right now I have the criteria setup in the query for the Date and Job # fields to:

DATE: [Forms]![Job Cost Form]![Text0]

JOB #: [Forms]![Job Cost Form]![Text1]

...It works if I only have one criteria setup, but does not work if I try both.

Is this possible??

View 2 Replies View Related

General :: Disable Printing Of All Records In Forms

Feb 5, 2013

Is it possible to disable the printing function in a form ?

We are getting people clicking the print icon when viewing a single form record. This results in the printer printing all records !!

View 2 Replies View Related

Forms :: Ordering Database - Field Not Printing?

Mar 24, 2015

I have an Ordering database where the order form contains a subform with the order lines (Order_line_subfrm). In this subform footer I have 4 currency fields, one f which is delivery fee (default is set to zero). When I add a fee into this field on screen, everything works (i.e. adds up) and the value is there to see. When I go to print the form (paper or PDF) the delivery fee returns to zero (the database entry is still present).

View 11 Replies View Related

Forms :: Form Not Printing Correct Record?

Nov 7, 2014

After data is entered and exit and print is selected, it doesnt print last record in the table

View 7 Replies View Related

Forms :: Navigation Form Printing Current Record Out As PDF

May 31, 2014

I have made a navigation form that prints the current record out as a PDF and also the option to send the current record by email as a PDF. Both work perfect when you open the form outside the navigation form. But when you open it inside the navigation form, it does not print any of the information.

The problem is in the Query report, In the criteria box for field [RequsetID] it has

Code : [Forms]![FRMRequestForm]![RequestID]

(The above works outside the navigation form.)

I have also tried adding the navigation form name

Code : [Forms]![Main]![FRMRequestForm]![RequestID]

But none work.

View 4 Replies View Related

Forms :: Conditional Formatting For Choices And Printing In Color

Aug 23, 2013

I have an access form that has a dropdown box list of 10 choices.

For example:

The form states please choose 1, 2, 3 or 4 then the choice should print in BLUE.

They choose 5, 6, 7 or 8 Then it need to print in RED.

So forth and so on.

I am sure there is a code I need to type in the conditional formatting area that would reflect if [1], [2], [3], [4] then I choose the red color.

I do not know how to use VBL or coding.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved