Reports

Merge image file in Access 2007 attachment field into Word document
I'm using Access 2007 with the new attachment field type. I have a table with an attachment field that contains a .JPG image file. I would like to do a Word merge and insert the attached image for each record into the output document. I have seen instructions to use the IncludePicture merge command to referen... 11 Nov 2009 13:30

pdf file won't print graph in report header
Hi, One of users of my database has version 8 of Adobe on his computer. When he prints a report from the database with graphs on it to PDF file, the graph on the first page in generated pdf file won't show up. Can anyone help with this problem? Thanks. -- Lydia Liu Access/VB Programmer ... 11 Nov 2009 12:23

how to setup event procedure on format?
I have a main report and a subreport. Now it is working very well. But we don't want everything show up on daily report. On the main report, I put total actual time and target time. If (totalactualtime-targettime)/targettime<0.1, then I am hoping the subreport invisible. How can I set this up on the format at eve... 9 Nov 2009 18:53

Calculating totals in a report in Access 2007
I am using Access 2007 to create reports. For the query, I am pulling a first name, last name, company, division, and dollar amount. All the data is being pulled correctly in the query and the report. I would like to have a total dollar amount for each company. How would I go about doing this in my Access re... 9 Nov 2009 17:46

On Open Event in a report
Hello... I have created a report, when I run that report I would like to have an "on Open Event" that opens up a small form that I can click that will export the report to word. The form works fine, but I cannot get it to open when the report does. Any help would be appeciate! BTW - I love this site, and have... 9 Nov 2009 14:25

Access 2007 Report shows multiple rows, query shows single row
I am using Access 2007 for my database. When I run the query, the output on the screen looks right. For example: First Last Company Group Jane Doe ABC, inc. Managers When I run the report, which points to this query, I get: First Last Com... 7 Nov 2009 20:42

missing data
Hello, I have several memo fields in one table. When I look at the report for a single record in this table, I notice that only some of the information will print. I realize that I can adjust the field text box size on the report, but what I would like is some expression or command to print all information ... 2 Nov 2009 16:51

Report has 126 pages and take forever to run
Hey there, I'm minorly new to reports and simple ones are working fine but I have this complex one that has 399 text boxes on it and in the On Open event I open up 2 different recordsets to see which textboxes get displayed, along with their relevant data, and which disappear. All the logic works except 2 problems... 3 Nov 2009 12:39

Query results not showing nulls
Hello, I have written a query against a MS Access table that looks something like: Select * from myTable when color <> "blue" It correctly does not return any rows with "blue" in the color column. But it also does not return rows with Null in the column. Can someone tell me why and how to fix it? Than... 26 Oct 2009 16:43

65 Opinion Dsiconsolas.com
Hola mi opinion acerca de dsiconsolas.com es bastante buena, gracias a estos chicos pude tener el cartucho para que mi hijo jugara a todos los juegos, que me descargo de internet. Fueron amables y me digeron donde descargarme los juegos y configurar la tarjeta. Me dieron un peque�o manual que para deciros la verdad, s... 16 Oct 2009 05:19