Hi Can someone point me in the right direction for doing the above? I have 3 reports, I would like to save all 3 into the same Excel workbook. Each on its...

I have a form that I set the SQL query to either if len(sParam) = 0 then sSQL = "Year=2007" Works fine I get all records for that year If len(sParam) 0...

How do I make a TextBox in a report show the number zero instead of a blank. Thank you beforehand.

After I run and then close a report I want a checkbox in Acknowledgement table to update...the table does show the checkbox updated. ....but after the report...

I have a subreport, and it previews properly. When I put the subreport in the main report, it shows the detail portion, but not the footer portion of the...

Hi, I have multiple headers in my access 2007 report. I have all of the contents of the DETAIL section set to Yes for Can Grow and Can Shrink. One of the...

I have a % utilization calculation I need to do in a report where the denominator is the number of hours in a shift * number of rooms * number of days. Yhe...

I am running Access 2007, and have the following problem. In my report's load event, a have the following code: If Me.Controls("txtProofReq").Value =...

I searched, and tried to utilize the answers I found, but I don’t have the skills to make them work. I have the crosstab query shown below which works fine...

Newbie Form / Report using code Question I am tring to generate a form with two combo boxes, using a 'Value List' as the source type and manually entered...

Hello, How I view crystal reports (.rpt) with access 2007? Nico

All, I have an inventory transaction table that houses all additions and subtractions of a particular part #. The inventory balance of the part # at any...

Good Evening: I have a report ("Invoice") which has 2 subreports, one for parts and the other for labor. When either has no data the calculations for totals...

I have a report with a bunch of unbound text box controls. The report is opened, and then I explicitly populate a few text boxes with data: DoCmd.OpenReport...

I've made a report titled HR Efficiency Report. This report contains the employee name, their pay rate and all of the information needed to calculate formulas....

I have a main report with 2 subreports in it. One of the subreports seems to be holding up the report when it comes to running and printing. When I run the...

Is it possible to print a PDF file from within Access 97?

Hello I am creating an Interview schedule report for the Faculty of Medicine Admissions. Before this year they did it by hand...but now that we have more info...

I have a record that contains multiple positions for names of individuals on this record. This record describes names of people involved in car accidents. ...

I have a report with a subreport. I am setting up the subreport to have grouping. However, I need each grouping to be started on a new page. Example: Report...