| Thread | Last Post | Replies |
|
| Two queries in one report | 08 May 2008 19:36 GMT | 3 |
I have what is probably an easy question (and hopefully has an easy solution
:D). I have a report that I would like to reflect the results of two queries, that come from the same table. I am not having much luck.
|
| Export to Excel | 08 May 2008 18:31 GMT | 4 |
How come I can't export my report to Excel anymore in the 2007 Access? I used this function a lot and now they just remove it. I am not happy.
|
| Source Object changing on save of subreport | 08 May 2008 17:43 GMT | 2 |
In Access 2000, I have a report with two separate, unlinked, subreports. The source object changes on the second subreport to that of the first subreport. I have changed the source object in the 'properties' menu, upon save the source object reverts back to the
|
| Save each page of report as a file | 08 May 2008 17:22 GMT | 7 |
I have the following task to automate: I have a report that has a few hundred pages in it. Currently each page of the report is printed on paper then scanned into an imaging system. Each page has fields on it that are indexes in the imaging system. For example,
|
| Parameter Queries in Reports | 08 May 2008 16:51 GMT | 6 |
I'm a pretty new Access user, so maybe I'm doing this the hard way. But nothing I've tried has worked, so I'd really appreciate some help. I have a report which is based on a parameter query. I can determine the value of the parameter through code, and so I don't want to fill in ...
|
| Supressing # if no data in field | 08 May 2008 06:28 GMT | 1 |
I'm sorry that I'm posting this question as it's similar to another question I asked, but I still can't get this to work. I'm using Access 2003. I'm using the below in a textbox in a report. When there's no data in the field "fars_main_mailing_address_2nd_address" I would ...
|
| Reports and Phone Number Format | 08 May 2008 05:34 GMT | 3 |
I created a report to show the info from a form. On my tables the phone number & fax number for my vendors show up in the proper format. ie (999) 999-9999. The reprot is based on a query that I created. Everywhere I look, the phone number format is correct. But when I open ...
|
| Syntax Error | 08 May 2008 04:13 GMT | 1 |
On a report, if the field [Test Scenarios] is empty I want to print "", else "Exists" A previous post said to make sure the text box was not named the same as the control source. Which I have corrected.
|
| Multiple fields at same grouping level in report wizard | 08 May 2008 02:26 GMT | 7 |
I often have a query that is being used as the data source for a report with multiple fields from the same record at each grouping level. So, for instance, I might have CategoryID, CategoryDesc, TopicID, TopicDesc, TopicOrder, PageID...
|
| email reports off MS ACCESS app run on MS server 2003 | 08 May 2008 00:57 GMT | 2 |
I have an app which runs just fine. There are several reports which we convert to PDF for secure emailing, and utilize the ADOBE PDFWRITER IN ADOBE ACROBAT to make the conversion. The reports look and format perfectly. The client has now decided they want to utilize Microsoft ...
|
| Query Help | 07 May 2008 22:12 GMT | 8 |
I'm doing a OpenReport for generating labels with the following query: [ComputerName] IN ('name1','name2') And I always get whatever is in the first position. Here I would get name1. I get no errors. What am I doing wrong?
|
| Envelopes in Access | 07 May 2008 21:28 GMT | 2 |
I have created a report to reflect a #10 envelope. Now I want to create a command button that allows me when clicked print an individual envelop that reflects the information of the member record that I am in, so far no such luck. How do I correct this?
|
| Vertical to Horizontal | 07 May 2008 21:02 GMT | 8 |
am putting this in Reports area because the need is being driven by production of Labels with limited space....probably is a query question though... The data is normalized ok and query/table results normally are like this:
|
| On Format Function Error | 07 May 2008 20:28 GMT | 3 |
I'm creating a report and got the following Error: The expression On Format you entered as the event property setting produced the following error: The function you endtered can't be used in this expression. It might be related to an expression I tried to build in a footer by ...
|
| Calculating Future Months | 07 May 2008 20:08 GMT | 3 |
I am building a database to store lease dates and amounts. I would like to build a report that shows date a contract is signed, start date of lease and number of months. How would I show a report that prints out the next 5 months?
|