Reports

Want to print one record
I have access 2007. I had a person in our company's IT department design the tables & forms but that's as far as I got. Now I have numerous problems accessing information, one being the reports. So at this juncture, how can I print the information on 1 record? -- helpme ... 11 Mar 2010 15:44

Got it
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Dim ch As Object Set ch = Reports![Report2]![OLEUnbound0] With ch.Axes(xlValue) .HasTitle = True With .AxisTitle .Caption = "Revenue (millions)" .Font.Name = "bookman" .Font.Size = 10 End With End With En... 11 Mar 2010 10:03

Snaking Report with Fixed Columns
I need a report with anywhere from 3 to 5 columns across. I want the column headings (evenly spaced) to print with existing data (dates all coming from one field) first and then a bunch of blanks below for the length of the page, like so: TERR1 TERR2 TERR3 TERR4 ____... 11 Mar 2010 11:11

Testing with Access 2010
I'm currently testing an application under Access 2010 Runtime. The application is developed in Access 2003 and works under Access 2003 and 2007 just fine. As I anticipate that some of my users (there are over 1,000 worldwide) will eventually want to use Access 2010, I decided to run some tests. Anyway, I'... 14 Mar 2010 09:48

rows in a report
I have a text box with a number in it. How would I make that many rows in a report based off the number in the text box? Thanks in advance!!! ... 11 Mar 2010 01:19

Assemby Report
I have a report I need to create in Access 2003. The design has products that are made up of sub products (which can have sub products), how can I show the sub products by displaying them to the right of their parent products, almost like a tree view control on a form? ... 9 Mar 2010 20:23

Cancel = True - error
Hello All I have a number of reports where I have set the OnNoData event to Cancel = True. This works fine where the user attempts to open one of the report usign a button created with the wizard for that purpose, but if they click a button where the OnClick event includes lots of DoCmd OpenReport commands, when... 11 Mar 2010 11:11

Report header below page header
I want a report heading on the first page - but I would like it to be below the page header (so that my page header is identically positioned on all pages). Alternatively I want a part of my page header only displayed on the first page. How can this be made? -- Diane ... 9 Mar 2010 10:04

Group Header
I have a text box named "txtCount" and the control source it is counting tranches for each customer. I want this report to look at the highest number of tranches for each customer. So ABC company has the highest number of tranches I want that many rows for each customer. Can this be done? I was thinking in ... 8 Mar 2010 13:04

move fields independently
I'm trying to create a report with several fields...when I create the report, all the fields are smashed together horizontally. I can't seem to pull one field down separately, as all fields are connected. Is there an easy way to "disconnect" the fields? Thanks in advance... ... 8 Mar 2010 18:43