Reports :: Printing Report To PDF File Via Button On Search Form?

Aug 7, 2014

I'm building an application to record engineer input in Events (jobs) for an engineering company.

My main tables are Products, Builds and Events, together with fifty or so reference and ancillary tables which aren't really relevant to this particular head-scratcher.

A Build is derived from a Product and an Event is applied to a Build. An Event includes a sale, a service, a warranty repair and so on. Over time, multiple Events will be logged against a Build.

I have a searchable Events form (Search_Events), containing a subform (Search_Events_sub) whose contents dynamically change to reflect data entered in a variety of unbound fields in the main Events search form. Needless to say, the glue that holds things together is the Event_ID field.

On my Search_Events form, I'd like to place two buttons (Rpt_Event_client and Rpt_Event_internal) which will allow the user to print either a client or an internal copy of the event in question. The reason I want to use separate buttons rather than one button for both copies is that it's quite likely that different engineers will work on different parts of an Event's build, test and sign off process, and will want to print off and annotate the internal report, whereas only the final report will be sent to the client. Also, there will be some slight differences between the visible fields on each report (time and materials logged etc).

So far, I've managed to get the Rpt_Event_internal button to open the relevant Event report in preview mode, using the following on the button's 'on click' event:

DoCmd.OpenReport "Rpt_Event_internal", acViewPreview, "", "[Event_ID]=[Forms]![Search_Events]![Sub].[Form]![s_Event_ID]", acWindowNormal, ""

(In the subform, Event_ID is referenced as s_Event_ID because I'm using an nZ function in most of the search fields so that the results filter dynamically)

So far, so good: this works fine. However, from a usability perspective, and based on the fact that this will be the most-used feature, I'd really like to be able to have the button do the following:

- print the relevant report, based on Event_ID as above to a PDF file

- synthesise the filename of the report along the lines of "Event_" & [Event_ID] & "_Client_Copy_" & [Date()] & ".pdf"

- and to then have the standard 'save as' Windows location browser/file explorer dialogue box appear so the user can choose where to save the file. I don't want the filepath to be hardwired, rather I need the users to be able to decide where to save the file.

I'm using Access 2013.

View Replies


ADVERTISEMENT

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 Report Based On Filtered Results Of Form

Jun 26, 2013

I am trying to print a report based on the filtered results of a form where the data record source is generated from a query. What I have is five unbound comboboxes on a form that filter the results of the query on a subform which works fine in whichever combination I set, I then want the report to print out the results of the filter and the filter combination that I used - basically exactly as it appears on the form (I have used the same query / subform in the report with text boxes to show the filters used on the form). My VBA skills are quite limited (but improving!) and I have trawled the web trying different code examples but can't seem to get it nailed. Current filter code follows;

Code:
Option Compare Database
Option Explicit
Private Sub PrntConfigReport_Click()

[Code].....

View 3 Replies View Related

Reports :: Printing Multiple Reports From One Button

Apr 23, 2014

I have a form that produces Year end accounts, therefore each page is totally different from one another, there are 10 reports per set of accounts.

I have created 10 buttons that out puts the desired report

Profit and Lost, Balance Sheet etc.....

What I would like now is a way to print all 10 reports with the click of a button, how can this be done...

View 7 Replies View Related

Printing A Report Query Using A "print" Button On Form

Mar 7, 2008

Hello everyone,

How can i have a form with a "Print" button on it for print a report instead of going to file, print?

I will appreciate if a sample of such database can also be attached.

Stay well.

View 6 Replies View Related

Modules & VBA :: Calling RDL File To Generate Reports From A Form Control Button In Access

Dec 2, 2014

So Access was unable to manage the amount of content that I needed to produce in a single report. The reports contain 12 charts/graphs all of which I needed on separate pages (one chart per page). As such I could not create large enough charts in access to fit to each page, as Access limits the amount of space one can use in a report.

I downloaded Microsoft Reports Builder 3.0 and built my reports as needed and can generate them as desired at current. I'm wondering if there a way to call that RDL file I created to generate my reports from a form control button in Access?

View 3 Replies View Related

Reports :: Button To Launch A Form From A Report

Mar 1, 2015

I have a fairly simple report which lists rows from one table with a little bit of logic. At the end of each row, I want an action button, which when you click it, goes to a form with the correct ItemID for that row.I tried the VBA code like this on the View button on click method:

DoCmd.OpenForm "CreateCAF", , , "[ItemID] = " & Me.ItemID

Of course, what happens is it opens the form CreateCAF with the first ItemID in the report, regardless of which row you click on. I want it to pick up the ItemId of that row.

View 13 Replies View Related

Printing Report Setup Button Not Working

Jul 22, 2014

I get an error message when I click the setup button in the print dialog window.

View 10 Replies View Related

Reports :: Set Record Source Of Report From Button On Form

Jun 13, 2014

How can I set the record source of a report to a saved query through VBA. I am trying to use the same report for a number of uses, all of the info on the report is the same, but the only difference is the query that the information is based on. I have this simple code below, how do I add a record source to it (if it can be done)

DoCmd.OpenReport "SellRPT", acViewReport, , , acNormal

View 2 Replies View Related

Reports :: Sub-report Not Printing

Jan 13, 2015

I have a report with one sub-report. It previews correctly and prints correctly from my ACCDB. However, when I create an ACCDE, the sub-report previews correctly and then does not print. I have tried the following and none work: In the main report, deleted the links and changed the subreports record source.

Changed layout for print to no
Changed filter on empty matches to no

Moved everything from detail to page header.When I put code in the subreport to set a flag when loaded and queried that flag in the main report, the subreport never admitted to being loaded when run from the ACCDE (again works fine from the ACCDB).

View 4 Replies View Related

Reports :: Printing Into Pdf From A Report

Mar 1, 2013

I'd like to print out a report so that each record should be printed into an individual pdf file. When printing manually, record by record, I use an app called cuteprinter for converting reports into pdf. But that one needs saving path for each individual pdf file. What could I do if I'd like to make a series of record printing? Would there be a way of automatic generating path and file name for each record's print?

View 1 Replies View Related

Reports :: Automate Printing From A Command Button With Selected Data From A Query?

Jul 15, 2013

How can I automate different printers for different reports on the same MS Access 2007 database, without having to select the printer each time?

There are two reports that are printed on the same database. Previously, I had automated form buttons to print the reports, without having to select the printer each time. This was about 8 years ago, but I don't remember how I did this. Also, I don't know SQL. Nothing against code, but I did not know how to program, and just MS Access 2007 access itself.

View 6 Replies View Related

Reports :: Using Command Button In A Form To Filter And Open A Report?

Jun 26, 2014

I'm trying to use a command button in a form to filter and open a report. I am able to get it to open the report, but I cannot get it to filter the report based on a combobox in the form. I've tried every combination of code I could think of and find. Here is what I currently have:

Code:
Private Sub FilterReport_Click()
DoCmd.OpenReport "Report", acViewReport, "First Name='" & Me.FName & "'"
End Sub

Code:
Option Compare Database
Private Sub Report_Open(Cancel As Integer)
Me.RecordSource = Me.FName
End Sub

"FilterReport" = Form Button
"Report" = Report
"First Name" = Report Field
"FName" = Form Combo Box

View 14 Replies View Related

Reports :: Printing A Signature On A Report

Feb 10, 2015

I have an application where I have some users in the field with tablets and they deliver a package and the receiver will sign for it (like UPS or FedEx essentially). They sign my application and then the application saves the signature to a SQL Database in binary data. I'm using the Microsoft InkPicture ActiveX control to achieve this. After they sign, I have a line of code that equals:

Me.RecBySignature = Me.RecBySig.Ink.Save

This works fine and I can also recall the signature to the form when the form is re-opened.how to do is to put the signature on a report. Is there a way to "draw" the signature on the report? Or to print it to the screen?

View 1 Replies View Related

Reports :: Printing Report Between Two Dates

Jun 1, 2014

Any code for viewing Report between two dates. So when you open the report it will ask for the starting date and ending date.

View 4 Replies View Related

Reports :: Report Not Printing Image

Oct 22, 2013

I am trying to have a macro button so when I click it it Emails to a particular person but also prints off a copy.it all works fine but for some reason it wont print the image off, my macro is as below

RunCommand - Print
SendObject - Report, RPTDailyReports
Close - Report, RPTDailyReport

when I do CTRL + P and put the print quality up to 'Super' it prints fine

View 4 Replies View Related

Reports :: Printing Report Without Duplicates

Aug 4, 2015

I have a report that comes from a query.

On the report I use the group function on a field called assemble part number and select no duplicates in the property field . so I don't get that part number on every line below that group.

When I print the report it gives me the assembly part number on every line can the report be printed without it on every line just the group line.

View 1 Replies View Related

Reports :: Printing Serial Numbers In Report

Nov 21, 2013

I have a table that has a field for SerialNumberStart and QtyRequired, from those two I have a calculated field for the SerialNumberEnd.

I want to print a report from this table that if for example I have StartSerialNumber 34 and SerialNumberEnd 40 prints one report for each serial number.

View 4 Replies View Related

Reports :: Expression Too Complex When Printing Report

Jun 8, 2015

I have an Access application that print a report with 7 sub-reports in it. When I preview the report, it looks fine. When I print it directly to the printer, it looks fine. The problem is when I print from the preview, Access error with a "...too complex..." error and crashes the application.

View 8 Replies View Related

Reports :: Printing Report From Subform Control

May 30, 2013

I'm using access 2003

I've successfully printed a report from a main form control and now I'm trying to do the same with a subform control.

I'm using a query to filter the report, with the criteria of:

Code: [forms]![MainForm]![Subform].[form]![textbox]

Is there something I'm missing?

View 10 Replies View Related

Reports :: Printing Filtered Results That Have Set In Report

Aug 5, 2015

I have a database with some reports that show all records in a table. Some users want to only see certain rows, so they use filter option (clicking in the field, and using the funnel symbol feature at the top.

I have a print button, but I had only set it to print the report name. So when a user filters a report and clicks print, it still prints every record, instead of the filtered results that they have set.

How can I alter my VBA code for printing so that the button prints whatever results are shown? I don't quite understand how Me.Filter works, so every change I try still prints everything.

Right now its just back to

Private Sub btnPrint_Click()
DoCmd.OpenReport "ALL REQUESTS", acNormal
End Sub

View 6 Replies View Related

Reports :: Each Event Report Printing On Separate Page

Dec 3, 2013

I have a database of musical events. Now im creating flayers for each event. My Q is how the Information for each event should fit on one A4 page and should start on a new page of the report.

View 2 Replies View Related

Reports :: Printing Statements For Clients - Different Formats Within Same Report

Aug 5, 2015

I am printing statements for clients. Depending on certain criteria about the client, the format of the statement changes completely. This is just how the boss wants it, I have no control. I still want to generate all statements at one time (not separate reports).

I currently have this working using multiple subreports, and changing their Visibility property, only one being visible at any one time. This works, but it is very slow, I assume because I am basically making Access do triple the work (I have 3 subreports).

I pretty confident this is not the intended use of subreports. Is there a "correct" way to do what I am doing? I know I could just manipulate everything with VBA, but having subreports makes editing the different formats very easy.

View 10 Replies View Related

Reports :: Settings To Avoid Printing Report Column

Nov 13, 2014

I have a report that fits nicely onto one A4 page.

Then I had to add an ID column to be able to sort by ID (would not sort by ID unless I added the column to contain the record ID numbers, even though the query on which the report is based is sorted by ID).

Because I added another column (on the right hand side) to contain the ID column, it's gone over the A4 size and so prints a second page with the ID column on it.

So I hid the ID column, but a second page still prints, just with nothing on it.

I don't want to shrink any of the columns to make the ID column fit as the report is crowded already.

I tried setting the ID column header and content to Display When: Screen Only, but that doesn't work, it still prints the second blank page.

How can I stop that second page printing? I don't want to just print page one as sometimes the report is more than one page of data.

In Excel you can set the print area. Is there a similar setting in Access? I can't find one.

View 2 Replies View Related

Reports :: Printing Filtered Pivot Chart On A Report

May 23, 2013

I have created a database that tracks production by individuals. I have also created a report which includes a pivot chart to give the user a chart view of production.

In the pivot filter of the chart I have associate names, where the user can click all, or individual associates, to see individual production.

The trouble I am having is when the user goes to print the chart, it will only print the chart with the "All" filter view. Even if the pivot chart is filtered to one associate, it will print like "All" was checked.

Is there a way to allow the report/pivot chart to only print the production for the individual who is checked within the pivot filter?

View 4 Replies View Related

Reports :: Chart Report Printing Additional Pages?

Oct 1, 2014

I've got a report, which on the screen is three chrts and a page break in between. Page is set up to print landscape.

When I print the report or save to pdf it adds a lot of pages in between 2 and 3. It seems to be of chart no.2 getting smaller and smaller. I've attached a copy of the pdf so you can see what I mean.

its doing this on all my reports.

View 7 Replies View Related







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