Threads Replies Last Post 253 Pages: <<  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  40  >>   How can I place a multi column sub rpt in a multi column report? I have 3 reports that I am trying to merge together. One is a single column report and the other two are multiple column reports. I can place the single column report in one of the Multiple column reports, however when I try and place the other multiple column report it doesn't work. Any ideas. Much appreciated ... 6 25.08.2006 19:18:58 run-time error 2501 I keep getting 'runtime error 2501', and I am unsure of what code to use to fix. Here is what I'm doing. Click open a report, then the report 'On Open' event triggers a form to open. This form allows user to select the parameter (in this case, the employee) to use in the query that populates the report. All works fine, and I am able to run the report for the employee I select. My problem... 2 26.08.2006 01:51:30 Group on Month with multiple dates for same record I have been struggling with my problem for a while now, and feel that the answer may be quite simple; except that I can't figure out what it is. I am running a report for Admissions vs. Discharges for my facility. The time frame can span over one month or over several months, in which case, one resident may have discharged from the facility and returned (admitted) again at a later date... 6 25.08.2006 21:22:27 Report NOT to show blank values Long story short: HR uses a new/change/status word document and write employee name and check marks "New Hire" Change" Speration", then there's "Salariad", "Hourly" and then "FullTime" PartTime" All Check marks. They save the word document as that employees name, print off 10 copies and hand them out... UGH! What I want to do is have a database with all this info in. The HR lady will f... 2 25.08.2006 20:35:02 additional text on barcode labels I need to print a few thousand barcode labels and I want to include text along the bottom from different fields and in smaller font. Field 1 - "3 of 9" font at 28pt Fields 2-6 underneath bar code as 8pt text I can't seem to a find a way to do this in the Access label wizard. Any ideas?... 3 25.08.2006 19:51:02 Shading records in a report - Kinda tricky Howdy Folks, I would like to shade some records in an Access report based on whether the value for a given record is above a certain level. That's the basic concern, but let me provide some more details. My report is a summary of analytical chemistry data for groundwater. I want to compare the results for various wells against governmental groundwater standards. The format of the rep... 5 25.08.2006 18:55:49 Table date in Text Box How can I automatically pull a table's modified date into current text within a report?... 4 25.08.2006 18:43:42 multiple entries in same report page Hi I'm wondering how I can create a report that places the data from two rows of a query onto the same page. I am using a duplicate entry query and want to be able to print a report that shows both entries next to each other. Thanks... 2 25.08.2006 18:42:03 crosstab.mdb Duane Hookom, Where I can I get the sample crosstab reports that were listed at http://www.invisibleinc.com/divFiles.cfm?divDivID=4 according to previous posts? I just accessed that page and there were no items listed. Thanks in advance, jpo... 2 25.08.2006 18:01:01 Can Grow property in a report I have a report that needs to dynamically set some properties in textboxes and labels. The "Can Grow" property is set to "yes". However, when I attempt to dynamically set additional properties using code the Can Grow no longer works. How would I get it to work? Me.Controls("txtImageCaptionData" & i).Width = 5000 Me.Controls("txtImageCaptionData" & i).Height =... 2 25.08.2006 15:49:02 how to generate a report from Form output Hi i have a form which runs a cross tab query, when i tried to generate a report using wizard it doesn't show any fields(left hand side box, where you can select the needed fields for final headings in a report) .........i have no idea why this has happening?!! more over i am new to Access and unable to figure it out myself, is there anyway that i can produce a desired report for my form... 6 25.08.2006 15:29:40 open report and only display select data I have a form, lets say editclientsdata. I also a report, lets say printclientsdata When a user is lokimg at the clients data in the form it can print that data. So, I need to open the printclientsdata report, from the form. I do that. The problem is that this report displays the data from all clients. I just want it to display the client selected in the form. This should be possible. I... 3 25.08.2006 15:18:01 text box and label control sources and concatenation I have a text box with this control source: Gross Weight: [tblFGPhysicalAttributes].[GrossWeight] & " " & [tblFGPhysicalAttributes].[GWUOM] I use another text box as a label that has this control source: ="Gross Wt: "+IIf(IsNull([Gross Weight]),Null,"") The problem is that the label appears even if the GrossWeight value is null. Why is that? I use similar control source code for s... 3 25.08.2006 11:42:02 Query of 4 tables (control source) for a report - duplicates Hello, I wouldn't say that I'm new to Access, but would say that I've got a lot to learn and get very frustrated when I can't get it to do what I think it can do. And I know it can do alot! My goal is to merge to a Word document (our resource directory) or export a report in RTF format that I can pull into Word. Here is my frustration: I have put together a, sort of, co-op preschool... 3 25.08.2006 05:07:02 Logo in multiple reports Hi Any advice on the following would be appreciated: The company has numerous reports in which they want there logo to appear. The logo is a bmp image. Is it necessary to embed that image into each report or can the image be linked to the reports which would make maintenance a lot simpler if the logo should be changed. Using Access 2002 TIA Tom ... 4 25.08.2006 05:01:28 Printing problem Hi Access 2000 sp3. We print a report on OKI 3391 ML (actually using the Epson LQ-1050 driver) with a custom form size. Recently we re-did the dell pc that the printer is connected to using the original win xp disk that came with the pc. Since then the report printing has developed the following problem; The report prints parts of report text double i.e. it prints over twice some por... 12 25.08.2006 04:05:51 How can I print screen a report? I need immediate help!! Please Hello, I want to create a button on a form that will print that form as report. Is this possible?... 4 24.08.2006 23:07:50 Crosstab: show contents of field rather than sum? Hi, I've been scouring the Crosstab postings hoping for help on my specific issue, but can't seem to find exactly the answer or the problem: I have a table of data that shows Companies, Cities and Products. I would like the report to be laid out crosstab-fashion with Cities as the Row headings, Products as the Column headings, but instead of data being summed or counted, I would like t... 13 24.08.2006 22:51:02 picture in report I'm trying to build a report with pictures. I found the below code online. It 'kinda' works. One of the quirks is that if I hold my mouse over the reports name in the DB manager, the screen starts flickering like it's pre-loading pictures before I double-click it. Next quirk is that whne I do initiate it, it will load a couple pages then crash Access. Not good! Is the below just way to simple... 3 24.08.2006 22:20:20 Summing Value in Header row How do you sum a value that is placed in a header section. For example, the data being returned to the report looks like this (3 Rows). Salesperson Customer Product ProductCost SoftCost Steve A 1 $2,000 $500 Steve A 2 $5,000 $500 Steve B 3 $4,000 $450 The first Header is for the Salesperson, the second is for the Customer an... 2 24.08.2006 22:08:57 Can I use a field in a form more than once? ... 2 24.08.2006 22:07:05 Need continous form .html report Question I am using Access 2003 and have a report I need to generate in .html format - which I can do - but it is one page at a time with a Next - Previous etc at the bottom of each page - and I don't want these end of page breaks. I have a macro generating the report but the format is wrong. I want this to be all one continuous page without these page breaks and I know I'm suppose... 1 24.08.2006 21:26:25 concatenate child records I've reviewed Duane Hookom's generic concatenation http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Generic%20Function%20To%20Concatenate%20Child%20Records'e I'm really struggling with this. Here's my structure: tblProfiles.txtProfileID is in a 1-Many relationship with tblProfilesAllergens.txtProfileID. Here's the SQL for the field I created: Allergens: Concatenate("SEL... 21 24.08.2006 19:46:02 Can't size a report to fit the page We recently converted our ACCESS 97 db's to ACCESS 2003. I have one file that contains a few tables and a report. In the 97 verson of the db, the report width is small enough to fit on a landscape letter sheet of paper. In the 2003 version the report is so large that you can only see about 30 % of the header width across the entire page. I have probably converted 200 databases and this is ... 1 24.08.2006 19:12:03 Print Report for current Invoice Number I have a form with invoice data and would like to print a report with a button on the form. My problem is I don't know how to tell the report to print for the current record's invoice number. Any help would be great. Thanks ahead Maureen ... 5 24.08.2006 16:33:16 253 Pages: <<  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  40  >>