Reports
in [Access]
|
Conditional Formatting Access 2007 I am using conditional formatting for the backcolor on some controls in the detail section of the report. When I view the report in Print Preview, the backcolor does not appear. When I view the report in Report View and click on the control, the backcolor appears. When I click on the next control, that backcolo... 10 May 2010 16:34
Reports and DoCmd.OutputTo ... acFormatTXT... An application produces a number of reports, which are saved as text files (using DoCmd.OutputTo acReport, stDocName, acFormatTXT, "filenamex.txt") each of which is transferred to our mainframe where they are stored for long-term viewing. Some of the reports have no spacing issues, but those with a significant... 10 May 2010 15:27
Crosstab Report I searched, and tried to utilize the answers I found, but I don't have the skills to make them work. I have the crosstab query shown below which works fine when the results are in datasheet view: TRANSFORM Max(DetailTbl.DetailID) AS MaxOfDetailID SELECT EmpTbl.EmpNo, EmpTbl.Lname, EmpTbl.Fname FROM TrainDocTb... 10 May 2010 16:34
Report from 2 tables Hi Just wanted to get some advice before I attempt to make a report that will use 2 tables as source material. Basically, my database stores information on a sport. One table is a list of teams and their historical venues/successes etc The second table is a list of the teams annual results. The report I wan... 10 May 2010 13:13
Update - Microsoft Responds to the Evolution of Community What is Happening? This message is to inform you that Microsoft will soon begin discontinuing newsgroups and transitioning users to Microsoft forums. Why? As you may know, newsgroups have existed for many years now; however, the traffic in the Microsoft newsgroups has been steadily decreasing for the past sev... 10 May 2010 03:22
color text in report I have a 3 text (High , Normal , Low ) in filed bound to txt.remark filed , I want in print out [txt.remark] appear in a diffrent color depending on value in feild [Result] , I tried to do this but i couldn't this the code that I write it Dim txt_Remark As String Private Sub Report_Current() ... 7 May 2010 20:04
Report showing #Error on a valid SQL View I have an Access app with an SQL Server backend. One report is based on a VIEW. When I run the view alone all the data is visible. But when I run the report, I get #Error on one field. The field is numeric. However, the RecordSource property of the textbox is: [MyNumericFieldFromSQLView]/32 What's strange i... 7 May 2010 17:52
Remove multiple rows of Null fields in a report I have created a report with multiple lines of data that could be null. I set the fields to "can shrink." It does shrink the line and move it up a field but if I have multiple fields in a row it does not bring the field all the way to the top. Any ideas? ... 7 May 2010 17:52
How to Imporve Report Perfomance I developed a report and it takes literally 30 minutes to open up. How do I improve performance. The data set is a local table that is not on the back end of the database. However there are about 4 sub forms on the report. These subforms are all queries. I requery the subform queries prior to opening up the report.... 7 May 2010 17:52 |