Threads Replies Last Post 253 Pages: <<  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  >>   Grouping in Pie Charts I have a database that tracks our warehouse inventory. I have created a pie chart based on three fields. !) TransactionDate, which through nested queries returns the date of the last transaction dealing with an item. 2) PropertyNumber, which is a unique number given to a particular item we have in inventory. 3) InvCost, which is an expression that muliples our inventory level by the... 1 29.08.2006 14:57:02 Non-descriptive error message I am using Access 2000 on a XP Pro machine at work. I created a report this morning and had another open to copy some elements from and paste in the new one. General stuff: company logo and such. Was testing it out and started receiving the first of 2 messages. 1. "You cancel the previous operation" which may be the root cuase of all this. I did want to save the new form, but not... 9 29.08.2006 17:15:01 Printing a selected report from a subform Wonder if anyone can please help. I want to print only selected records from a subform. My main form [Newform] contains individuals name, address etc. The subform [AppointmentDetailsSubform] contains specific appointment details. Both forms are linked on a number field. I want to be able to print out specific appointment letters from the subreport, but when I print the report I get all re... 2 29.08.2006 12:21:37 Serial Nos on Report I have a simple data from QUOTATION Table. Field are QuoteID, ProductNo, Descri, etc A report is generated using a querry which shows Quotations to Customers. I want to add Serial Nos on report only instead of adding a field in QUOTATION Table. I dont know how to do it. Please help -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/2... 1 29.08.2006 09:25:07 Pie Charts I would like to be able to display a pie chart with 5 fields of one record, which total 100%. How can I create this type of chart instead of a summary? Thanks, RH... 3 28.08.2006 23:51:01 Error Message when running report I have a report, which runs off a query, which runs off a table. I added a column of data to the table and then that column to the query. I went into the report via Design View and added a text box to display the value of the new column. When I try to run the report, I get the following error message: "The expression On Format you entered as the event property setting produced the follo... 6 28.08.2006 23:35:30 Report to print color bars to 60 horizontal slots I have this report which prints horizontal color bars in 60 slots which represent months over a 5-year period. I build the report in a temporary table which then feeds the report. Currently I have columns called M1 thru M60 in this table. My problem is that now the user also wants special characters in the slots to represent certain events. These will overlay the color. So I am now facing ... 4 28.08.2006 21:01:34 Empty report condition What is the correct way to handle the 'empty report condition'? Currently, I have an event procedure set up which displays a message. However, the procedure that opens the report also has an 'on error' handler and this is being triggered and so shows a second message.... 3 28.08.2006 20:07:49 Calculations on report... I am new in doing calculation in Access. I am using Access 2000 and need a little help with If Then Staements using in the Control Source. Do I still need to DIM anything?? Here is the code that i would like to use that I thought I could use in Vb but an error is coming up. When I use the Control Source do I have to refernce to either the query or table for the variable that I am using or can... 26 28.08.2006 18:54:14 Filter Data in Report I have a report that contains a customer listing with phone numbers. I want to filter out all of the customers who do NOT have a phone number. Do I need to go back and run a query off of my table or is there a way to filter data directly from the report designer?... 2 28.08.2006 18:17:05 Start and End Dates show error I now have my start and end dates in my report but if there is no data entered between the start and end date it shows error not the dates how do I always show the dates even if there is nothing in the detail of the report thanks... 2 28.08.2006 15:44:41 I am a Chart Idiot...looking for help I am missing some pretty simple concepts I guess. I have created a 500 page report...one page per record. The data on each page is organized into 4 categories...call them A B C and D. And a numeric total is reported for each. The % of the total value within each category is also reported. I simply want each page to display a pie chart of those 4 % of total values for each category... 6 28.08.2006 13:01:02 Thermal label printers I'm researching a thermal (roll type) printer for barcode labels. The client is looking at a Zebra printer, which, from my understanding is Unix based. Therefore, there is an intermediate program needed between Access and the printer. I would prefer to just go with a TryeType BarCode font in Access, directly to the thermal label printer. Has anyone had any experience with a good work... 6 28.08.2006 12:56:57 Records goto next command I want to have my code send the focust to a new record in code. When running "DoCmd.RunCommand (acCmdRecordsGoToNew)" it does not know what form I am refering to - What is the syntax for this (the form is "Forms![ST_Enter_TR]![ST_TRANS_HD subform]")... 2 28.08.2006 05:25:00 nested iif statement syntax I have two y/n fields that need to trigger printing on a report. I am using the following, but i keep getting a syntax error. If first Y/N=true the test the next Y/N to print BadgeText4 =iif([events],=IIf([RSVP4],[BadgeText4f],""),"") TIA for any direction, michael... 2 28.08.2006 04:30:44 Counting records that are not null I am trying to count the number of records that are not null in a specific field. My field is a 4-digit text field. I know the proper syntax for counting records if the field is null, i.e., =Sum(IIf(IsNull([field]),1,0)). My problem is that I don't know the syntax for counting fields using the syntax "Is Not Null". I tried reversing the true/false counts as follows for the "IsNull",... 5 28.08.2006 00:42:02 Start Printing 3 col labe at choice of column/row Greetings. Don't have a label printer, but on 3 column, 10 row (Avery type) label sheet, would like to start print labels at specific column and row, say 3rd column of 3, at row 7 of 10. Perhaps a little parameter query prior to print? Thanks, Mike -- _________________________________________ Michael Dionne - Network and Software Consultant 176B Port Road, Kennebunk, ME 0404... 2 28.08.2006 00:08:19 Unable to dynamically set unassociated label's caption I must be doing something wrong and I'm sure it must be simple but I can't get it to work. Using the Report_Open section, I'm trying to set the text of an unassociated label depending on the current month, like this: Me.LblThisMonth.Caption = Month(date()) but when I do this and print preview it, the label shows no text, then if I remove this line, then the text that is in the box on the des... 5 27.08.2006 19:40:53 expression in unbound textbox hi folks, i'm using Access97 running in Win2K Pro O/S. i have a query based on a table, with a calculated field made up of the concatenated first, middle, and last name fields in the table, and aliased as EName. the query has criteria set on the employee table's primary key, and returns records for only a single employee. the name shows up as expected when i run the query. i used this qu... 4 27.08.2006 19:38:48 I'm enterind months in database when printing not in order I'm enter dated in my database by month like Jan-Dec but when i print my report the month are not in order April may come before January THE DATA FOR THE MONTH IS CORRECT BUT NOT IN CORRECT ORDER.... 2 27.08.2006 15:21:52 I enter months in my database when i print they are out of order I'm entering months in my database Jan-Dec but when i print my report jan-dec do not be in correct order how can i get my records to show in correct order Herman Jones... 2 27.08.2006 14:57:13 Question on filling out a report The database I am working on, the gentlemen I am making it for has a bizarre request. Maybe it is not bizarre but I have not ever done it or seen it done before. He would like the report to have a celled look and take up the whole page. Like you would in Excel if you put borders around the cells. Well, the border look on the report is not the problem but the filling up the rest of ... 18 27.08.2006 11:15:01 one report chooses another printer Hi My reports are printed via the standard printer except one report, each time I want to print that report it chooses another printer. I have to change manually the standard printer. What is going wrong?? Thanks for your help Ron ... 5 26.08.2006 20:51:41 Set field control source based on day of month (1st-14th or 15th-3 For a field on a report, I'm trying to use an If/Then statement to set the Control Source depending on the day of the month. I need one Control Source for days 1-14 and another for 15-31. To do this I put this into the report's open event: If (Day(date) < 15) Then here are the control source statements and the Else statement. End If On one report this works fine, but after I copy and p... 2 26.08.2006 19:14:01 Selecting data based on activity in a given month I have equipment that I use on different jobs. I might use piece of equipment on three different jobs in a single month. I have made a few tables with start date and end date fields for when the piece of equipment starts on one job and ends that job. I am then charging myself internal rent for the equipment on a by day basis.If the equipment is on the job for 10 days I want to charge my... 2 26.08.2006 16:08:36 253 Pages: <<  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  >>