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 derfloh 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: *

  1. mtn244

    Message if no selection made in list box

    You could use the count property to see if zero items have been selected: If Me.lstRemoved.ItemsSelected.Count = 0 Then Hope that helps.
  2. mtn244

    PowerPoint-Embedded Object Icon Doesn't Work in Slide Show

    Thanks, 7! That works perfectly.
  3. mtn244

    To synapsevampire

    To synapsevampire: I sent a question to you using the FAQ Comments option. As soon as I clicked Send, I realized that you probably wouldn't be able to respond to Comments. Here's my question again. RE: faq767-3825 - Optimizing SQL Pass Through using the Record Selection Formula You wrote...
  4. mtn244

    PowerPoint-Embedded Object Icon Doesn't Work in Slide Show

    I have embedded a Word file in my PowerPoint presentation. Double clicking in design view opens the the Word doc, but clicking the icon in Slide Show just advances to the next slide. I'm not using a hyperlink (which does work) because the presentation is being sent out to people via email...
  5. mtn244

    Reporting on fields returned in sub query

    I have some questions about using a sub query in CR 8.5 on an Oracle 8i database (OLE DB connection). The report uses two tables. There's a lot of typing on this message so state my questions first so you don't have to look for them in the text. 1. How do I get the fields returned in a sub query...
  6. mtn244

    CE8.5: ? about saving instance sched to Excel format

    Vahdani, Thank you for this solution! You saved me a lot of work. I found a work-around for this problem, but it meant walking each CE user through the process. This is such an easy fix (and much better than mine!) and I will be able to just email the instructions to the users. I give you...
  7. mtn244

    Can't Print Drill-down in Enterprise - HELP!

    I am not an expert as are the other contributors of this forum. This is just a suggestion from my experience with CE... I can print drill down pages if I use the ActiveX viewer, not the DHTML. Have you tried this?
  8. mtn244

    How do I put make a cell blank?

    Thanks, Mike! Now that I know the difference in how countblank() and isblank() work, I won't continue to try to find a quick clear-the-cell method. Seems like there should be a way though, since I could do it through Lotus formulas. If I knew how to give you a star, I would. Please give...
  9. mtn244

    How do I put make a cell blank?

    Thanks for your response. I didn't explain myself well, though. The "N/A" I was using was just example text, not the error message #N/A. My question is a generic how to clear out contents of cells if the value in the cells meet criteria specified in an IF() formula. Using...
  10. mtn244

    How do I put make a cell blank?

    How do I make a cell blank? For example, there is data in cells b1 through b100. If I want a blank in some of the cells based on some criteria, I have been following the steps below. However, the "" visually clears out the cell, but doesn't replace with blank. Doing an END-DOWN...
  11. mtn244

    passing parameters in formulas in Crystal Report

    I also am relatively new to CR/CE, so keep that in mind. Your formula uses an equal sign (=) which is a comparison. Perhaps it would work if you used an assignment (:=). Miki
  12. mtn244

    Saving CRv9 Reports to CRv8.5 format

    Thank you for your fast response! I am realitively new to CR/CE and have learned so much from reading the Tek-Tips forum posts. You all are terrific! (Wish I could have received a different answer, though.)
  13. mtn244

    Saving CRv9 Reports to CRv8.5 format

    Can I save a CRv9 report to CRv8.5 format? I am working on a very tedious report that will ultimately need to be opened in CRv8.5. An earlier post mentioned that version 8 saved to version 7. Hoping version 9 saves downward also. Thanks for any help you can give.
  14. mtn244

    Scheduling Issue

    When I have gotten the message "Information is needed before this report can be processed," it has been because of the following reasons: 1. The parameters were not entered; OR 2. The parameter values were entered during the scheduling process, but the ADD button had not been clicked...
  15. mtn244

    Export to Excel functionality

    The document, "Exporting to Microsoft Excel" might be helpful to your report designers. It can be downloaded from: http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr_exportexcel.pdf Reports created for export to Excel are not always aesthetically pleasing viewed on...
  16. mtn244

    Removing a report schedule in ePortfolio

    In the History screen for your report, check the Selected box next to the "Recurring" entry. Then click the Delete button. Hope that helps.

Part and Inventory Search

Back
Top