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
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.
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.
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 ??
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.
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
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?
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
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"
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.
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.
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.
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
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).
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?
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
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.
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
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).
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