Reports
in [Access]
|
saving reports no more possible L.S. When I make a new report or make some changes in an existing one and I try to save it, I receive a message that the process is stopped because another user is busy with the same object. But there is, and has never been, no other user. When I close the program without saving, I get the question 'will you s... 4 Jul 2008 16:09
Report to display SQL code Hi There I have a form with 17 checkbox options for the user to select. Once the user selects the checkboxes he then clicks a button that is suppose to run a report. based on the options selected this report is to display sql syntax that goes with that particular option. This report is to assist our Reporter... 4 Jul 2008 07:57
Case statement Problem I am having trouble with this code can anyone help. I have the follwing case statement that checks the value of the combo box, and based on that it will select which report to print, but I can not get it to work Select Case ReportPrint Case "Me![Combo28].column(1) = Like'B*'" stDocName = "Pr... 5 Jul 2008 10:28
how do I force a report page to print over 2 pages in Access? I have a report that I want to print over both sides of an A3 sheet of paper but the detail section won't go that wide. The report is for a sign-out book and the fields have to be wide enough to put handwritten detail in. I wondered if it was possible to set the paper size to A2 and then print to A3, but A2 i... 7 Jul 2008 08:23
Change Chart Type Dynamically I am trying to change a chart dynamically. I have coded the following in the open event of the report: Dim XGraph As Object Set XGraph = Me![OLEUnbound0].Object XGraph.ChartType = xl3DPie I receive the message: Run-time error 2771. The bound or unbound object frame you tried to edit do... 5 Jul 2008 15:35
Solved - inconsistant reports in Access 2007 The answer to the problem with the inconsistancy that I posted last week has been solved in that I found a fix. I can not however explain why it is inconsistant. Apparantly when the report was developed a text box, Text143, was created. Its use must have involved some sort of action to be taken BeforeUpdate.... 3 Jul 2008 16:38
Disable Sum of Field in Detail Area I am new to using Pivot Charts in Access but I have some experience in Excel; not a lot. I do not need to Sum the field that is in the detail area of the chart and I cannot eliminate that field button with eliminating the data from the chart. Am I using the right method to create a chart for a report or shoul... 3 Jul 2008 15:36
multiple records into one cell I am creating a database in 2003 and am trying to see if there is some way to combine records like there is for fields for when I am exporting the report to excel. Currently it puts each name record in its own cell and it would be much easier on me for them to be in one cell. ... 12 Jul 2008 19:43
summary report I would like to have a summary on the report footer with individual details is it possible? The report like following: Jun/20 Jun/30 Jul.01 Student 1: Math 80 85 90 English 70 60 75 Student 2: Math ... 4 Jul 2008 07:57
Database crashes during the process of development Hi, I need to make continue changes to my database, like adding codes, reformatting forms and subforms such as to make them taller or wider. However Access frequently crashes poping up messages saying "there is not enough memory" while what I did was adding a little bit code which usually compiles and runs... 8 Jul 2008 16:11 |