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  >>   Managing Reports that Are Being Combined into One Report I have 4 different self-contained reports I would like to variously combine into one continuous "print job" based on various parameters chosen by the user off a master print control form. Currently, the record source for each report is set using the openarg: parameter to a .OpenReport method created using values gathered on this form, and there are 3 different types of record sources that c... 2 25.09.2006 16:28:38 Using parameters with queries and reports Using parameters with queries and reports I'm using a form to supply data to a parameter query. When I run the report, it opens the form, I enter the data to pass to the query, click "ok" it hides the form, runs the query and displays the resut in a datasheet query view instead of the report. The report is never displayed. ... 4 25.09.2006 15:36:01 Duane Hookum I have been reading your responses and think you may be able to help me. I had a query & form based on a table and a report from the query. The table had Lookup fields. I changed the lookup fields to text and modified my form to include lookup fields. The table, query and form are all working fine. However, my report gives me an error message: "The value you entered isn't valid for ... 8 25.09.2006 15:06:41 Record totals in group footer G'day, I have a report that lists all current prospects with relevant details. Current prospects each have a Corp Office Rep (COR) that looks after them and the report, via the use of group headers and footers lists all current prospects per COR. A prospect may become non-current, and they are either current or non-current via a yes/no box. In the group footer I have some calculat... 3 25.09.2006 14:27:22 How to change print preview window settings in VBA Access 2003: Print window needs to open with the report in the center of a maximized window and with a preset zoom setting. Thanks -- RobGMiller... 3 25.09.2006 14:21:25 Adding Totals in Report Some help please from someone who is still learning!! I have a report based on a query and I would like to add up the totals for each column, ideally within each group. My report at the moment is grouped by Region (This is sales data for a sales force). It then has projected sales forecast for Jan to Dec as fields. I would like to total the sales for each month for each region. I've... 2 25.09.2006 13:01:18 Export individual pages of a report please? I use access 2002 to produce royalty statements. The report contains 52 pages each page for a different person. I would like to be able to send each persons page to them individually. If I expert to html it works well but there is a first, previous, next, last nav line at the bottom. I can edit this out in notepad but have to do it to each page individually which kind of defeats the auto... 2 25.09.2006 12:58:49 Export Data to xls Hello! Why when we export an Access report to Excel, all the data are exported except those that in the Report_Footer? and I cannot place the data into the Page_Footer because it will be displayed on each page. Thanks for any suggestion. ... 2 25.09.2006 10:15:21 Duplicate data in detail section I hope someone can help with this weird situation. I have a report based on a query. The query has 8 fields in it. 6 of these fields can have repeating data in them so I have put them in header section. I would have assumed then that the number of records in the detail section would match the number of records in the query, per set of repeating data. But, I get at least 2 detail records ... 3 25.09.2006 04:44:53 Missing records in report I have a report of a club membership data base. The report deletes the records when multiple last names are involved. For instance there are three Browns in the data base but only one come up in the report. Filters are off and the place that calls for deletion of multiple records is not checked. Any ideas on whats wrong. Jim... 7 25.09.2006 02:09:01 how do I count yesses and nos I have a database of survey responses that I need to analyze. Many questions were yes and no toggles and I need to count up how many I received and analyze across other info I also received. I can't figure out how to count up the total number of yeses and nos in a report or in a query to get to a report.... 3 24.09.2006 23:07:34 Default Value I have a field that I would like to have this in as it's default value: -B/O Then when the user goes to the field I would like them to be able to add a numeric string in front of this default, something like this: 239401-B/O I am simply trying to save some repetitive keyboarding. Any help is as always appreciated. Finding that someone has read and answered your question is ... 3 24.09.2006 19:43:07 45° Hi, In excel I can write text in an angle of 45°, or even 90°.... I can't find a way to do the same with eccess reports... Did I overlook something or isn't it possible?? Thanks JP... 2 24.09.2006 18:33:55 report prints blank fields I am trying to print out the current record that is in my form, but all that prints is a blank form. I have tried to do this using both of the following coding snippets - same blank form result for both. Private Sub cmdPrintPhoneOrder_Click() DoCmd.OpenReport "rptPhoneOrders", , , "[CoNameID] = " & Me!CoNameID End Sub Private Sub cmdPrintPhoneOrder_Click() Dim strDocName As String ... 3 24.09.2006 15:34:11 Printing a report I have Access 2000 I want to print the current redordset on frmBvistaMain to rptBvista. I've tryed several of the posts (code) but for some reason I can't get them to work . I'd like to keep it as simple cause Me.notToSmart= I'd be grateful for any help. Thanks -- Message posted via http://www.accessmonster.com ... 3 24.09.2006 15:30:00 IIF syntax problem... I have a crazy control source already which divides one expression in to another (see below). The problem is the second half may be "0" and is throws #num! when it is. I'd like to show a "-" instead of #num!". Any ideas on how to format the IIF (i've tried a few differnt ways to no avail.) Full code as is: =(Count(IIf([Product Type]=Forms![Allied or Monster]!ProductTypeV And [Pack... 2 24.09.2006 15:17:29 Printing from Relationships window Can anyone think of a reason (setting?) that's causing the realtionships' symbols ie 1 and oo (infinity), to not be printed when printing Relationships to hard copy. Viewing their properties (File|Print Relationships, then go to design view), they would appear to be images and therefore I see no reason for them not to appear in the printout.... 1 24.09.2006 15:16:01 Referencing queries First question here but I think I am well on my way with this project! I have a deal logging database that tracks which people are working on what deals (many to many joined by a junction. Within the deals, there are 2 main types. I want the report to show the names of the team-members and then each of the deals they are working on. However, I want the deals of type X to be shown in the ... 3 24.09.2006 14:42:25 dialog box "was print successful?" I would like to check a "checkbox" when a good copy of report prints. The checkbox is used in queries to qualify details in future reports. A dialog popup would be nice, but is unecessary. If the checkbox were check automatically when the report prints, that would be wonderful.... 3 24.09.2006 13:22:02 stacked column chart based on a crosstab query in an Access report A2003, Excel2003 I'm trying to create a stacked column chart based on a crosstab query in an Access report (didn't I just say that?) Anyway... I can shove the data into Excel, or tell Excel to query my DB just fine. To make things easier to follow, I'll give a bit of detail. I'm graphing demand for a service across several cities, so in my crosstab, cities are in the first column and th... 1 24.09.2006 04:16:54 how do i design an access database table for compiling all the law how do i design an access database table for compiling all the laws to help prepare me for taking a bar examination?... 2 24.09.2006 01:57:53 access 2003 how do i design an access database table for compiling all the laws to help prepare me for taking a bar examination?... 1 23.09.2006 23:01:02 Print preview data moving I set up a report to print and it is moving up yhr forms on my printer, it also is moving in the print preview screen in Access. How can I lock this print set up so I does not move, since the forms are set. -- Victor... 1 23.09.2006 01:13:01 Some Help Posting for a friend; he is stuck out on a ship with very poor internet access. I put all three questions in one Post (so I dont get blasted for MultiPosting ! ) If anyone is able to help out, it would be very much appreciated ! Please post these questions for me on that access newsgroup you told me about, I cant figure these things out. My division officer asked if I knew access a... 4 22.09.2006 22:35:46 now() Date and Time Formatting How do I get "mm\/dd\/yyyy hh\:nn\:ss" to show the date and time (with AM/PM) in not 24 hour time? Thanks! Adam... 3 22.09.2006 20:39:01 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  >>