| Thread | Last Post | Replies |
|
| Promting, Forms or connect reports? | 08 Nov 2007 22:29 GMT | 2 |
I have a report which totals differents tests and program statuses of herds. I had to put 6 querries into 6 subreports of the main report to keep the datasets distinct. All of them have prompts for a date range and all the date ranges are the same so I have to enter the same ...
|
| Highligting data in report by clicking control bottom on a form | 08 Nov 2007 21:10 GMT | 5 |
I've tried to figure out how can I highligt specific record row on a report, and this by clicking a check box on a form, but till now no success. Consequantly, if anyome knows how can I do that, please help me,
|
| In a report, is there any way a record will change color if it's different from the previous record | 08 Nov 2007 19:52 GMT | 2 |
Hi, I am working on a project where I need to color code the report so it will distinguish if the previous record is different from the current record. Because the record will have many similar record, so I am trying to group the record so it's easier to look. In a report,
|
| Selecting a report range | 08 Nov 2007 18:53 GMT | 5 |
I have a form that I use to choose the range of a report. The form has a combo box and if this is blank I want all the records but if there is a value I only want the report to shown the equivalent records. Here is my code
|
| Calculation Expression Help | 08 Nov 2007 18:31 GMT | 3 |
I have a group footer where I have successfully put in some controls that give me the sums of a number of fields. Now I want a text box control that will give me a percentage calculation for two of those sums. I can't figure out how to write the expression. This is my latest ...
|
| Display SQL Code for a Query | 08 Nov 2007 18:27 GMT | 1 |
How might I display the SQL code for a query in a report?
|
| 2003 margin management | 08 Nov 2007 18:17 GMT | 3 |
In Access2003 sp2 A report's margins per file/page set up show .25 for 3 sides but .516 for the right side... this makes the report look skewed to the left with too much white space on right.
|
| How do I show hyperlinked images opened in a report | 08 Nov 2007 17:08 GMT | 1 |
I am a newbie to access and I was wondering how I can show hyperlinked images opened in a report. I have viewed other threads and it seems possible, but I can not figure it out. I currently have a table with over 2000 records and up to 6 hyperlinked images to each record along ...
|
| Report - Analyze with Excel | 08 Nov 2007 17:02 GMT | 3 |
We just upgraded to Access 2007. I have reports in there that at times I need to put into spreadsheet form. To do this before I had the option to "analyze with Excel" it is not an option that I see anymore. Can anyone tell me where this is or what I can do?
|
| Can Access 2007 analyze w/Excel? | 08 Nov 2007 17:00 GMT | 5 |
I have installed Office 2007 and I am not able to locate the option to Analyze a report with Excel. I was able to do this with Access 2003 and it would put all the data from a report into an Excel file. How do I do this in Access 2007? I do not see the option anywhere after ...
|
| I want to condense a report when fields are empty | 08 Nov 2007 15:44 GMT | 1 |
Access 2003 I am trying to create an annual report of students attending Assemblies. Some students have attended multipal assemblies while other have attended only one. I have given each assembly it's own field. What I would like this
|
| Weekly report | 08 Nov 2007 15:32 GMT | 1 |
I need to create a report and have no idea how to start. If anyone can walk me through how to set this I would be extemely greatful! I have a table called tblDetail. In this table are the following fields Autonumber, Date (=now), and other
|
| #Error | 08 Nov 2007 15:04 GMT | 4 |
I have a text box with this source:=[Reports]![rptFGPackConfigurations]![srptFGPKPrimarySecondaryResources]![SumWt]+[Reports]![rptFGPackConfigurations]![srptFGPKTertiaryResources]![SumWt] How can I revise this so that the text box will properly display if one of the [SumWt] fields ...
|
| Can I set up default Header/Footer fields? | 08 Nov 2007 13:40 GMT | 1 |
the The majority of reports I create have the same logo and title format in the report header, and the same fields in the page footer. Is there any way these can be set as a default? I understand that controls won't work in a template, only overall formatting.
|
| Export don't show all Textboxes | 08 Nov 2007 09:10 GMT | 2 |
I have a report which calculates on an condition some textboxes: Private Sub Detail_Print() If Me.Text62 > 30 Then 'Me.Text62.Visible = False
|