Print Report from Combo Box
Thank you for taking the time to report an issue.
What's wrong... Please write below.
DoCmd.OpenReport Me.cboSelectException, acPreview
Me.cboSelectException is the name of the report in the bound field of the unbound combo box. All works as it should.
Now the tricky part, at least for me is trying to print all the reports from the combo box. I thought I could add an selection in the combo box but I am clueless as to what the code might look like.
I also thought I could create a macro with of the reports in it and add some IF - THEN - ELSE code to make this work.
What I am doing now is I select the employee name in that combo box then I open the report and I use Ctrl+P to print the report, but in the printer selection I select “CutePDF Writer”Which is already installed in my pc and I print it as PDF and save that report with that combo box Value (Employee Name).
The combo box have 200 employee names and I am doing this process for each employees by selecting the names from combo box by repeating the process for 200 times.
Now this selection affects the address in a subreport just an . Why will it come up but wont print?
I have a 'welcome' form that has a tab control. One of the tabs is another form with a relitively simple intent: to select a report from a list in a combo box (with a OLE bitmap image of the report) and then either print or open in Preview, based on a checkbox.
The combo box recordsource is a table that has the title of the report. Also contained within each row of that table is a thumbnail image of the report and the name of the report in the Access database.
The idea is this: I select the report in the ComboBox. The form updates to show what the first page of the report is. I click a checkbox so that I can preview the report. I then click on a print button to make the report appear on the screen.
whats what I WANT to happen. I'm stuck at getting the ComboBox to update the form. I'll worry about the unicorn fart to do the printing tomorrow
I haven't used access in a while.I used to do this in my sleep now I can't do it with 8 cups of coffee
I have a Main form (Summary) that includes a subform (SummaryQuerySubfrm) which are linked together by ID.
I have a combo box on the main form which filters the subform by using the code below in the after update event of the combo box.
Private Sub SummaryMonth_AfterUpdate()
SummaryQuerySubfrm.Form.Filter = "[SubformField]= '" & ComboBox & "'"
SummaryQuerySubfrm.Form.FilterOn = True
I want to be able to print the current main form and the filtered subform the user has selected via a report (Print preview).
I am not sure how to pass the filter from my subform on my main form to the subform on my report.
At the moment when I select the print button on my main form, it brings up the print preview of the report however it does not filter the subform within the report.
What I would like to do is have the ability to pick from probably a combo box just one Account Name in need be and print that selection rather than printing the whole report.
Not quite sure how to set this up. Do I need to create the combo box on my form and have the control source set to the query?
And how do I get the report to accept the selected account name?