Threads Replies Last Post 253 Pages: <<  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  31  32  33  34  >>   Snp to PDF sometimes generates rubbish the SNP to PDF program from lebans sometimes generates question marks instead of text. I have a database which contains english text and some ancient greek text- the reports are exported to snapshot files and the the lebans snp-to-pdf program (recommended by this user group) to enable double sided printing. This genrally works well but some pieces of text do not convert properly and jus... 4 05.09.2006 21:03:27 Reports don't display but go directly to printer I sure would appreciate some advice on this problem. I've asked before but got no response and I'm getting desperate. I have had this problem happen twice now. I create a report that works successfully. I then modify it in such a way that I need some code in the OPEN event. Once I do that, the report goes directly to the printer and I can't get it to display on the screen first. E... 2 05.09.2006 20:31:22 checkbox will preview but not print Hi, I have check boxes on a report that will print when there is very few records in the database but when more records are added the check boxes will not print although they do show in the printpreview. This DB use to work! Any suggestions pls. Karen... 1 05.09.2006 19:58:01 footer shrinks My report footer shrinks up to the bottom of the detail. I need it to remain at the bottom of the page. I've set the footer's shrink property to "No" but that's not changing anything. The detail is set to grow and shrink. How can I anchor the footer to the bottom of the page? Thanks! -- www.Marzetti.com... 3 05.09.2006 19:08:01 Error 2448 in the OnFormat event Where do I change the ControlSource of a text box in the Page Header? I tried doing it in the OnFormat event of the PageHeader section, but got a runtime error 2448, "You can't assign a value to that object." It doesn't work in the OnFormat event of the ReportHeader,either. Do I have to create a label, and assign this value to the caption? ... 1 05.09.2006 18:59:41 print detail records on 1 line in report in access I need to print individual records (3 numbers ex:111) on the same line like this: 111 222 333 444 555 443 ... 2 05.09.2006 18:39:41 Value from unbound form control I have a table for Vendor information, with a related table for PhoneNumber since each vendor may have several. The PK in tblVendor and the FK in tblPhone are both named VendorID. They are both Number fields (autonumber in tblVendor). The vendor information appears on a form (frmVendor) that is bound to tblVendor. The Phone information appears in an unbound list box (lstPhone) that g... 8 05.09.2006 18:37:21 Specity fixed criteria in a reportheader I have one more challenge. In a query, I use fixed criteria. I need to print these criteria in the header of a report but I do not know how to do this. When the user is prompted for the criteria, I know how to print these criteria using [Enter date from] e.g. But how can I reference fixed criteria? Thanks for the help, Ron ... 6 05.09.2006 18:21:52 Charts on a report I have made chart from a query and have it on a report in the detail field. The chart seems to repeat itself a few times with the same data. Instead of having one chart per record I have 3 or 4 all with the same data. So how can I get only one chart per record? ... 3 05.09.2006 18:19:54 set recordsource of subreport using VBA Hi, I'm trying to set a subreport's RecordSource property from the parent report but am getting this error: Run-time error '2455' You entered an expression that has an invalid reference to the property Form/Report. The code is entered in the parent form's OnOpen event and uses this syntax: Reports![report_name]![subreport_name].Report.ControlSource The reference ... 2 05.09.2006 17:42:09 Multiple Groupings in report Hi, I have a report that is based on a query. This query has two tables with a relationship. I want the report to have two groupings but cannot get the data to print correctly. For example, tbl_fruit (group #1) has apples, oranges, bananas, etc. Group #2 has types of apples, oranges and banans. So, I want the report to print: Apples MacIntosh Useful information ... 2 05.09.2006 17:23:31 filtering on subreports Is there anyway to filter on a subreport and have the main report show up based on the selected field in the subreport? I have a main report and a subreport. Based on what the user selects on a form (a field in the subreport), the main report is supposed to load along with the data in the subreport. Thanks. ash... 1 05.09.2006 17:15:02 Title heading Within a report how can I place the title of my report i.e. my heading within every sheet to appear at the top. Also I need a pagebreak for every Agent that I have and for some reason I can only page break after record Many Thanks, Matt... 4 05.09.2006 16:36:15 List report name and record source I have a query that lists all reports, but I don't know how to list the record source with the name since that field is not part of the hidden system table. I know I can use the documentor function, but it lists a single report per page and I have over 1,000 reports. I know I could output it to Word and search and replace, but is there a simpler way? We are trying to cleanup the database... 2 05.09.2006 16:17:25 Field Blank in Report I've recently added a combo box which pulls information from our client list in order to populate the Address, City, State, Zip, Phone, Fax in the new record. Works great. In the report, all of the information prints. Life is Good. In an effort to save space (and paper) on several reports I created a "SortNAME" field SortNAME: IIf(IsNull([ACRONYM]),[ClientName],[ACRONYM]) so the ... 8 05.09.2006 15:25:03 Set zero values for results in Access 2003 Reports I have a report where I calculate days overdue. Problem is if the item isn't overdue the value is negative. I did a conditional formatting so the negative values don't show, however when I go to calculate the average days overdue I get a negative overall value because even though masked the negative values are there. I need to know where and how to program an Iff statement in Access 2... 3 05.09.2006 15:19:02 Email Subject when sending a report Hi I have a form with an email button that sends the current record. Is there anyway that I can get the email window when it opens up to have the word "Referral" in the Subject line? Thanks Colin ... 3 05.09.2006 14:46:58 Print Server Properties / Forms I need to print checks on a dot matrix printer with continuous form multipart print paper. My report is ready and I did some research and I want to ensure the printing remains on the checks which are 7.5 x 3.5 inches. I am testing with an HP ink jet-de-jure. I have read through a few responses and the user is told to open up the printers and faxes, file / server properties / create a ... 1 05.09.2006 14:19:02 Access Rpt or Word Merge - concatenated results Hi, I need to either build a better Access rpt or find out a solution to my Word merge - hope somebody here can help. Main data entry form "frmCase1" has info about case (open date, situation, etc.). 1st subform "sfCaseAppl" has detail records for each kid involved in this case. Another separate subform "sfAppt" has the name(s) of each specialist assigned to this case. Case to Kid is... 2 05.09.2006 14:13:01 format fields within a textbox Does anyone know how to format (italics in this case) a specific field value within a string in a text box? Example - Control source for textbox txtPar1: =("I, " &[DriverName]&", operating under the Company Name " &[BusCo]&", agree to comply with the requirements of the " &[Law1]&" "&[Law2]&" .") I'm putting all this in one textbox because the length of [DriverName] and [BusCo] can va... 5 05.09.2006 14:05:02 Reports with date filters Hi there Im relatively new to using Access and am trying to create a report that will search within data parametres e.g. August - September. Could anyone please advise how to do this? Many thanks... 2 05.09.2006 13:29:36 Publishing to Word from Access I work for the State of Maine, and I use Microsoft Access every day- it's the most helpful tool for my job. I usually print reports, publish them into Word, and then email them in a mass mailing. However, I think that the formatting from Access should be able to be transferred over into Word; lines, borders, and especially check boxes. Many of these things exist in Word as it is, and I ... 3 05.09.2006 07:16:55 Page numbers I have a report which have different groups. If there's no details on the second page (there' re sums there) the report shows page number is 1 althougt it's the second page. What to do? -- Thankful for Your help!... 1 05.09.2006 06:00:01 paper size less than letter size in MS ACCESS 97 How do I set up a paper size that's half letter size?... 4 05.09.2006 02:14:03 calculating column totals in a report I’m calculating payroll in a report: Column 1 Begin Time Column 2 End Time Column 3 =DateDiff("n",[ActualBegin],[ActualEnd])/60 Column 4 - Hourly Rate Column 5 - Actual Pay =IIf([TotalHrs]*[Salary]>50,[TotalHrs]*[Salary],50) Column 6 is an Override (to override previous calculations) Column 7 - Expenses Column 8 - TotalPay =IIf(IsNull([Override]),[ActualPay],[O... 5 05.09.2006 02:12:59 253 Pages: <<  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  31  32  33  34  >>