| Thread | Last Post | Replies |
|
| How do I create a spreadsheet style report in Access 2000? | 16 May 2005 20:07 GMT | 3 |
I'm trying to create a score card with rows down the side of specific information and columns across the top of particular facilities. Rows Site 1 Site 2 Site 3 Site 4...
|
| Short Time Format | 16 May 2005 19:28 GMT | 2 |
I am using Access 97. The report footer has the following field inserted by using the default "Insert Date/Time" option. It is using short time format. =Format(Date(),"Long Date") & " " & Format(Time(),"Short Time") My question is: What does Access do with the seconds? Does it ...
|
| Report fields incomplete when publsihed to Word | 16 May 2005 18:42 GMT | 4 |
I don't seem to have any problems with the formatting, but some memo fields truncate text when publishing to Word from an Access report. I thought it might just stop at 255 characters, like a text field, but it doesn't. It can publish more than 255 characters, but it will leave ...
|
| Sorting & Grouping Assistance | 16 May 2005 17:51 GMT | 2 |
Hi. I have a report which sorts/groups by the columns "Due Date" and "Order ID". Both columns are sorted ASCENDINGLY and both contain both a Group Header & Group Footer. My users need to see data sorted by "Due Date" which is why I sort by "Due Date." My users also need to ...
|
| How do subreports get criteria from form? | 16 May 2005 17:39 GMT | 8 |
I've read many great posts but I'm having a problem telling my subreports where to find the criteria that was entered into the unbound textboxes on my form. The form stays open (as far as I can tell) but the subreports don't get the data from the underlying parameter query. I ...
|
| Problem printing blank lines on a report | 16 May 2005 17:15 GMT | 2 |
I'm trying to print some blank lines following my detail section, which seems to be a fairly common problem. The idea is to emulate a printed form, which has a fixed number of lines for the "detail" section (in this case, it's something like an invoice form). My report is based ...
|
| Counting/Summing with an if statement | 16 May 2005 16:39 GMT | 1 |
I have a report based off a query. The query is giving me all the sales for each person in my group. Column 1 has the individuals name ( John, Matt, etc.), Column 2 has the type of product (Access, DSL, LD), Columns 3, 4, 5, & 6 has the number of lines sold to the customer. ...
|
| programming a page break | 16 May 2005 14:06 GMT | 1 |
How programatically create a page break on command?
|
| print form/subform fields from main form? | 16 May 2005 13:52 GMT | 6 |
I have the following: frminvoices frminvoicedetails subform frminvoicepayments subform
|
| How to print three forms in one print command ? | 16 May 2005 13:49 GMT | 1 |
I want to print three forms in one pdf file. Now I only able to print one form in one file. How can I send all thre forms together to the printer ?
|
| Dynamic Report Naming (Caption) | 16 May 2005 08:18 GMT | 6 |
Anyone tell me how I can change the name, (Caption) of a report when it is run? I have a report that I want to name as the client name with current date, as I then save them as a PDF file. I if simply use the same name (caption) each
|
| Skip record giving empty recorsets in subrecords | 16 May 2005 05:55 GMT | 1 |
I use a report containing a subreport. For each record on the report a query provides on the subreport a set of matching records according to certain criteria. For many records the subreport query results on empty recordsets. D
|
| RunningSum - TitleHeader | 16 May 2005 05:13 GMT | 1 |
I want to display the RunningSum in the TitleHeader. Anyone done this and can share what they did? I created a text box, call it "A", in the detail section and gave it a control source of "=1" and a runningsum of "Over Group". I created another text box, call it "B", in the ...
|
| user developed reports | 16 May 2005 01:01 GMT | 2 |
How do I give the user the option to develop the requirements for their own reports?
|
| How to select records from a combo or list box to print a report? | 15 May 2005 20:28 GMT | 1 |
Would like to print a report in Access 2003 showing only the record selected from a combo/list box. How can it be done? Thanks! Jose.
|