Access Report Headers
I have a problem trying to display a report header at the correct time on a report I am building in Access (2003). Lets pretend I have a report with 3 levels (cuz I do!!!):  Proposal, Supplier and Parts.  The report is for the Proposal.  It is grouped by Supplier and then has a subreport [...]

Answer Question   |  October 25, 2010  5:27 PM
Access 2003, Access reports, Header files, Microsoft Access subforms

Showing or hiding fields in an Access report
I have a db created for managing employee records. I would like to build a label report that shows or hides different fields on the label depending if a field has a value. The fields are Office, home address, city, state, and zip. If the member has an office location then i would like to [...]

Answer Question   |  October 30, 2010  10:08 PM
Access Database, Access reports, Database design, Database Development, Database management

Erro in Subform in Ms Access Reports
Hi All! I have a question that i have designed a report in ms access and I put a subform and linked it with the Party Group, I have put vb codes to use calculate some values if value on subform is null then VBA debug for error, I have used below all function but [...]

Answer Question   |  November 16, 2009  7:34 AM
Access reports, Microsoft Access, Microsoft Access subforms

Error 2282 in Microsoft Access
Hello all, I have a database that sends a report by email in pdf format automatically by pressing a button. My problem is that whilst this works perfectly on my computer, I get an error “2282 – the format in which you are attempting to output the current object is not available.” on other users [...]

Answer Question   |  October 6, 2009  4:26 AM
Access reports, Microsoft Access, Micrsoft Access reporting

Microsoft Access Audit Report
I have an audit with an “Action Taken” field and all of the fields in the original table. If the action is “Changed From”, the action in the very next line will be “Changed To”. I want the Audit Report to show ‘before’ and ‘after’ values for only those fields that changed, with all else [...]

Answer Question   |  July 14, 2009  8:56 PM
Access Database, Access reports, Audit Reports, Audits, IT audits, Microsoft Access

Access Reports to PDF file
Greetings, I have an objective that’s been driving me in circles…. Windows XP Office 2007 I need to figure out how to convert “multiple” Microsoft Access reports into one pdf file through vba. Access 2007 has easy way to convert one report at a time to pdf, however, I cannot figure out how to access [...]

Answer Question   |  June 29, 2009  7:22 PM
Access 2007, Access reports, Microsoft Access, Microsoft Office, Office 2007, PDF, VBA, Windows XP

MS Access Report modifications
I am using MS Access 2007. I am trying to modify a report and I want to delete the label in the page header section but not the detail field. I cannot find a way to detach the label from the detail field

Answer Question   |  January 28, 2011  7:03 PM
Access 2007, Access reports, Microsoft Access

Using Microsoft Access to create reports from MACOLA
Where can I get instructions on using Microsoft Access to create reports from Macola?

Answer Question   |  March 27, 2009  6:29 PM
Access reports, Macola, Microsoft Access, SQL Server

How can I print all picture attachmens attached to a record on an access report
I have a number of records that each have multiple attachments (pictures)> I have created a report and only the 1st attachment of each record prints on the report. Is the a way to have all the attachments print on the report for each record?

Answer Question   |  February 25, 2009  4:40 PM
Access Database Attachments, Access reports, Microsoft Access

Sending more then 1 Access Report to Outlook
Hi, I have 2 Access Reports which I need to send to Outlook as attachments. I usually use SendObject, but that only allows for 1 attachment. I am using Access 2007 Thanksyou Julie

Answer Question   |  February 20, 2009  1:00 PM
Access 2007, Access reports, Microsoft Access, Outlook

Problems with VAL function
I have a table with an NVarChar field that contains left aligned numeric values. I’ve tried using the VAL function to return the integer values, but I’m getting back Short Date results. What can I do to get integer results? Thanks, Arlin

Answer Question   |  February 17, 2009  4:33 PM
Access reports, Microsoft Access, VAL Function

Hide Header In Access Report
Hi, I have a report built in Microsoft Access that has a page header and a header for one of my fields named JobNo. Well, I wanted to know if there is a way to not display the page header with the jobno header? I know there is a way to not show the page [...]

Answer Question   |  December 25, 2008  10:12 PM
Access, Access reports, Database

Justified alignment in Microsoft Access
Dear Sir, I have put one memo field in Ms-Accees report. I want it to be printed like this : |……………………………….| |……………………………….| |……………………………….| |………………| Please reply, Thanks, Sandip

Answer Question   |  October 1, 2008  3:15 AM
Access reports, Microsoft Access

Access 2007 Report displaying the content of three different fields in one box?
I am creating a report in MS Access 2007. I want to create one box that displays the content of three different fields. i.e. Salutation First Name and Last Name. I used to do this in Access 2003 this way =[Salutation] & ” ” & [First Name] & ” ” & [Last Name] but in [...]

Answer Question   |  September 10, 2008  6:55 PM
Access 2007, Access reports, Microsoft Access, Office

Report Question-Is it possible to get a “new user” report when the only date is used also for date they used services?
Is it possible to get a “new user” report when the only date is used also for date they used services? The only fields in the table are Student ID, First Name, Last Name, Date of service and hours used.

Answer Question   |  July 22, 2008  7:49 PM
Access reports, Database programming, Database reporting, Microsoft Access

Sending MS Access reports in the body of an email.
How to send a report in MS Access to the body of an email in MS Outlook.

Answer Question   |  July 10, 2008  1:58 PM
Access reports, Microsoft Access, Outlook, Outlook 2003

Report -Conditional Format with multiple conditions: Access 2007
I am trying to generate a report that will change the font to different color if of a date field but the total number of days will change if another field = ?. So basically if [TYPE] = CHILD then DATE()-30= (red font), and DATE()-31 BETWEEN DATE()- 60= (yellow font) and DATE()-61 BETWEEN DATE()- 90=greenfont) [...]

Answer Question   |  June 24, 2008  10:39 AM
Access, Access reports, Conditional formatting, Conditional statements, Database, Database programming, Microsoft Access

MS Access – Count of parent table items in a report
I have an MS Access database with a parent table and a child table. Table A (the parent, an Order table) has a PartID field, an OrderDate field, and an CustomerID field. Table B (the child, Parts) has a PartID primary key field and a PartDescription field. A relationship joins the 2 tables on the [...]

Answer Question   |  January 18, 2008  8:43 PM
Access, Access multi-table reports, Access reports, Microsoft Access, Multi-table reports