Search results for query: *

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

Thanks, 7! That works perfectly.

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...

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...

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...

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...

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?

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...

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...

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...

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

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.)

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.

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...

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...

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