HI is it possible to publish a report to excel, without showing the preview window ? currently i go DoCmd.OpenReport report, acPreview, ,

Introduction: This is similar to a posting I have in the Database group. I tried to post to two usenet groups for this question, but that did not work. The...

I am trying to count the number of reports were sent before 4 pm each day. If the time difference between 4 PM and when the report is sent is greater than 1,...

I have a report which has fields in the header and a field in the detail. How do I keep the fields in the header with the detail together for each page. ...

Hi, I have a report that contains 2 sub report. Every thing is fine except that the ReportFooter is not appearing. When i try to run the subreport by...

I have weekly revenue data in a table AND create a Pivot Chart. It shows the original data. I want to add a 6 week moving average as a separate line on the...

I want to print records from a table onto 5.5" x 4.25" cards. I have Avery product 3381 which is an 8.5" x 11" sheet prescored once down the middle & once...

Hi everyone! Using A02 on XP. We have some cd mailing labels that are 6 to a page sized 4 3/16 X 3 5/8 (no spacing). We often have to print a label for...

I would like to created a simple calculation in my footer's text box but I suspect that I'm missing an obvious roadblock somewhere. First of all, the Build...

HI all, I am trying to sum the total of three fields in the report header. Seems easy enough and I understand how to do that in a typcial situation. But,...

The following statement is populating a key field in my report. What I am attempting to do is when the report startdate does not match the date in the...

I'm creating a report of 18 fields into a report that I'd like to organize into stacked boxes/grids about 2 1/2" by 2 1/2" In the report when creating the...

Hi, I have a table with fields: Title, Description, etc. I also have a report where each record in the table prints a new page with the information from each...

Gina Thanks again for all your help I am about to visit the machines with 2003 clients and do what needs to be done to protect them from the evil SP3 I...

Hi. I think I have a syntax problem I’d appreciate some help with. I have several reports and I’d like to use the data from them to populate a Summary...

We have Access 2007. I've created a Labels report, for simple Avery Return address labels, 8167 (template 5167). The very first label prints perfectly, but...

..EmpName = strNameI am populating an unbound text field in a form thru VBA. Code is : While Not rs1.EOF strName = strName & rs1!Name & Chr(13) & Chr(10) ...

I have a report that uses conditional formatting to shade controls It runs without problem on access 2000, 2002, 2003 and 2007 Two 2003 clients have problems...

I am trying to create a form that will allow the user to filter the contents of a report by up to 6 fields. (Theme, Sponsor, Site, AcctExec, Advertiser,...

I want to create a multi-tiered report that's formatted like a treeview. I have items that belong to classes, and the classes can belong to other classes. ...