I have a main report with a unbound sub-report. How can I pass the WHERE clause used to filter the Main report to this sub-report? Thank you, QB

I'm trying to create a set of variable of all the fields in a table . This information will later be used in formatting the detail section of the report...

Hi When I transfer a report from Access 2003 to Excel 2003 a column in "text" became "number". Ex: the column "code" 00345 became in excel "code" 345 Could...

I have just moved to Access 2007. I cannot get any page footers on reports, to print at the bottom of the page. They print immediately after the detail...

I am working on a Budget Database, so I have 4 subreports linked/embedded on the main report. The problem I am having is when the subreport does not have...

Can somebody please help me? I need to set up a sort of "Table of Contents" in a access report where I want to list the headings in the report and indicate...

The following code is used to place a number in front of a record on a report: Private Sub GroupHeader0_Print(Cancel As Integer, PrintCount As Integer) ...

I am using Access 2007 and I have been tasked with creating a query to produce information, and for the life of me, I cant figure it out...maybe you can. We...

I have created individual Inventory reports for different facilities that we are responsible for. In the Report Header I have a sign off sheet etc. that I...

I have an inventory report that has a running sum set up: Date Requirement Type Quantity Available Qty 6/29/09 Intentory Balance 27,746 ...

Res. All I am trying to use the acolecreatelink method on bound object frame in a report. It is giving error and not allowing this. Why? What is the...

Hi, I need a report to print on 11x17 paper, but I want to set the report width to 12.5" (footers have non-white background color, and I don't want the color...

I need to modify the output of one of my reports. This particular report contains 3 sub reports. How can I reference information using criteria contained in...

Is there a cionstraint on the number of records a graph can display? My Row Source query displayed below gad ~6800 records, but only ~2/3 of the data are...

When using a page break in the group header is there any way to avoid getting a blank first page. -- Rose

Thanks for taking the time to read my question. I wrote some vb script that goes through our server and finds any files that are larger than size n and writes...

Why does Access stop responding when I map a report field to a a linked table. I have a report and I am changing the field on a report to a new Control...

I am listing a file whose records contain the fields "Item Number" and "Description". When the program encounters a record that has a blank Item Number or a...

I have multiple tables in Access that have the same form/design (in terms of columns and rows). I want to be able to create a report in the following way: I...

I created a pie chart based on a query. Then I set it up so the first data series was green, 2nd blue, 3rd yellow and 4th red. However, I just noticed that...