Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Lanie
  • Order by date
  1. Lanie

    Unable to send email from inside MS Word and Excel

    sawedoff, Yup, it set correctly. :( Lanie
  2. Lanie

    Unable to send email from inside MS Word and Excel

    xlbo, I just tried it 26 times, and it still won't budge. :( Lanie
  3. Lanie

    Unable to send email from inside MS Word and Excel

    Hello everyone, *Using MS OFFICE Outlook, Excel, and Word 2003 SP2. I've had this problem awhile now, but can't see how to fix it. I create the document (Word or Excel), save it, then click File, Send To, Mail recipiant (as attachment), and the lovely Outlook window opens, with the document...
  4. Lanie

    Surpressing Text Boxes when No Data

    Your are all fabulous! It is always a pleasure learning from you all. That worked perfectly and now I can surpress my the group if it's blank too! Thanks you so much again! Have a great day! Lanie
  5. Lanie

    Surpressing Text Boxes when No Data

    Good Afternoon, CR8.5 and Oracle I'm not sure this can even be done, but thought I should ask anyway. I have text boxes in the group header which define the data (detail section) which appears under it. If there is no data, then I don't want the text boxes to appear/print. Is there a way...
  6. Lanie

    Shared Variable - sub to main report Totals

    Good Morning, I've put done the forumals exactly as MrBill suggested above and it is returning zeros. I then tried to sum up the {ChangedDistTotals} that is now on the main report, using a formula as well as the wizard. No dice. Guess I "really" don't get it. Help! Lanie Lanie...
  7. Lanie

    Shared Variable - sub to main report Totals

    MrBill, Thanks I will give it a try and let you know what happens. Lanie Lanie etroidl@tampabay.rr.com etroidl@conaxfl.com
  8. Lanie

    Shared Variable - sub to main report Totals

    Good Morning, Using v8.5 I must admit that I am clueless regarding shared variables, and not sure where to start. I have a main report and a subreport. The main and subreport grouping is on District, each sum the sub total dollars in each district. The main report (district AS for...
  9. Lanie

    Results in a Date field.

    Good Morning, We have a report which needs to compare the contract date and ship date, then if the ship date is later than the contract date, we want to show it as late (LT). Here's my formula for that. If {CUSTOMER_ORDER_JOIN.WANTED_DELIVERY_DATE}<={CUSTOMER_ORDER_JOIN.REAL_SHIP_DATE}...
  10. Lanie

    Sort last 6 digits/characters of a String Field

    Thank you very very much. It worked great. I have many reports that would require this type of sort and I'll be using it from now on. Have a great day! Lanie laniet@ij.net etroidl@conaxfl.com
  11. Lanie

    Sort last 6 digits/characters of a String Field

    Hello, I need to sort the last six digits / characters of a string field and display the entire field. Right now its sorting as per the following example: 00A063 00A155 00C030 00C204 00L281FMS 00W259 What I need is this sort: 00C030 00A063 00A155 00C204 00L281FMS 00W259 It should ignore the...
  12. Lanie

    Preview Pane, formating of....

    Hi All, Well I have a user who wants to see the items listed in the preview pane in a specific manner. They do not want to see the comma's and decimal places, just the whole number. I've formated the field on the report with no comma, no decimal places, but the preview pane still shows with...
  13. Lanie

    Calculate Percentage of string

    Thanks to everyone, but I found the answer by using the Running Total Fields. Lanie laniet@ij.net etroidl@conaxfl.com
  14. Lanie

    Calculate Percentage of string

    Hello Everyone, We need a formula that finds the percentage of the number of occurances of the text &quot;early&quot;, &quot;N/S&quot;, based upon the total number of records pulled. We have these formulas(so far): @CntDescriptions IF ISNULL({CUSTOMER_ORDER_JOIN\.REAL_SHIP_DATE}) THEN...
  15. Lanie

    ISNULL and PRINTING TEXT WITH DATA

    You are fabulous! Thanks so much, it worked like a charm. Have a great day! Lanie laniet@ij.net etroidl@conaxfl.com
  16. Lanie

    ISNULL and PRINTING TEXT WITH DATA

    Good Morning Everyone, We need to set up a formula to print the text &quot;cust part&quot; followed by the customer's part number (when there is one), but to not print the line at all if the field is blank. We have tried to use this formula, which will print the text with the correct part...
  17. Lanie

    Comparing 3 Fields, then printing exceptions

    dgillz, Thanks so much. It works great! Lanie laniet@ij.net etroidl@conaxfl.com
  18. Lanie

    Comparing 3 Fields, then printing exceptions

    Hi everyone, We are using CR8, with an Oracle Db We have an exception report that we need to compare three different fields. If all three fields are the same, don't print. If all three fields are not the same, then print. I'm not sure how to do this, would someone help us out? Lanie...
  19. Lanie

    Excel - Automatic Row Heighth and Protected Document

    Hello All, I'm creating a form in Excel (2000). I want to be able to protect the entire sheet except the cells that should be filled in - no problem there. However, and this may be something so basic but I don't get it...three of the cells on the row will expand in heighth. I've used the...
  20. Lanie

    Memory Upgrades

    mjinks61, I am indeed maxing the RAM. I'm using PS7 and I am so tired of it crashing. Thank you so much for your help. Lanie laniet@ij.net etroidl@conaxfl.com

Part and Inventory Search

Back
Top