| Thread | Last Post | Replies |
|
| Memo field cut off on report | 12 Apr 2007 21:05 GMT | 4 |
I am fairly new to access, so please excuse my ignorance. I have a report with a memo field in it. This field is cut short in the middle of the third line. I have can grow set to yes and all the information fits fine on the table. What have I don't wrong?
|
| send to mail recipient (as attachment) command button on toolbar | 12 Apr 2007 20:44 GMT | 4 |
I have an Access Application created in Access 2003. I have added the Send to mail recipient (as attachment) command button to the print preview toolbar. On my computer using Access 2003 it works fine. At my clients who uses Access 2000(9.0.2720), the button is greyed out.
|
| new fields | 12 Apr 2007 19:46 GMT | 2 |
When I add new fields to a table or query that is feeding a report, those new fields do not show up on the field list for the report. Is there a way to get them on the list as available fields for the report or do you need to start the whole report over again to add a new field?
|
| Combine multiple records in single table form row? | 12 Apr 2007 18:22 GMT | 2 |
I would like to know if it is possible to combine data from multiple records (that share a key value) into a single row in table form. I have seen that there is a concatenate function where I can string them all out with commas but I would like to know whether there is any way ...
|
| Counting different occurances in a field | 12 Apr 2007 17:24 GMT | 5 |
If I had a field name "store #" (in table this listed as a number for sorting purposes). Each record would have a non-unique store number assigned to it. Store # Need 1 Box
|
| break word in reports | 12 Apr 2007 16:36 GMT | 1 |
I have a text field in table. When I print report based that table, the word in text field break apart. Example : data in text field : "This is a dangerous film" But in report : This is a danger
|
| Pie Chart | 12 Apr 2007 16:16 GMT | 5 |
I want to create a pie chart in each detail section of a report that contains fields from the single record in the detail section. I can get a bar chart of this data, but not a pie chart (I just get one field that is 100% of the pie). Is there a SQL statement or something I am ...
|
| Left Align (trim) in report issue | 12 Apr 2007 15:21 GMT | 1 |
Basically I have a table that is set up to auto import data from a TXT file and from a query produce a report with the field (text) sorted in numerical order. The problem I have is some of the data imports leading spaces as well as the text. I need to left align the data and ...
|
| CanShrinkLines() problem | 12 Apr 2007 14:59 GMT | 5 |
There is a function in the Access Help and How to on Eliminating unwanted blank lines in labels and reports. http://office.microsoft.com/en-gb/access/HA011494721033.aspx It appears to be exactly what I want but I can't get it to print more than
|
| Dynamate report creation....help | 12 Apr 2007 03:56 GMT | 3 |
I have the following code to generate an Access report based on an Acsess query. It depends on the number of columns (up to max. 31 that is the max number of column headers I can assign to the letter size paper in landscape mode) in the query and it will construct the report for ...
|
| How to Print Path information on a report Access 2007 | 12 Apr 2007 00:28 GMT | 2 |
I used to be able to print the PATH information at the bottom of a page or at the end of a report. Now, I can't seem to find the same information in Access 2007. It must be simple, but I need some help anyway. Anyone???
|
| Print multiple reports from unique ID | 11 Apr 2007 22:26 GMT | 3 |
I have a report which runs off a table and it works great if I only populate the table with one part ID. However, this report has grown so popular that I need to run it for over 300 part numbers and was hoping to do this more easily. I hope someone can help with the code which ...
|
| Failing to print fill colour of conditional formatting | 11 Apr 2007 22:20 GMT | 1 |
I have recently designed a report in Access 2003. I have utilised conditional formatting in order to change the fill (background) colour of certain fields. The conditional formatting was applied by use of the conditional formatting wizard (not manually by coding).
|
| How can I choose which Clients to run a report on? | 11 Apr 2007 20:56 GMT | 1 |
Hopefully I can explain this well enough. I have a very large linked table that holds all of my information. This includes Client Name, Farm Name, and Field Name (what clients call the field within the farm, such as Home Farm, North Field). It also holds fertility, soil types, ...
|
| summing in report | 11 Apr 2007 20:05 GMT | 2 |
I have a report that has a running sum of Total Hours and Total Money. The problem i have run into is, 14640 hours need to be multiplied by $45 and the rest of the hours from now on need to by multiplied by $51... How can I go about doing this without re-creating my report?
|