I have an Access 2003 report with multiple columns in the main report section and in the subreport. The main report section is printing properly with snaking columns, but I want the same snak...
I am making an Access database for a friend of mine, and I have a question relating to reports. As you can see in this screenshot,
http://www.thinkwelldesigns.com/Graphics/AccessQuestion.jp...
There are 2 questions I want answered.
1) I have a report which has several sub-reports within it. I want each sub-report to begin on a new page.
2) In one of my sub-reports I want to sh...
is it possible to have a report print to a certain printer and tray....
for example
docmd.printout
use specific printer = \\servername\printername
source = tray 3
thanks benyaw
records that microsoft access was unable to paste have been inserted into a new table called paste errors
I have form that is used to add training activities that an employee attends or does. I want to create a subform on the form that lists all the past dates of traning and counts them like thi...
I have a 'pre-formatted' MS Access Report with 3 Grouping Levels. Initially these levels are EACH set to a field in my Query (the Query is being used as the Record Source of my Report). Appa...
I need to filter date values to show only weekends.
Hi,
I need to line up my report with a horizontal and vertical line.
But I have a control box with a property of able to increase = yes
Which means that the vertical line will be short on ...
Hello,
I am trying to build a report that compares the weekly total number of parts shipped against customer order quantities.
I have a SELECT query that contains all relevant data: Cust...
I have an Access report with field that are sometimes empty. How can I keep them from printing when there's no data? Seems like there'd be a setting in the text box of the field but I can't f...
I need to limit my details on each page of my report with out losing my Group footer. When I used the suggested solution that was out there.
Private Sub Detail_Format(Cancel As Integer, Form...
Hi,
At the top of a report i have a field named: "ABSENCE_REASON" the control source data for this field is from the reports query, in the query this field is based on the selection made by...
Hi,
In Access I have a query which accepts a start_date and end_dat. To open a report that is based on this query how do I pass in both these dates from a form. See the code below on how far ...
My Access report is grouped by Hospital, then by Name. There can be more than 1 record per person in 1 hospital. I want to count the number of people per hospital (not counting the multiple re...
i have this code that genarate and print a pdf from Mss Access report and save in a folder called report
the problem is every time i try to print the report it will show a save dialog which ...
Hello, I've got a little Macro that prints 8 reports one after the other, however my user wants to have them in one Excel Spreadsheet, with individual tabs for each report. Is there a way to...
I'm new to Access 2007 and am using it to upgrade a wholesale/stock control system. Orders to suppliers might or might not involve FOB charges or agent commissions. I have placed these values ...
Hi,
I'm writing reports in Access, using outer joins in the query that the report is based on. This means that some fields will be blank for some records, as there is no data there.
The ...
I have a report that is based on a composite query that requires a parameter. I want to be able to open this report from a form and pass that parameter programmatically. From what I've seen,...
I have a couple of reports. They require parameters in order for the query to run.
Right now they popup your standard messagebox per parameter asking for start and end dates or the name of...
My Access pie chart is flaky. If I batch report hundreds of reports the pie chart eventually stops printing. I've created a bar chart using colored rectangles and code to reproduce the chart...
We've been printing multiple copies of a Word Document on 4in X 2in labels on a Zebra LP2742 label printer and the labels print without pausing after each label printed. Now we're printing...
Sorry,
i feel very confused I am bad I have zero points in software building and if I find not the solution for tomorrow I can be rejected from the firm.
Capricorn 1 gave me the solution f...
I need to format dates for letters/reports into the format:
19th September, 2008
Ideally the day would be minimised to one digit if necessary (eg 8th and not 08th)
...
