| Thread | Last Post | Replies |
|
| Bug with using subforms in reports and Office SP 1 | 14 Dec 2004 17:39 GMT | 3 |
Our databse uses subforms in our monthly reports. Once Office SP1 was installed, the subforms only showed in the first page and not in the subsequent pages. (ie: 2-48 the page is left blank where the subform was to be).
|
| Exporting Yes/No field to Excel | 14 Dec 2004 17:03 GMT | 1 |
If there anyway to export the Yes/No Field to an Excel Spreadsheet? I have tried "Analyze With Excel", "Analyze With Word" and Save As Export...but all ignore the Yes/No Data. Any help will be greatly appreciated. Thanks!
|
| Displaying MS Access reports | 14 Dec 2004 16:48 GMT | 2 |
I have a critical problem - our client wants to be able to display reports that they've made in MS Access over a web-based interface. I thought that this would be straightforward but the following code *always* gives the ' Microsoft Access can't open the database because it is ...
|
| Can you publish a report in Access as a pdf file? | 14 Dec 2004 16:45 GMT | 3 |
I know you can publish an Access report in Microsoft Word but is it possible to publish a report in Adobe Acrobat, as a pdf file?
|
| Text box to currency formatting | 14 Dec 2004 16:23 GMT | 5 |
I have a text box in a report where the user will enter the information. I set the formatting at currency but when the user enters the value it doesn't show on the report as currency.... Any help?
|
| Keeping groups on the same page | 14 Dec 2004 15:08 GMT | 1 |
I use an access database for participants in our trips. We give them a group number (usually 3 or 4 to a group) and then use a report grouped on the "group" field to print a rooming list. I get 3 from group 5 on the first page and the fourth on the next page or it splits the ...
|
| Create Queries with Reports | 14 Dec 2004 14:56 GMT | 2 |
Hello to all in group, I'm trying to build a query that will show the first three characters of a field. Not sure of the correct experssions to use. I'm also trying to have a report count the total number of records and
|
| Grouping showing multiple identical values | 14 Dec 2004 13:53 GMT | 2 |
I have: ProdTable with Order Number (Order Number is unique) ItemTable with item ID per order (there can be many items per order, or just one - Item ID is unique)
|
| Documentation in Access? | 14 Dec 2004 13:00 GMT | 4 |
I have an Access db and I would like to do the program documentation within the db and be printable. I tried doing it in "reports" using Label boxes and inserting pictures. After I inserted a "Page Break" my label box on the second page became a box only an inch wide. No ...
|
| remove blank spaces | 14 Dec 2004 12:48 GMT | 2 |
I have a report and I want to elimiate all blank spaces in every field when the field is longer than the data. Please advise. thanks
|
| Del / Mark Duplicates?? | 14 Dec 2004 08:13 GMT | 1 |
I have some VB like below, to delete duplicate. The Access table is 'RED', key index field is 'Index', the VB nevigate through all records in 'Index' and delete duplicate if found. There are 2 problems:
|
| How to replace #Error with NA in an Access Report? | 14 Dec 2004 04:31 GMT | 1 |
I have a report that has three fields. One field is number applicable, one is number due and the third in percent compliant. I have the percent compliant populate by dividing the number due by the number applicable. Everything works fine unless there are none applicable, then I ...
|
| Format / Unbound Text Box | 14 Dec 2004 03:41 GMT | 1 |
Folks, I have an unbound text box on a report which displays a text paragraph. Is there a way to have some words within this one text box in italics, others in bold, and others in a different color all within the same box? I am using a report to create a letter and this client ...
|
| Access 97 to XP and problems with the Format function | 14 Dec 2004 01:34 GMT | 1 |
I have an Access 97 application that I converted to Access XP for a client. The application contains reports that use the Format function. For example, an unbound text box could contain: ="Report Date: " & Format(Now(),"mm/dd/yy")
|
| Subreports | 14 Dec 2004 01:06 GMT | 1 |
Is it possible to have 2 subreports within a main report? I have set it up that way in desing mode, but cannot view the 2nd subreport in preview.
|