| Thread | Last Post | Replies |
|
| sum a group of fields in the report | 12 Oct 2005 17:24 GMT | 1 |
I am having a problem with totalling the "Extended Price" field by Invoice in the Report. The total should appear only at the end of the group of products for one invoice, but it appears after each product line. I created the Invoice Header with the Detail, and put the text box ...
|
| Preview Multiple Reports | 12 Oct 2005 17:12 GMT | 5 |
I have a form with report parameters in combo boxes and a Print Preview command button. I use DoCmd.OpenReport stDocName, acPreview to run the report and open the preview window. Currently I can only open one preview window. What I'd like to be able to do is have the User ...
|
| Running code in a SubForm on the main report | 12 Oct 2005 16:50 GMT | 3 |
I have a system that order new street signs, I have a form which I use throughout the system which, draws the sign, depending on the values stored in a table. It works well on subforms as part of a main form, as the code runs when the subform is activated when the main form ...
|
| advice on better report design - opening/closing balance | 12 Oct 2005 16:42 GMT | 1 |
Hello Group, I have a table which contains transactions (in and out) of a stock item. The objective was to create a report based on a user specified period (date1 to date2) to display, the opening balance at date1 , the individual trasactions
|
| My report is not pulling the data from my forms, can you help me? | 12 Oct 2005 16:20 GMT | 1 |
Hello, my reports are not printing the data from my forms, it was before when I previewed it, but when I moved around the fields to make the report look presentable, now when I preview the reports its not printing any of the information. Can you help me, and tell me what to do ...
|
| Access2000 report isn't running correctly in Access2003 | 12 Oct 2005 15:21 GMT | 1 |
Does anyone know if there is any incompatibility between Access2000 and Access2003. My Access2000 report is not running correctly in Access2003. Only the first page of the report is correct, all additional pages are not retrieving data in certain fields.
|
| Re-printing a group heading if detail advances past one page... | 12 Oct 2005 15:20 GMT | 1 |
Is there a way to have the group header repeated for a detail group if that detail group happens to advance onto a 2nd (or more) page? I have been asked by some users if I can print that group header again so they do not have to look back to see what the group the detail lines ...
|
| How to cancel print of a detail line if number lines exceeeded? | 12 Oct 2005 14:48 GMT | 2 |
I have a case where after 20 detail lines have been printed for a particular "group" (the group happens to be salesperson), I would like the detail printing to stop for that group and to simply begin printing the next group.
|
| Summary report question | 12 Oct 2005 13:26 GMT | 1 |
I have a complicated invoicing system. The design wasn't that great to begin with and when I took the project over I wasn't allowed to modify tables. Right now there is a customer table, a non-customer table, an invoice table,
|
| Papersize ACCESS and WORD | 12 Oct 2005 13:15 GMT | 2 |
I would like to use my DYMO Label PC Manager with an Access Report. In a WORD document I can setup the size of the paper whatever the printer I choose. This operation cannot be done inside my Access reports.
|
| Formatted 9 digit zip | 12 Oct 2005 13:06 GMT | 14 |
I am using Access 2002 and the Label Wizard. I use a query as input and the table with the data has the input mask set for the 9 digit zip. The query output is formatted correctly 99999-9999, but he label report is not formatted. I tried it in 2000 and it works fine. Any ...
|
| Difference between 'Preview' and 'Print' | 12 Oct 2005 10:08 GMT | 1 |
In preview is the report layout good but when I print it ,some line are moved I made a snapshot (on screen good, but on the print same problem) I've seen the measurings in design view are also correct I print it with a HP Laser 4L, is it a problem with the printer are
|
| Identifying records from a query to be reported | 12 Oct 2005 08:40 GMT | 4 |
I am working on what will be a very large database and when a search is made a large amount of data is returned. This is not due to any failing of the query or database design, but simply the nature of the data being searched and the requirements of the users. So happens is when the ...
|
| Cross ref to a sub-report | 12 Oct 2005 07:37 GMT | 1 |
In a report I run, the details of my personnel, who should hold a certain qualification are displayed. In the sub-report included in the report , lists all personnel who hold the qualification whether they need to or not. This way I can identify the level of training required.
|
| close report when there is no data to display | 12 Oct 2005 06:34 GMT | 1 |
What code would I use to automatically close a report that has no data? I have played around with the 'on no data' code but am not good enough yet to get it to work. Please help!
|