| Thread | Last Post | Replies |
|
| Report Footer and Grand Totals on one page | 21 Dec 2005 17:03 GMT | 5 |
I have a multicolumn report that I sum all the information and have place the sum of that into the report Footer for a Grand Total. Is there anyway to put the grand total on the same page of a multi column report instead of it printing on a new page??
|
| Filtering a report used with OutPutTo Method | 21 Dec 2005 16:44 GMT | 5 |
I have a report that users can select multiple filtering conditions. I use the Where Condition arguement of the OpenReport method to either preview or print the report. It is also a requirement I allow the user to export the report to Excel. I have no problem using the ...
|
| Displaying data in columns rather than rows | 21 Dec 2005 16:20 GMT | 1 |
I'm new to vba, so forgive my ignorance, anyways I have a list of times that I generate from a query. I would like to display those times in columns in a report. However, everytime I try, I can only get it to display in one column and a lot of rows. The max number of columns ...
|
| Extra pages in reports using subreports. | 21 Dec 2005 16:19 GMT | 1 |
I am trying to use a subreport in one of my reports but when I do I get this annoying extra page every other page. How do I stop that from happening. I searched and found the post about using "Me.pagebreak1.Visible = Me.subrpt1.Report.HasData" and I tried that but it gave me an ...
|
| How do I find out in Report_Open if the Report is opend with a fil | 21 Dec 2005 16:10 GMT | 6 |
in an ADP I want to discover in the Report_Open-event, if a filter or where-condition is set by DoCmd.OpenReport. If not, I want to ask the user for a parameter. Thanks.
|
| How do I create a report for a specific user input in access? | 21 Dec 2005 15:35 GMT | 1 |
I am trying to create a report based on user input. I ask user to enter the product number and base on that number a report will be generated pulling other data in that matches the specific record. For example, I enter product# 20 and that record has other information such as ...
|
| report to open to a specified id number | 21 Dec 2005 14:07 GMT | 2 |
I have a report that I want to display all my radio traffic. I want to be able to use a command button to open the report but have it specify the id number of the record that I am in only to generate that information. Now I am able to do this with opening a sub-form but I have ...
|
| 18 chracter | 21 Dec 2005 14:05 GMT | 7 |
I need code that can make calculate field [info] and then will do as this explained: If [info] > 18 chracter then print 18 of the [info] & But if the last word be more than 18 character then
|
| Lebans report2pdf | 21 Dec 2005 12:02 GMT | 1 |
Hi with regards to Lebans new report2pdf, is there somewhere/somehow to determine where the pdf is saved. i want to be able to incorporate an email function of attaching the converted pdf automatically (which i have code
|
| Sorting a report by an option button value | 21 Dec 2005 05:46 GMT | 2 |
I have a form that uses an option buttons there is about 10 option button all tying into one field called auditType. When I want to print a report I would like to have the report print ascending based on the value of the auditType. For example if I select auditType 5 I want ...
|
| Compare two records | 21 Dec 2005 05:19 GMT | 3 |
I have a database that tracks payments on loans going back over 10 years. One table has loan information...another has payment information, by date. A report exists that essentially starts with the beginning balance of the loan...then lists each payment and creates a running ...
|
| Report shows null values, how to convert to a zero | 21 Dec 2005 03:43 GMT | 1 |
My report comes from a Crosstab query. I have one row Part No. and two columns, PASS / FAIL. Many rows have data in both columns, but some only have data in one column. Example.
|
| Create SnapShot File on Deactivate. | 21 Dec 2005 02:32 GMT | 2 |
When I view my University Labels File and go to close it I want to create a SnapShot file. On DeActivate I have the following code. This code fails without a halt or message. Does anyone know what I am doing wrong?
|
| access data (numbers) do not format correctly in merge to MS word | 20 Dec 2005 22:40 GMT | 2 |
I use a query to extract computed data. The data is formatted correctly in Access. BUT when it merges into word, the formatting does not remain. I have tried to format the merge code in word but this does not work either
|
| Automatic Email Report | 20 Dec 2005 22:31 GMT | 3 |
Hi: I curently have a report built off of a table in a database. Is it possible to create a macro that would generate an email and attach the report to it?
|