Recent content by gregoriw

Hello to all my Tek_Tips friends, First off, before you ask...I'm using Crystal Reports 11 and SQL Server I need a little guidance in how to design an addendum to my main summary report. If you can, please post suggestions. Basis of my design issue is that for every summary row there is data...

I think I found my answer. Can someone please confirm? After opening the RPT file in the Crystal Reports designer, I selected the File option from the main menu. Then chose the Export option. Selected the Report Export Options and this popped up a Window where I select the Excel - Data Only...

Hello all, I am trying to find out where Crystal Reports determines where/how it finds the font type to use when exporting a Crystal Report to an Excel - Data Only file. - using Crystal Reports XI - all text in Crystal Report RPT file is Times New Roman - when exporting to Excel - Data Only...

I am having a very difficult time trying to find out how to tell what's wrong with my .Net setup deployment. Specs: VS .Net 2005 SQL Server 2005 Crystal Reports XI Creating a Windows Service to read from database, get a list of data, and create a PDF output report using CR XI. Installs fine...

Great discussion in this thread. I wonder...Has anyone heard or used the password encryption tool from a now-defunct company called MicroHelp Encryption X-potents? If so, are there any websites supporting this product? My company has some legacy tools and I need to know the logic in how...

I need to get a user name out of an RTF document that was created and exported by Crystal Reports. How can I use VB6 to basically find text in an RTF document programmatically? I've tried opening the document using the FileSystemObject and analyzing a "line" at a time, but thanks to RTF...

Does anyone know of a good replacement than the old Cresent software control named CIHTTP.OCX? It is part of The Crescent Internet ToolPak of third party controls. This was a product from way back in 1996. I'm trying to update a VB6 program with a more current product where I can get some...

Still have SOME hair left.... Vampire, could you send me your test program in a text document so I can run it here and get some ideas of how you have this designed to make it work for you? Then maybe I can review what my code has in it and possibly adapt yours to make mine work. Worth a try...

I did put a breakpoint in the NodeCheck event...I accidentally put down the NodeClick event in my item 2 above. But even so, the NodeCheck event did not fire off when my checkmark assignment routine was running. Each time I F8 through the CheckThisOut routine and got to the point where the...

Here are the other responses to your questions: 1) TreeView1.CheckBoxes = True is set just after TreeView1.Nodes.Clear and before my looping routine fills in the tree list with values. 2) Put a breakpoint in NodeClick event and the routine above where a match is found and it never fired off...

Hello all, I have a situation where I'm trying to set the Checked property of node(s) in a treeview control based on a list of items from an array. This array holds prior selected/checked items from the treeview in a previous process. When the user returns to view the treeview in another...

Wow! This is a great start. From the FAQ, I was able to get to a web page that describes more to our level as developers what to do. http://support.microsoft.com/default.aspx?scid=kb;EN-US;262701 Hopefully I can find some good examples there to put into my code. Thanks a bunch Daren!!!!

Hello all, Hope somebody can direct me to a solution with this error. I have a VB6 (sp5) program that references MSOUTL9.OLB so I can programmatically generate/send an email to the IT department in case an error occurs within the program. That way immediate errors can be fixed sooner. Here...

Thanks SQLBill, I understand that having the error is beneficial in that it won't allow any duplicates on the primary key (which is the column named PicRefNum). I would want that to happen. And yes, I can change the updated script to only check for the primary key of PicRefNum, too. That...

Hello All, I'm trying to avoid getting a VB6/ODBC/SQL error message (this is a composed error log message of my own with the standard ODBC script).... 1) 01:16:32 pm TANYAJ Error in clsReference.InsertLock -2147217900 [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY...