Reports

One Command button for different reports
I have five different reports called 'Cooling, Electric, Gas, Heat Pump and Oil' I would like to create a one command button on a form called 'Contract', that based on two fields on this form, called 'ContractNumber' and 'ContractType' will generate the specific report. The ContractNumber is unique (primary ke... 30 Jun 2008 18:55

How to put "order details" on top of report?
In my report, I have my order details in the middle of my report under the details header. I would like to have the details to be on top of my report as well. I tried putting the details onto the report header, but it only shows the first item in my order details. How do I put the all the items in my order details ... 2 Jul 2008 09:50

Listing cases with no data as zero, and then calculating a total
I'm putting together a service database where I keep track of engineer's service time, and I want to have a monthly report that reports all of the service time by individual engineer, with totals grand totals at the end. My data is setup with a table of all of the engineers and a table of service tasks. My fi... 29 Jun 2008 20:21

Hate Your Job?
Do You Hate Your Job? If You Are Like Me And REALLY Hate Your Job, You Can Do What I have Done And Tell All About Your Company At A Great And CHEAP New Site Called Dont Work For These . Com http://www.dontworkforthese.com This Site Has Chat Rooms, A Joke Section, A Great Story Section Where You Can Tell All Th... 29 Jun 2008 06:02

Report Margins Not Holding Configuration
I have a simple one page landscape report with 1/2 inch margins top and bottom, 1/4 inch margins left and right. They print just fine when set up but do not hold these margins and orientation for he next time I enter the database. Reports are saved with the new margins but it changes anyway. I have several r... 29 Jun 2008 21:22

Exporting Reports in PDF/A format
Hello All, I currently wrote VBA code to export an access report into a .pdf file, however I need these reports to default in a PDF/A format, and we're trying to avoid using a third party application if possible. It seems that with other office applications you can do this through the ExportAsFixedFormat me... 7 Jul 2008 12:30

certain information on the same page
I have a report which does not have group but has subreports. I would like to have some information on the same page. I know that I can have keep same group on the same page. Are there any way to have ungroup reports information keep in the same pages? Your information is great appreciated, ... 28 Jun 2008 12:42

Printing to PDF with Acrobat Installed
Hello, I have researched this unsuccessfully for about two hours, going to post here to hopefully get some help. I have read some of the posts and found some solutions that would not work for me, especially Mr. Lebans code. Every user that might create these reports will have Acrobat installed and there... 27 Jun 2008 20:23

Calculating averages
Access 2003 Using the following formula:=DateDiff("d", [Date In], [Date Completed]) I have calculated the number of days it takes for repair on a particular model. I'm having a problem creating a control that will give me the average # of days it takes for all repairs. I have a grouping level of Model's so I... 27 Jun 2008 17:18

multiple pages for record
I need some help. Currently I have each record print on an individual page with a large picture on each page. However, some records have 2 pictures and I need them both to print. they can be reduced to fit on one page or pushed onto a second page, but i can't figure out how to do either. ... 27 Jun 2008 14:13