I am trying to create a 5 page report filled with colorful tables, charts, and graphs. This report will need to be reproduced 115 times. I am almost finished with page 2 of 5. When I try to start page 3, it appears that the height of the report is capped.
I have reset my computer to clear my RAM, but I still have the same problem. I try extending the length of the report, but the window will not scroll down beyond 22". Is there a way to extend the height of the report?
Thank you in advance, and I will try to answer your question in return.
I have a report which programmatically sets the value of some labels based on its own internal logic for each line of the detail section of a report. This all works fine and dandy, using the Detail_format event, and accessing detail.controls.item(x).caption.
HOWEVER, when I then embed the report as a subreport (which I need to do), I goes wrong. Here, I get the values of the last row of the detail repeated in every previous one. I'm suspecting because the parent report has its own 'detail' (I've tried giving the subreport its own distinct detail name).
I need to create a report for each employee in my company of all compensation information. The report is going to need to have multiple detail sections on the report for example to list all benefits specific to the employee and all beneficiaries.
I tried using a subreport to produce those detail sections that I needed but once I placed this subreport inside a box on the main report each detail I created increased the size of the box. I also thought about making the detail section a list box and writing all of the information there. Would there be a better or easy way to accomplish this?
I am also thinking I am going to have to save all of this information in a table and based the report on that table?
Is there a way to only highlight the last row of the detail section in a report?
I tried the following code in the "Format" but could not get it to work in Access 2010.
If Me.ClaimStatuses = "Total Potential Recoverable" Then Me.Section(acDetail).BackColor = vbYellow Else Me.Section(acDetail).BackColor = vbWhite End If
Where "ClaimStatuses" is the control text box and "Total Potential Recoverable" is the value I want to equal so this row which is the last row will be yellow.
I have a report that prints invoices, and in the page header area it contains most of the invoice information such as labor cost, customer info, etc. In the detail section of the report i have the line items, and a line contains a part, vehicle charge, etc. Some invoices dont have any line items though, and it seems that when there are no lines(ie. nothing in the 'detail' section), the header information will not appear either. Any ideas on how i can fix this?
In the detail section of my report, I recently added a second row which has only 1 text field. When the value of the textbox in the 2nd row is null, I want the total row height equal to just the first row. When the value in the textbox in the 2nd row is not null, then the total row height is equal to row 1 and 2. I tried to make the textbox in the second row invisible when it had a null value thinking that when it was null, the report would shrink to the first row height, but that didn't seem to work.
We are creating a report and for some reason we can no longer extend the detail section of the report. It has stopped at 2 A4 pages length and won't let us extend it further. We have about 7 pages of the report, I didn't think this was too much?
I have a main report with 2 subreports. My main report has a header section, the 2 subreports are in the detail section of my main report. How can i prevent my report from splitting up my header and my subreports. (Header section of my main report is a company and the subreports are the detail of the company.. i don't want my compnay name on the bottom of a page and then the detail on the next page.. it does this sometimes. thanks!
I have a query with various entries, pertaining to various invoices. Each line of the query corresponds to a piece of work done, and there may be several lines in the query pertaining to one invoice. I've written the code to input data to a report.
If there are multiple lines in the query to be added to the one invoice, I don't know how to write code that will add those multiple lines in the detail section. Same type of data on each line, just basically pertains to several different lines of work.
I have a main report / subreport relation, just want to have a fixed length of each printout. e.g the total number of lines of the subreport should be 8 lines. However, lots of subreports contain records less than 8. I would like to know how to insert of blank line in the subreport depending on the records with content at each print, in order to make the total number of lines in each subreport is 8 each print!!
I have a main form (Parent) along with a subform(Children). I want to have a button that generates a report with the Parent information as a header and the items in the subform as details. In addition, I want the report to show only the children that were recently added not all of the children.
I'm trying to create a report where I can use a section header as a hyperlink to show/hide detail, but only for that section. For example, my customer names are:
Code: ABC Co. ZYX Co. 123 Co.
If I click on ZYX Co., I want it to show the contracts for ONLY that customer:
I have a sub Report in the detail section of its parent. I need to hide the detail part of the parent if the subReport corresponding to the record has no data. Here is what iam trying to do but failing, any ideas... Private Sub Report_NoData(Cancel As Integer) Me.Parent.Section(0).Visible = False End Sub
I have a problem figuring out a solution for following problem.
I have a database of details and their properties. All the details have been described in one table. As there is a need to describe groups of details I have found myself in a hard situation that needs to be resolved. The structure of described detail groups is as follows:
Product
Detail Group1
Detail groupx etc.
Detail4
Detail groupx etc. Detail groupx etc.
Detail1 Detail2 Detail3
Detail Group2
Detailx Detailx
Detail groupx etc.
Detail groupx etc.
Is there a way of decribing my products in access so that there are no limits of how many groups does a product have and how many levels of groups the product have.
i'm using Master and Detail table. Master table i have TaskId, ResId where ResId is mapped to Detail table which contains resource working on the task. i want to generate a query where for each task i want to display resource id in single column like below.
Task Id Resource Id 1 222,233,244,255
Do i need to use recursive query or any other method to get results like above.
to hide a subform on my form that is in the detail section of my form.
Is there a way to collapse or Hide the Detail section of the main Form??
I notice that their is a property under the Detail section called Visible with an option for Yes or No.. How would I manipulate that option through VBA? I am assuming that is the option that I am looking for
I have a problem here... i need help... could someone know that how to using a combo box to edit the details?
Now i am using the Employee Name as my primary key and i set it as a combo box to let user to select the name and list all the detail like IC, Job Position, Date of Employment and etc. But when i try to edit the detail of the employee, the access program do not allow!! And i know is because i am going to create a duplicate record by the employee name.
So, do someone know how to use the combo box to list out all the details and after i doing editing by pressing a 'Save' button then the detail just change without creating a deplicate record? Maybe someone just give me a little bit idea then is enough... Thank you!!!!
I haven't used Access in a couple of years. I created a DB some years ago where I did not want the users to be able to view/change the forms, queries, etc.
I only wanted them to be able to view the "finished" product and do the data input.
I remember there was an "alt+key" combination I hit when I opened the db file in order to view/change queries, forms, etc.
Now, I've forgotten the key combination at open which allows me to see the details of the db.
I have some formulaes in that old db that I now need.
Could someone please advise on the key combination at open which will allow me to view/modify the details of the db?
I am looking for a way to only print the detail section (no header, no footer) using a print button on a form. it also needs to fit to 1 page. do i need code for this or is there a property that can be adjusted?
I have a fax number field iwhich has a mask. +(000)-00-000-000 in a table of many records. The problem is that every record has a number in the first part of country code +(001)which must have come there by mistakes, few records have complete and true fax numbers.
I need a query that can Update this Fax_Number field where the length of the string is less than 7 digits. Some thing like UPDATE Contacts SET Contacts.Fax_Number = "" WHERE ((Len("Fax_Number")>"6"));
