| Thread | Last Post | Replies |
|
| Hiding the Now Printing Window | 22 May 2006 19:30 GMT | 3 |
I have a from with a comman button that I have programmed to print "X" number of copies of a report. It all runs fast, but is there a way to keep the "Now Printing" window from popping up. Get's annoying if you are printing 100 copies.
|
| How to retain graph from report | 22 May 2006 19:28 GMT | 3 |
I am able to successfully generate graph in a report based on some x and y values and show the raw data on this report as well. I have since applied a macro that exports this report into Excel. However, it does not retain the graph that was generated in the report. I know I
|
| Setting Date Range on a crosstab | 22 May 2006 18:09 GMT | 3 |
I have a 1 table database set up to track incidents by jurisdiction (IJ or OOJ). I set up a crosstab query to give me a count of incidents by jurisdiction. Trying to prompt the user for a date range gives an error message, "The Microsoft Jet database does not recognize '[Type ...
|
| Problems with IIF Statement | 22 May 2006 16:24 GMT | 6 |
Below is my setup: Column Expr1= # days of absence Column Expr4=represents if that was a whole day or half day. The values in column Expr4 are 1=whole day .5=half day
|
| Rounding problem | 22 May 2006 15:53 GMT | 4 |
Is there anyway to control the way Access deals with rounding? I have 5 controls on a report, all are standard numeric with 0 decimal places and the sum of 5 fields in my table. The underlying fields in the table are however 3 decimal places. There is a total of the 5 controls on
|
| Conditional Reporting - Either View or Print directly to Printer | 22 May 2006 15:13 GMT | 4 |
Is there a simple way to do this? I have an application where I want to make system wide settings to either print or print preview the same set of nightly reports... I know I'll have to condition each report thru a switch but I don't know how
|
| Preview problems | 22 May 2006 14:57 GMT | 3 |
I have 2 problems using Access 2000 First a report in preview shows one line from the detail section to be blank, other lines show OK and when printed all the data is there and is correct. This looks similar to Excels preview problems but I havent seen this
|
| show monthly results | 22 May 2006 13:57 GMT | 2 |
I have a query which returns a sum of order by type by month. The query returns a result like the following artnr | artname | quantity | month | name of month ------------------------------------------------------------------------------
|
| If statements | 22 May 2006 13:30 GMT | 3 |
I'm designing a report based on a query. The report lists precincts and how two candidates fared in each: Precinct cand A # votes
|
| Adding blanks to printed report | 22 May 2006 06:31 GMT | 1 |
I have a report that prints a sign-in sheet for all scheduled employees, the name and scheduled hours are each printed within a box to separate each name. I would like to have extra blank boxes print out after all the scheduled names to add people who are not scheduled
|
| Conditional Formatting in a report, problem | 22 May 2006 05:53 GMT | 1 |
I want to BOLD a row in a report based on the value of one field in the record. The field is Group_Order. In the design view I selected all the fields in the report. I then selected FORMAT then Conditional Formatting. I selected "Expression is" and typed in
|
| Using 2 fields in report function | 22 May 2006 01:07 GMT | 3 |
I use an Access 2000 database to track test scores. I’m using different fields to track these by weight, named Majortst, Weeklytst, and Quiz. I also have been tracking when these were given in another field I call Timeadm - this field is completed through a table, with choices ...
|
| Upper case for control source | 21 May 2006 16:51 GMT | 6 |
A label box on one of reports has in its control source =[Enter Financial_Period] which is the criterion on which the query is based that is attached to the report. The financial years are FY05 for 2005, FY06 for 2006 etc.
|
| CROSS TAB REPORTS - DATE WISE | 21 May 2006 15:34 GMT | 1 |
IM TRYING TO CREATE A CROSS TAB REPORT DATEWISE IS IT POSSIBLE TO CREATE DIRECTLY USING THE REPORT WIZARD WITH THE CROSSTAB QUERY AS THE SOURCE THE FIELDS
|
| Is it possible for charts to use values on a report? | 21 May 2006 05:24 GMT | 3 |
I have a report that produces weekly statistics - it would obviously be nice to include a graph ( i assumed that's why graphs are included in the toolbox) Is it possible for charts to use values on a report?
|