| Thread | Last Post | Replies |
|
| Report header | 24 Sep 2004 13:09 GMT | 1 |
I have created a new report and trying to move one of my text boxes into the Report Header but it is not showing any information when I go into print preview. However if I drop it down into the Page Footer the information appears. Cant seem to find any difference in any ...
|
| Any code out there to convert saved reports to PDF? | 24 Sep 2004 12:07 GMT | 1 |
Want to create the report (built in Access 2000 as a template)and be able to save as a PDF file. Currently save as .snp or .rtf and then convert to PDF using a converter. Any of you written any code to do this? It could be a box
|
| Caculation on Report | 24 Sep 2004 07:42 GMT | 1 |
I have three columns and I want to caculate the % of the sum of two columns but if the either of two columns have a 0 I just want it to be blank. I have this in the forumla and it half works. ie:
|
| Query length problem | 24 Sep 2004 07:38 GMT | 1 |
I'm trying to raise a report from within a VB code section (using DoCmd.OpenReport). When doing so, the report comes out empty (no records are retrieved). If the report is generated by clicking on it (from the database
|
| reports created with access 2002 do not work in access 2003? | 24 Sep 2004 07:27 GMT | 1 |
I'm transferring data base maintenance responsibilites to another individual. I'm using Access 2002 - he is using Access 2003. I gave him a copy of the data base via a diskette. When he tries to produce a report with Access 2003, the process asks for
|
| No Data in Report | 24 Sep 2004 06:43 GMT | 2 |
using the following code in the OnNoData event: MsgBox"There is NO Data in the Report" Cancel=True this cancel the report, nevertheless a second message is shown:
|
| Force a query to show zero | 24 Sep 2004 03:52 GMT | 1 |
I have a query with 3 columns based on a table - column one is [Month] which is based on a popup input form, column 2 is the sum of a field [Cost] and column 3 counts the number of [Cost] lines that are summed in col 2.
|
| Can a report record that a record was listed? | 24 Sep 2004 03:00 GMT | 2 |
I want my report to list only records that have not been listed. So I have a posted field (boolean) that defaults to false. My report is now grabbing up to 12 records where Posted is false. Is there a way to set Posted to true when the record is selected by the report?
|
| Graphs cut off on righthand side on windows XP, work fine on windows 98 | 24 Sep 2004 02:47 GMT | 1 |
We use Microsoft Access to generate a number of landscape reports that include graphs. These reports have been used for years and have worked well on past windows versions. We now have windows XP and the graphs have the right hand
|
| How do I sort a column of 5+ birthdates by year in a report? | 24 Sep 2004 01:35 GMT | 2 |
I am making a directory with a list of children's names & birthdates.(01/15/99etc.) I am having trouble getting the list of birthdates to sort by year. It will only sort by the month.
|
| Lines on a report growing with a text box set to CanGrow | 23 Sep 2004 22:44 GMT | 1 |
I have a report that has a text box set to CanGrow. I also have many lines to separate fields and when the text box grows the lines stay the same. How do I get the lines to grow with the text box?? Thank you
|
| drawing a chart on a report | 23 Sep 2004 21:13 GMT | 1 |
I'm trying to insert a chart on a report, the chart is based on a query which takes 'year' as input from the user and generates the result. The query works fine separately, but when I run the report with chart
|
| Sub-Report Won't Sort | 23 Sep 2004 20:35 GMT | 2 |
I have a subreport on a report that will not sort. The subreport is filtered from a query to show results that match a student ID. I tried going to the properties of the subreport and setting the OrderBy to qryAlphaTardies.date and changing OrderBy On to yes.
|
| Is it possible to add a page break to a report | 23 Sep 2004 17:14 GMT | 2 |
I have a report that is base on a query. The fields I have are : File no Sample No
|
| Report With Multiple Subreports | 23 Sep 2004 17:06 GMT | 1 |
I have written a Report that includes a number of Subreports. The Report works fine unless I rerun it several times. Rerunning the Report causes Access 2002 to crash. Is anyone familiar with this problem and have a
|