Recent content by Jimreaper

MSHFlexGrid, Help!! I would like to select a record in band 0 (zero) and make its children highlighted also? Is there and easy way to do this? Thanks Jim

Found it. .ColHeaderCaption(1, 0) = "col name"

Hello all, I have a Hierarchical Recordset passed from a Business object set to a Hierarchical FlexGrid on my UI. I'm trying to change the Column captions on all bands by using the .formatString property however it only changes the first band level Column captions. Does anyone know how to...

Zemp, Thanks! it's perfect, this is all I needed. Dim sText As String sText = "test" Dim l_strFileToSave As String l_strFileToSave = App.Path & "\attachments\test.txt" Open l_strFileToSave For Output Access Write As #1 Print #1, sText Close #1 works like a champ. Jim

Hello, What's the easyies way to : -create a local txt file -write to it. ex( file = strSomeText ) -save the file using vb 6 Thanks

I found the problem. In case anyone has the same. It turns out MS Access 97 corrupted the files. I used an ODBC linked Access table to upload the initial blob files. I guess Access needs the Header.

Help! I'm trying to save a binary blob , temporarily stored in a disconnected recordset, from oracle 9i to a local file using adodb.stream. For some reason the file is corrupted at the beginning and end of the binary string. Either the DB or VB is adding a Header and Trailer of some sort...

thanks!

Does anyone know the best way to copy or pass an instance of a class mod from form to form. Ex. frmLogin has an instance of class ClsUser called objClsCurrentUser A cmdOk within frmLogin shows frmMain. I would like to use or set the instance objClsCurrentUser and its current properties...

Hello all, What is the proper SQL to use for this senario: Insert all records into table1 from table2 and commit after every 10000 rows until complete. Thanks for helping a beginner. Jim

Hello all, What is the proper SQL to use for this senario: Insert all records into table1 from table2 and commit after every 10000 rows until complete. Thanks for helping a beginner. Jim

Thank you Jeff.

PRIMARY KEY COL1 COL2 1 a 2 a 3 b 4 c 5 b 6 c 7 a 8 a Question: What is the correct syntax to use if I want to copy COL1 to...

Is there a way to keep the message "Do you want to save changes" from showing when a user exits the word 97 doc file. I would like the file to close when selected without saving changes. Can a module of some sort be added to the file? Thanks JIM

Question? I don't want 2 of the same app. running at the same time. I can identify if a previous instance is running by using "App.PrevInstance" then end the current instance.(the one searching for the previous instance). But what if I want the current instance to close the...