Hi, I am trying to set a Macros to export Reports to specified locations. I will be exporting these reports everyday, so I would the dates to automatically...

I am using the following code to make my pagefooter only appear on the first page of my report. Private Sub PageFooterSection_Print(Cancel As Integer,...

0.5862737 Check This Out ... 0.1523843 0.496778 Now Visit Tobacco Is Drugs 0.9520301

do not understand how to assign the report's record source as an SQL statement or a string variable in VBA, assigned in Report_Open. to date have only used an...

I have a 2003 Access report with an Unbound Object Frame linked to a multi-page Word document, which is a textual preface to a data report. The document...

I've read several post related to my question but haven't been able to apply the solutions that were offered. I have a subreport with the field labels in the...

Hi All, I have a hyperlink field in a child table in an Access 2003 database which will be used to point to electronic invoice files stored on a network...

I am using: ="Page: " & & " of " & in a text box on a report. When I run the report I will have only a 6 page report, but this gives me : Page 1 of 11 or...

Hello, I have been able to find info on auosizing text on a form but nothing on auto sizing text on a report to shrink it if need be to fit in a control that...

Since SP2, any reports that I have using the Arial Narrow font give a "There isn't enough free memory to update the display." error. If I create a new report,...

Does anyone know how to instantiate a report through the object model? I would like to open a report, change the printer, save the report and then print to...

I have a main report with 2 subreports , "subrptInternalTraining" and "subrptExternalTraining" This works just as expected. However, sometimes there is a...

I have a parameter form that asks for dates, as well as a system name to report on. If a system name is chosen, the report shows up displaying the current...

Hi All, I have created a beautiful multi column sub report. It has 15 columns...(yes I know!!). After fiddling with it, I finally got it to look the way I...

Thank you Duane for all your suggestions. A while ago you made this suggestion for a regular report. I'm just wondering if it's possible to use the same for...

I am trying to assemble a report which would use fields from different queries. Is this possible?

In 2003 my users were able to pull up a report and just click on the excel icon to export to excel. I converted the 2003 database to 2007. Now in 2007 the...

This is the VB code for two image frames on a report. The frames display an image of a location based on a site number, which is also the image filename. This...

I'm creating a report in Access 2003 where each record has multiple keywords I have assigned to the record. The parent records and related keywords are in...

hello, i have a report which has a header, page header & footer, and a group header (id num), and 4 subforms in the detail section. the problem is, if there...