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...
In Ms Access report, the maximum allowable 8.5 x 14 margin settings for my printer are:
Left = 0.25
Right - 0.25.
The Top and bottom settings seems to be okay.
The left margin is also ok...
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...
Is it possible to create a rectangle on a report and put a gradient fill in it?
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...
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 ...
When I use a report it sorts entries that are entered in manually from the table first over the entries entered in via a form that is written to the same table. Why is that? It all appears ...
The code below works well over the entire data set but how do I restrain it to do the calculationin a particular date range? With a paremeter definition? and how do I get the parameter to app...
I am creating a form in MS access, I'd like to put a button on the form which will e-mail a report to the "relevant people."
I found a button in the tool box and if you click on reports the...
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 ...
As i am working with crystal reports i need to set the page width as my web page design.
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,...
Hi experts! I have an access report -- actually an invoice that I generate and email to clients. I chose to create this in snapshot format - and it looks beautiful. recently I had a client s...
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...
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)
...
hello experts, i need help on creating a report that would display multiple groups into one record. For example I'm creating a report that shows employee demographics within a location. So t...
Hi - I'm using the attached code (which I found here) to create a table will serve as a TOC for an access report. I created it in the Northwinds sample db with no problems, but when I try to ...
Hello... I have a query that I am trying to pass a value from a combo box to it. I was able to do this with dates from a textbox into the query with the help of Peter57r (expert).
Here i...
I have a table that has 10 different check boxes for various options. I need to create a report that shows the total number of times each check box is selected. Some records can have multi...
I have a report that prints invoices for multiple clients. Each invoice can be one or multiple pages. I want to print remittance information on the bottom of the last page of each invoice. ...
