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()
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
I'm trying to create a report that prints out results of a filter by form search.
I have a form, frm_account, which displays data from tbl_account.
I have a select query, qry_filter_results, which I want to take the filtered results from frm_account.
My problem is that I don't know how to take the results from the form. Is it a parameter in the query? Or is it the criteria fields? I've tried a couple things in the Expression builder for the criteria, but each has failed. I either get a report with nothing in it or a report with every record in tbl_account.
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?
i have some combobox which shows the column shown into the subform. i can filter the subform using the comboxes. now i need to build an instant report based on the current filtering. i can filter more or less. but i need the current position of the subform into a report.
I want to open a report with the results from a filtered form.
I want to use a similar format to the attached Allene Browne search2000 as the base to filter the records initially, but not sure how to get the filtered results into a report and the most efficient way.
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:
(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've done this once entirely by accident and can't seem to duplicate it...
I have a report. It has the following:
Report Header: Logo and title Department Header Supervisor Header Group Header Detail Department Footer: Totals Report Footer: Overall Totals for all departments
Here's my question. I have combo boxes on my main form that filter this report. The combo boxes are referred to by the query that runs the report. How do I get proper unfiltered overall totals in my report footer?
I have a report that is opened via a Form that lets the user choose a date to filter the report. The report opens in Print Preview mode.
What I'm attempting is to give the user an easy way to export the report once they've verified the report is accurate.
One way I've tried to do this was to use the OnClose event to execute a vbYesNo MsgBox giving them the option to export. The problem here is that I can't do the export while the report is closing.
Code: Run-time Error '2585': This action can't be carried out while processing a form or report event.
I tried to move my MsgBox to the OnUnload so that could cancel the Unload, but was met with the same results.
Code: Private Sub Report_Unload(Cancel As Integer) Dim Response Response = msgbox("Do you want to save a copy of this log?", vbYesNo, "Export to PDF") If Response = vbYes Then Cancel = True DoCmd.OutputTo acOutputReport, "rptWatchLog", acFormatPDF End If End Sub
Some research indicates perhaps the DoCmd.OutputTo is happening to quickly. Would including some type of pause in the code execution between the Cancel = True and the DoCmd solve my problem? Though frankly, even if it did it doesn't feel very elegant. I also recognize that I'd need to reinitiate the Unload>Deactivate>Close process after the export completed.
I initially began by having an Export Command Button on the form they use the choose a date, but was unable to have the exported report honor the user supplied filter from that form.
Here is the code from that form that is applying the filter:
'Open Watch Log Report with chosen date as filter Private Sub cmdOpen_Click() 'use date even though it's not saved anywhere If Me.Dirty Then Me.Dirty = False
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).
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?
I have a drop down list on a form that prints a report based off of the selection in the cbo box...
(I have already changed the query and relationship for the lookup and maintable)
Here is the code that works fine,(this is on a command button)
Private Sub cmdViewStreet_Click() stDocName = "rptStreetName" On Error Resume Next DoCmd.OpenReport "rptStreetName", acViewPreview, acEdit Me.cboStreetName = Null End Sub
What I am doing now.. is this: the look up table that had the street names but did not have an autonumber or primary key. I added in a autonumber and primary key. I can get the cboStreetName to list the street names and not the autonumber.. and I can get the main table to store the autonumber not the street name (this is what I want).. but now I can't get it to view what is in the cboStreetName... When I hit the view button it does nothing... Any suggestions?? If you need more info please let me know...
I tried something like this to:
Private Sub cmdViewStreet_Click() On Error GoTo Err_cmdViewStreet_Click Dim stDocName As String stDocName = "rptStreetName" DoCmd.OpenReport "rptStreetName", acPreview, , "[StreetName]=" & Me.cboStreetName.Column(0) Exit_cmdViewStreet_Click: Me.cboStreetname = Null Exit Sub
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?
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
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.
Having a problem with a report, I have a form that i use to enter a new record to my database, what I want to do is put a button at the bottom of the form to print the record (via a report)
If I base this on a record that already exists, it works fine. However, If I have just entered the record the query the report runs off doesn't see the new record. To print that record I have to exit the completed record, then go back in to it and print. My aim is to remove this additional part of the process, I'm sure it's something really simple, but can anyone help?
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.
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.
I have created a form with an option group with 4 options (date, line, description and observation). Each of these options are to be a sort order for a report that will open after the user selects an option and clicks a button. I am trying to code the button using a select case so that case 1 opens the report sorted by date, case 2 by line, etc. how to write the code for the sorting.
I am using the Navigation form and I have a tab that has all the sales quotes for a particular salesperson. Because my salespeople like to work with paper I have created sub tabs which contain a report with the same information but filtered based as follows: this Month, this year, and Last year. This report needs to be printable based on the filtered information so I created a print button within the report however when clicked it prints the entire report not the filtered report.
The filter criteria is located in the navigation button, navigation where under the data properties. I have the on click event of the button set to open the report in print preview but I need to know how I filter the where in the macro to read the criteria from the active navigation button property?
I have a report with a table as the row source. I have command buttons that opens different forms and allows the user to choose criteria, the form then filters the report based on the chosen criteria in the form, but if I use the destination city form to filter the report by destination city, then filter the report using a different form, the destination city filter is lost, is there a way to filter the report with a form by say destination city, then further filter that dataset with another form for say location city.
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.