Reports

Blank page in middle of report
This has just started happening to all my reports. All of a sudden, there will be a blank page in the middle of a report. What is causing this? ... 25 Mar 2010 20:55

Using Code instead of Criteria
In my query builder, I'm getting the message: "The string returned by the builder is too long. The result will be truncated." I think I understand why, as I am using a form to specify a large number of options for the report. Can I use VB to specify these criteria instead of the query builder? Examples in ... 23 Mar 2010 09:00

syntax for count text field
Hi, I have a report bound in qryVendor in this query I have a fieldname: Stat with expression type Stat:IIF([VDB]=[TlVDB])="Close","") I want to count number of close in my report I name it Total No of CLOSED PO: can anyone is kind to help how to figure out thanks in advance ... 23 Mar 2010 06:45

#Name? - Access 2007-Windows 7
Anyone have an idea? Access 2007, Windows 7 - a report shows #Name? Access 2007, Windows XP - report shows the values The code is identical on both computers. #Name? is showing for a for a text box - Here's what's in the text box =[breedname] & ". " & Right([Title],Len([title])-15) & " " & Right([sexorder],L... 20 Mar 2010 19:59

Print Access report along with an outside checklist
Good afternoon Is it possible to print a report that's in Access and then right after print an Excel checklist? Background: I work for a large construction company that does regular maintenance on their equipment. Right now we print a parts ticket of the parts required for the particular service they ar... 23 Mar 2010 11:20

Can I add a map to an Access report?
I'd like to create a prospect sheet for salesmen with a business address, other info and a printed map from Yahoo, Google, or Bing so they can easily find their next location. Can I do this through an Access report using a control object or ActiveX object? If so, what is the object and how is it used? ... 21 Mar 2010 08:18

Summing a column in a report
My report has a column of numbers. Below the column, I would like to show a text box with the sum of these numbers. In Excel I would just use something like "= Sum(C3:C56)", but I don't know how to do this in Access. My real problem is that each report has a different number of rows. Any clues?? Thanks -- ... 21 Mar 2010 10:30

Drawing a grid on a Report
greetings I have a report based on a Crosstab query. Both the Query and the Report work just fine. They have 2 row headers on the left side of the table and a variable number of PivotField headers. I've been asked to have the Report's table in a grid when printed. Normally I would just use line segments ... 20 Mar 2010 18:52

A Year to Date Report Question
I need to create a YTD Report in the following format: CurrMonth PrevMonth CurrYear PrevYear Customer1 2 1 7 5 Customer2 6 19 15 12 etc... Cu... 19 Mar 2010 21:16

Publish a report to excel?
This is exactly what I need to do, but I don't understand where to insert this code. Please help. Thank you. "mike_mike" wrote: ur a legend! I couldn't remember the command! "Baffee" wrote: Try using: DoCmd.OutputTo acReport, "Acess ReportName", acFormatXLS, "Path/FileName.xls... 19 Mar 2010 20:09