I have a report that retrieves a value from a lookup table based upin the code in the primary table. That field (the lookup value) prints white on black yet...

I continue to have unexpected page breaks in a long report that is made up of nearly 30 subreports and several interspersed text fields. The report has...

Hi, I have a working make table query that has a date as one of the fields. Is there any way I can force the query to format the date as dd/mm/yyyy in the new...

How can a person (or even CAN you?) generate a line of detail in a report manually? For example, what if a person wanted to spin through a table using ADO...

I would like to sequentially number selected records shown on a report. I understand about adding calculated controls with control source set to =1, etc. ...

I'm not a newbie to this (my history in the Access newsgroups will confirm this) but now I find myself stumped. And incredibly frustrated - this shouldn't...

Hi All- I have been looking for a simple way to take the results of a parameter query which are displayed in a form, and view/print them in a report via a...

I have a report with a subreport. On the main report is a text box with the following IIF statement for its control source: =IIf(..,"______",Null) It was...

I'm trying to prepare a report grouped by Area, Profession and Days of the week, with employees and employee hours for each day of the week. To make the days...

Hi There, When I use ExportXML method to export a report based on a query having criteria which references a form, the parameter dialog appears. The form is...

I have an access form with a "View Report" command button. the button click event has docmd.openreport "reportname",acviewPreview. It works fine on the PC used...

Hi Apologies posted this before without a subject! Have a couple of combo boxes on a report. Is there any way of allowing them to expand, perhaps...

Hi I have a couple of combo boxes on a report. Is there any way of enabling these to expand, perhaps programatically, similarly to text boxes with Can Grow...

I have a user who has a printer that will print on both sides of the page. My program generates statements of donations by church members that may be any...

hi i have a report which displays a customers name chosen by user at prompt when report is ran, the total cost column is there along with name, date, ref,...

This is a little tricky to explain so I will do my best. Where I work we utilize our database to mail out 2,000+ newsletters every month. We recently cleaned...

I had a database of 2800 DVD' titles and 5 libraries with their individual holdings. In Access 2000 and 2003 there were no problems. Then came Access...

i have a report which contains two subreports - subreport1 and subreport2. subreport1 has a textfield1. subreport2 has a textfield2. i want to show...

I have a series of nested queries processing thousands of student results from two different assessment times (shown by the set code) that finally end up a...

Hello I have the following problem In a access file i order spare parts for my machanics. The mechanics can, whit a checkbox, tell me wat part i must...