| Thread | Last Post | Replies |
|
| Calculating Difference In Time For Age | 13 Jul 2005 18:41 GMT | 18 |
I am working on a report for a neonatal unit which requires the specific age of the newborns through a series of tests. I have two fields each holding a date and time, one field for the birth date and time...the second for the test date and time. They are formated as such: ...
|
| RTF2 ActiveX control stretches text in reports | 13 Jul 2005 17:41 GMT | 3 |
I am a fairly new user of the RTF2 ActiveX control, by Stephen Lebans, and I am having a lot of trouble printing reports. I am using Microsoft Access 2003 on Windows XP Pro SP2. I have written an Access application that allows teachers to create
|
| Report with table update? | 13 Jul 2005 17:28 GMT | 9 |
I am working on a report, now completed, that prints out an invoice of all items used for a customer. All looks good and is ready to go. However, I am now pondering the best way to update all the invoices that are printed so that the flag in the table changes from "P" (For ...
|
| help with math expression | 13 Jul 2005 17:17 GMT | 2 |
I have 2 fields: THW and TAF Here is what I am trying to accomplish. THW - 40 = X X - TAF = what I want to show in the new field.
|
| 'Order By' phrase for Report in Access 2003 | 13 Jul 2005 15:39 GMT | 6 |
One of my forms open a report as below: DoCmd.OpenReport "rptTest", acViewPreview, "Order By '" & strIDNum & "'", strCriteria, acWindowNormal The strIDNum is read from a textbox, in the form, with no problem. The
|
| printing to a fixed columnwidth text file | 13 Jul 2005 15:34 GMT | 1 |
I need to create an ascii text file containing a header text, followed by the contents of two fields (multiple records) from 3 or 4 tables in a database. Looking at some other code the previous export macro/module used the print character, but how can I set a fixed width for the ...
|
| Conditional Formatting | 13 Jul 2005 15:29 GMT | 1 |
I am fimiliar with using conditional formatting to highlight fields if they meet a certain criteria. Although, one of my text fields contains the following data: "OBP 4.13.0 2004/01/19"
|
| Report won't keep its orientation setup | 13 Jul 2005 14:34 GMT | 1 |
I have Acc2002 reports set for landscape. They work fine when printed by using docmd.openreport. However, they are printed in portrait when printed by using report variable, such as set xxx=a_report, xxx.visible = true, though their previews look in landscape. Could anyone shed ...
|
| Report Page Index (Table Of Contents) | 13 Jul 2005 14:26 GMT | 2 |
I have a catalog I’ve created as an Access report for which I need to create a page number index. Does anyone know of a way to do this?
|
| Report sum problem | 13 Jul 2005 13:50 GMT | 3 |
I basically have a report which is populated by a query. It basically lists different types of staff and then gives totals for heads and wte (whole time equivalent). At the bottom of the report I total up heads and wte using a sum and textbox.
|
| How to find information on Creating Graphs | 13 Jul 2005 13:45 GMT | 1 |
I am trying to create interactive charts in Access that will drill down on the graph values and open a second or third graph. I have used Access graphs in the past and not found them attractive or functional and usually end up with North South East and West Jargon. Am I being too ...
|
| Top Property | 13 Jul 2005 13:34 GMT | 3 |
I'm using code as follows: If [NumLines] = 5 Then [1stLine].Top = 0 End If
|
| calculating other fields based on a formula in a report | 13 Jul 2005 13:09 GMT | 16 |
I have a report that has a calculated weight (based on a query )that is the sum of other fields in the query. How can I store this information or pass it on to another field on the same report?
|
| report | 13 Jul 2005 07:45 GMT | 1 |
How do I turn off the border around combo box feilds in a report. I have tried setting it to transparent, setting it to solid with color equal white. Every signal time though I have a few combo boxes that print out with a black border. The only other thing I know to try at ...
|
| Problem with Can Shrink/Grow | 13 Jul 2005 07:07 GMT | 8 |
I have tried everything to get a GroupFooter section on my report to shrink if a textbox is empty, but I'm really not having any success. The control is unbound, and is only populated and visible if certain criteria are met (via Print event). When the criteria is met, the control ...
|