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!

  • Congratulations Chriss Miller 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
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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}...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. Lanie

    Memory Upgrades

    Good morning! I want to install more memory on my machine because Photoshop hangs after using for a little while. I have an AMD Athelon 128mg RAM - PC100 Win98 Can I purchase any PC100? Does it have to be specific, like does it need to be SDAM or DDRAM or whatever. How do I find out how...
  12. Lanie

    Uninstalled Program Wants to Install at Start up

    Hi there, I have this stray program that I had installed and then uninstalled later one. However, now it keeps appearing at startup and I can't find where to get rid of it. I went through the control panel to uninstall it in the first place, and it seemed to work ok. I can find nothing on it...
  13. Lanie

    Sorting a String Field

    Hi everyone, I've got a sting field that contains numbers 1,2,3,4,5,6,7,8,9,10,11,12,13,14 etc. I need to sort this field so that it appears in the exact order as above. Can someone tell me what I need to do to make this happen? It wants to sort 1,10,11,12,13,14,2,20,21,22,23 etc., even...
  14. Lanie

    Printing white on color paper

    Good Morning, I'm in the process of making christmas cards. This one card is driving me nuts. I'm using a brush and white paint to create the graphic and then print it out on red paper. However, when I print it out on red paper it looks more transparent (red showing through) instead of white...
  15. Lanie

    Formula for Percent of Progress

    This is just driving me nuts! I need to show the total percent of progess based upon the number of records used (which varies from 1 to 8) and the % of Progress which will be 100% when done. Let me see if I can describe the scenario: ROWS IN DETAIL % OF COMPLETION LINE 1...
  16. Lanie

    Converting Powerpoint file to .eps

    Hi everyone, Is there a way to convert a powerpoint file to .eps? I have a two page brochure that was designed in powerpoint (not my doing but never the less I have to deal with it)and I have to get it into an .eps format to send to the graphics company who uses Macs. I need to get his done...
  17. Lanie

    Photoshop 7 Brushes

    Hi all, I've got Photoshop 7. I went out and found some free brushes,which I proceeded to unzip into the Brushes directory of Photoshop. Now I can't get the window to open that displays the brushes I just loaded. Has anyone else had this problem and fixed it? I sure do appreciate all...
  18. Lanie

    Printing the Visual Linking Screen

    Hi, Has anyone found a way to print out the contents of the Visual Linking Screen? If you have, could you tell me how to do it? It's driving me nuts! Thank you so much for your help. Lanie laniet@ij.net etroidl@conaxfl.com
  19. Lanie

    Date Parameter

    I'm going crazy and just can't see where I am going wrong. I need to allow the user to pull this report based on a date range (a beginning date and then an end date.) In my report I have many fields, but I have one date field in my report which is DATE_ENTERED (formated date/time). I set up...
  20. Lanie

    Multiple Variables in a Formula

    Me again - working at home.. Okay, I've got another problem. I have a salesmans field that holds a salesmans_code of for example ETROIDL, and there are multiple names such as VGEORGE, JGIBSON, JFAIR etc. Whenever it finds ETROIDL I need it converted to Emogene Troidl, the same for VGeorge to...

Part and Inventory Search

Back
Top