Search results for query: *

Sorry everyone...I didn't see that a ListView1.Clear statement had been put in far above the code I was having problems with. That's what I get for putting this aside for months then picking it back up. All is good now.

I have a listview which I have entered 10 columns in the design view. I populate this listview from a database using a datareader to a datatable. When I populate the listview, my manually created column headers disappear and are replaced with the column headers from the columns in the...

Thanks all! This solved a problem for me too! That's why I love this forum! Dan

Thanks LB! That works very well! All is running well - for a Tuesday LOL. Thanks again! Dan

LB, I don't know if this is final answer, or I just got lucky. After I posted the above message, I got to thinking about NULL values and went and checked my report options. The Convert Database NULL values to Default was unchecked. When I checked it and re-ran the report, the blank line was...

Thanks for the reply and tidbit of info. This conditional suppression formula is on group 3 footer. Job.Drawing is the field used for group 2. Job_Operation.Operation_Service is the field used for group 3. In the data source, there are times where the Job.Drawing field is blank (not all jobs...

I've got a report in CR 9. In it I've got 3 nested groups. In my data, sometimes there's no string data to be displayed in the 3rd group's name, but there's other data that's needed for other parts of the report. My problem is that I can't get that group footer to suppress when there's...

LB - I stand very much corrected! Yes cross-tab is the way to go. Got it working very well. Thanks! And big appologies to Madawc! I didn't realize that the cross tab would suppress the details of the rows so that it would only show the sub-totals. Thanks again! Dan

Thanks for the reply. Sorry - I'm using CR v9. I'm not really looking to do a cross tab on this. I'd just like extract the group sub-totals and have them displayed together elsewhere on the report. Dan

Hi all, I've got a report that sum hours of labor. It groups by department with sub-total hours for each dept. What I'm trying to do is a summary of all departments at the bottom of the report. The report looks something like this: Assembly (grouping - group header) kk1 31paint .35...

Thanks for the reply Bob. And for the insight into MS and the 'behavior by design' thought processes. It's now making a lot more sense. Dan

Hugh - Thanks for the suggestions. I've implemented them and have seen a small improvement. Bob - thanks for the input. I understand what you are saying and it makes a lot of sense. That seems like what is happening. When I am cycling through each row in a loop, I'm checking things using...

Oh and one other general question, when I'm qualifying the Excel methods and properties, can I use the objXL. just at the beginning of the method and not have to use it on each part of the method? Like (without qualifying) ActiveSheet.Range(Cells(2, 1), Cells(LastRowNum, 1)).EntireRow.Copy Is...

Hugh, Thanks for the replies. I've gone through and qualified all of the Excel methods and properties with the Excel object. I didn't realize that was necessary, but it make sense. That improved speed a little. Upon further troubleshooting, I've noticed that the code gets slow when it is...

Hey all....Thanks for the thoughts and suggestions! The problem seems to occur after the form is closed (by user intervention) and the .txt file is opened. After that is where the noticable slow-down occurs - when the code is manipulating rows,cells, etc. I have actually clicked on the...

Hi all, I've got an Excel 2000 VBA app that I've ported over to VB6. The code runs fine, no errors, and gives expected results. The problem is that the VB6 version runs very slowly. For example, if the app is run within Excel VBA, it completes in about 2 seconds, but the VB6 version takes...

firefytr, Solidworks is a similar program to Autocad, in the fact that they are both 3-D CAD packages. But the API's are very different, not to mention the internal workings of the programs. I have contacted the manufacturer and am waiting on a response. I posted on this site as well because...

Hi all, Does anyone here do VBA programming for Solidworks (a 3-D CAD package)? I'm working on a VBA application within Solidworks (SW 2006 sp 4.1) and am running into a problem. I need to be able to find and list all of the external part and assembly file references within an assembly...

Thanks Koonan. That's what I was hoping to hear! Thanks for the table. It has a nice comparison of the file systems. Good info there!

Hi all, I've got an SBS2003 server running and am wondering if there is a limitation to the number of folders/sub-folders that the OS can handle? Also, is there a limit to how deep the nested sub-folder structure can go? 16 deep? 32 deep? Thanks, Dan