Search results for query: *

We are trying to print a Crystal Report to a User Defined paper size and are getting a series of dots printing. When it is printed using Letter Size it prints fine. I'm hoping that there is something simple and obvious that we are missing. Any suggestions? Joyce

Both excellent suggestions! Thanks so much. Joyce

I am not a VBA expert but I have been asked to make some minor adjustments to an existing Excel file. The file is sent to customers and there is no control as to what level their security is set to. The file has an auto_open macro and my question is whether there is a way to force the file to...

DjangMan; Could you please send your power point presentations to lawrence_j.msn@attcanada.net. Thanks

Thanks xlbo; I think that's the answer. The only way around it that I can think of is to open the text file and copy it over to the file where the macro is to be run. Any other workarounds that you know of? Thanks, Joyce

I am getting 2 errors on a macro I wrote in Excel 2002 when it is used with Excel 2000. Works fine with 2002. 1. Run-Time Error: Application-defined or object-defined error The code is: Selection.Sort Key1:=Range("A2"), Order1:=xlAscending, Header:=xlGuess, _...

Thanks for the suggestions! I will give them a try.

In Word 2000, I want to autogenerate a TOC that shows Heading 1 and Heading 2 but I only want the page number to appear beside Heading 1. ie. it should appear as follows: John Jones ........1 ABC Company Jane Smith ........2 XYZ Company Is this possible? Or is there another way to...

I need a way to delete all rows that contain a "B" in column C. Any suggestions? Thanks, Joyce

Thanks for your reply. Actually my problem is that the report consists of a list of invoices and I need the number of the first invoice on the first page to print at the top of the second page. Joyce

I have a report that has a page break after each customer. Each customer may have several invoice listed. I would like the number and date of the first invoice for each customer to appear at the top of each subsequent page. Is there a way to do this? Thanks, Joyce

I am using a running total for a subtotal in a report. When the Group Footer that holds the subtotal is forced to the page following the detail section, it is blank. I have tried using a manual running total and it appears as 0. What am I doing wrong? Thanks, Joyce

I have a report with one subreport which prints the same info as the main report. I want to set up so that if there are more than 19 detail lines, it will print to a new page. Page 1 of the main report and page 1 of the subreport should appear on the same page. I am able to get the following...

Thanks - I thought I had to use a numerical field for a running total! Guess not - that worked. Joyce

I have a report where I have specified to start a new page after the group footer for Customers. I want to number the detail lines for each customer - is there a way that I can reset the recordnumber counter for each new page? Thanks, Joyce

Thanks for the help. I was able to get what I needed through use of running total. Joyce

I have a report that repeats an invoice if more than one payment exists. I need to include the invoice amount in a subtotal only if it is unique. Is this possible? Inv. Amt. Pmt. Amt. Inv 1 100.00 100.00 Inv 2 200.00 100.00 Inv 2...

I have a report in CR7 with a subreport which both have a parameter for "year". These reference fields in different tables but will always be the same value when the report is run. Is there a way to set this so that when the report is run, the value for "year" needs to only...

This is called a datapipe file by ACCPAC. They were created to add speed to the generation of the invoice. I have been told that I would need a programmer to help me edit these. I have been able to add subreports to these invoices if more information is required but have only been able to run...