I have a form and a report that are almost identical. I want to create a button on the form to allow me to print the report. So say I'm on recordID 15 when I...

Hi all, I hope you can help me with this one as our db admin person has left. I have a SQL backend with a ADP frontend. Within the frontend i have set up a...

I have a report that takes an argument "OrderId". When the user opens it from the access client file, he is prompted for it. That's ok When I open it from my...

I have a report that has a Group Header, but no page or report header. However when I print preview the report the first page only has the group header, the...

I copied the following code that was posted last year. This is a difficult situation. I can only come up with one way to get that effect and it requires...

Hi, I want to print terms and conditions on every alternate page. An aggreement report consists of the client details and items that comprise the aggreement....

In a report by the wizard in 2007 is it possible to change the width or heigth of the page header 'boxes' without changing the detail items. When the report...

Hi, is there any way in a Report to customize the date displayed in the report to be mmm/yy? Or even mmm/yyyy would be better for me than the options Access...

Hello all, I have two questions. What does the "#error" error mean? In Access 07 I have a report that, when print previewed, gives me the #error in the...

I have a DB that has started being used by many different departments of the company I work in. User input has shown that almost every area that looks at...

I have an one line subreport based on a table that will on ocassion, not have a row. I wish to place a 0 in the fields if there is no row returned. What's...

I have a subreport which contains headers. How do I have the subreport headers show up when placed in the main report?

Would someone show me how to center vertically the text on label please? I open the NAME’s property box and set the "Text Align" property to "center", but...

Hello, I have several reports based on simple select or select w/WHERE queries. Can anyone tell me how to add a count of the records on the...

In my report, I cannot have more than 99 records in a group. I have set up a counter but I can figure out how to force a new group and page once the counter...

Hey guys, I have one report with a set of data like id,id2, text,text, price (cca. 100 rows, 4 pages). Now I would like to add to that same report an another...

I have a report that must have a disclaimer on the back of each page (no data just verbage). Can someone tell me how to set this up please. TIA for the...

Following on from my recent "RecordCount" thread ... I have an unbound report which contains two subreports. I've used the method suggested by Al to count...

Hello, A couple of days ago I posted a similar question, but I will try to include some more details this time. If I need more detail to clarify what I...

Hello it's me again, Something stroke my mind for the last couple of days and what i am trying to accomplish is to have a report that the user will pick...