Threads Replies Last Post 253 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   Charts - Legend Colours I have a Pie Chart and a Legend and I want to match the colours up to specific colours, i.e. Legeng is.. Red Amber Green Blue and I want the colours on the Pie to be Red, amber, Green & Blue to match the legend. Is this possible ? ... 1 28.09.2006 10:43:01 Chunks of random white space on report This is strange. I have a main report to which I have added several sub reports. Some pages print just fine. Some pages print with varying amounts of white space (the fields move down, nothing is skipped). I've tried all the properties on the main and sub reports. When I previewed the Main report prior to inserting the sub reports I didn't have this problem at all. The blocks of ... 1 28.09.2006 04:21:03 Access 2003 in Landscape orientation Print margins are all 0.5". Report width is 9". Print options are set at Landscape, and the diagram shows the report in landscape mode. But in Desugn View the green still shows in the corner of the report control and the information given is that report width is greater than page width (which is untrue), and preview omits the last column while showing lots of white space. I even changed ... 3 28.09.2006 02:11:02 emergent Help me, I accidently deleted one of my reports, and the format took me long time to accomplish, is there a way to retrieve the file? Help please!!!!!!!!!!! -- Thanks a lot!... 4 28.09.2006 01:50:48 New page on a new group I'm sure it can be done but I am missing the setting when I look at the grouping dialogue. What do I have to do? TIA __Stephen ... 4 27.09.2006 22:09:06 Access 2003 Report data format How do I display numbers in Fractional form on a report? Tables contain exact decimal equivalent.... 2 27.09.2006 21:58:23 group on range I have these fields: sales date, salesprice, days on market I have created groups for sales price using a range as the group break: 100,000-200,000 200,000-300,000 etc. I have created a group for sales date using the year as the group break I want the report to group and sort like this: sales price 100,000-200,000 ave days on mkt 2005 ... 2 27.09.2006 20:58:20 Keep header contents together I have a report with a primary and secondary group header. I have no detail. The primary header contains QuestionID and Question fields. The secondary header contains AnswerRating and AnswerMeaning fields. The secondary header also contains a calculated field =count([RespondentID]). I want to ensure that all the information relating to each question is on the same page. The prope... 3 27.09.2006 19:57:02 Subreports within reports My report is for one record within my customer table. I show the pertinent contacts for that record in the first subreport. The next subreport shows the call records for that customer. The problem I have is that the calls subreport is repeated multiple times growing the report from the 4 pages that it should contain to 17 pages with the calls X3. Hope someone can help me! ... 2 27.09.2006 19:48:15 Report Programming ? I have a report that pulls data from a querie.... The data is as follows. Inmate #, Inmate Name, Race, Unit, Section, Cell, Bed & Sep However it does not pull if the cell is empty say I have 30 cells in section C but only have 10 Inmates it will only pull the 10 that cells that are used. What I need to do is have it add the empty cells as well, however the empty cells are not in this tab... 8 27.09.2006 19:01:02 printing multiple iterations with a serial number I am developing a db that will be used to print questionnaires. I have a form that allows a user to select questions by using a series of combo boxes. I then use a report to place the questions in text boxes and print the questionnaire. This is working, to some degree. What I am having difficulty with is that I want to print a quantity, say 25, of the same questionnaire (report) with a ... 6 27.09.2006 18:36:22 Incorrect Data on Last Page Ok, I have an unusual problem with a report. I'll try to explain. I have a main report that prints some header/footer data with no problem. In the detail section of the report is a subreport that has a group on StockNum. The detail section of the sub report has serial#s but they are not printed in the detail section. Instead, I'm stringing them together in the subreport Detail_Forma... 7 27.09.2006 17:58:02 Filtering Reports using dialogue box <reposting, because I messed up in the subject line before, sorry!> Hello, me again. I love these forums - you are all so helpful! ANYway, I want to create a filtered report. This is what I have: A dialouge box that has a list box with lists of workshops that people can choose from to print class lists. The workshop list is derived from a query. Of course, I have a regular ... 1 27.09.2006 17:30:01 Report not picking up all data My report is not picking up all data. There are three tables. In the unit_measurements each brand and unit_size is unique together as they are in the refuse table. The delivery table can be as many as you like. there is no primary key constraint and i need it that way. the report is only picking up one row from the delivery table, not all as well as the data from the unit_measurements and... 1 27.09.2006 16:56:01 Counting in Code I need to count the number of times records have specific statuses. I'm using a Select Case statement in the Detail_Format event to increment a variable for each status. I am then using that variable to print a summary in the footer of the group. The counts are coming out incorrect (roughly 3 times the total number of records in the report). It appears the Detail_Format event fires mor... 3 27.09.2006 16:11:02 Align a text vertically in centre Hello How could I align a text vertically in the centre? ... 4 27.09.2006 15:23:42 repeated page footer note Hi, Just wonder if there is a way to only show page footer at the last page instead of showing page footer every page? -- Thanks a lot!... 2 27.09.2006 15:01:05 export 1 record from ms access to ms word I have created an ms access 2002 REPORT from a FORM, and am trying to see if there is a way to export 1 record from the report into ms word. There are multiple records within the form/report, and i am trying to see if there is a way to export 1 record from the report into a single file ms word document. Any assistance provided will be greatly appreciated!... 2 27.09.2006 14:46:24 Exporting single record to snapshot I hope this is a simple question that someone can help me with. I created a button that exports my record as a snapshot file. The problem that I am having is that all the records get exported instead of the single record that I am needing. Can someone help?... 2 27.09.2006 14:45:51 Transferring report images to Word Hi, I have an invoice report with a company logo(bitmap image) which I imported from an Excel file. When I publish the report in Word from Access the image disappears. If I copy and paste it over it works but I would like it to transfer over first time with the rest of the report. Any ideas? Thanks in advance JohnnyF... 2 27.09.2006 14:05:11 Filtering forms using dialogue box Hello, me again. I love these forums - you are all so helpful! ANYway, I want to create a filtered report. This is what I have: A dialouge box that has a list box with lists of workshops that people can choose from to print class lists. The workshop list is derived from a query. Of course, I have a regular old button that points to a report. I have a report that includes all the ... 1 27.09.2006 13:48:02 Convert a textbox data in another text Hello I have a textbox which contains the month and year. It calculates as =Format$([soldmonth];"mmmm aaaa";0;0) I´d like to obtain this information, august 2006 and convert it in another textbox, in something else, another language. something like if soldmonth.caption or value = "august 2006" then texttranslate.caption or text = abuztua 06 else if soldmonth.caption or value = "june200... 1 27.09.2006 12:44:00 Setting Paper size via code for reports I'm trying to print a report in Access 2003 to a preprinted form that is not standard size. The forms size is 8 7/8 by 8 1/2. The printer is a dot matrix tractor feed and after the first report prints the paper is feed as if the form is a standard size so the second and subsequent reports are not aligned correctly. I checked the printers properties thinking I could set it to a "User Defin... 2 27.09.2006 11:36:02 Report based on 2 queries? I currently have a report that gives me varies info about employees that have seperated and the positions they held. I'm using this to track seperation info per department. I have a form that I enter a date range to get this info for peoples records that contain a Seperation Date. I also however want to get a total of how many positions there are in every department that are not checked ... 9 27.09.2006 06:16:18 1 page reports I have a lot of fields in a Db and need to be able to print each record with about 60 fields out on one page. Is there anyway I can use tab windows to be able to view it all on one page or is there anotherway to have mutiple layers to a report or am I just out of luck and going to be forced to have 5 different reports.... 6 27.09.2006 03:03:03 253 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>