Search results for query: *

Hi, I would like to pause my application while a word process hasn't finished working... I produce a Word Document that should be saved automatically. With these lines : Wordapp.Visible = True Wordapp.ActiveDocument.Save My application seems to have finished its work and I can see that Word...

Hi there, I'm trying to display a listview with only one item per line (only one column). i.e. ---- -item1 -item2 -... -itemX -itemY -itemZ View property is set to 'List' but what happens is that when there are many items, list continues in the next column (don't know if it is a real...

Hello, I use MS Word as a Reporting Tool : my reports can contain embedded files (.doc, .pdf, .txt,...) displayed as icons in the document. I insert a file like that : Word.Selection.InlineShapes.AddOLEObject FileName:= sFileName, DisplayAsIcon:=True, IconLabel:=sDispName, LinkToFile:=False...

Hi, I found something about this in the FAQs but doesn't answer my question : I have a vb6 application that produce a Crystal Report immediately exported to MSWord (no Crystal viewer is needed). And I always get the same error : "TLV Record"... I checked on Crystal website : I should read...

Hi there, I generate a crystal report picking data in an Oracle db via VB6. As the "MyReport.Export" occurs, a new session is automatically created by Crystal. When the report is done, performing : Set MyCRApp = Nothing Set MyCRRep = Nothing doesn't kill the session, which is still active...

Hi, I try to use TWICE a table (I'll call it 'T'). I mean that I have a table 'A' referencing 'T' and table 'B' referencing 'T' too. 'A' and 'B' are not linked. Using Database Expert, I can put twice 'T' : second time, an alias is proposed ('T_1'). But If I insert 2 db fields 'T'.'T_NAME'...

Hi, I'm trying to pass a parameter from vb to CR10 : ------ MyRep.ParameterFields.GetItemByName("MyParam").SetCurrentValue(Cstr(100)) ------ (MyParam is declared as string parameter) I display the value of MyParam in the report : it's always set to 0 !!! Actually it's always set to the value...

Hi, How can I display a file (Oracle Blob) into a Crystal Report v10 report by using VB6 ? I want to display it as an icon. So, what's the code for "insert->OLE Object->Display as icon" ? Thank you in advance Lemox

Hi, I would like to get the first day and the last day of the quarter preceding today. (statistical stuff) So, for today it would be (french display): today : 16/11/2004 -> 1st day : 01/07/2004 -> last day : 30/09/2004 Sounds like an "school-exercise" but I promise it is not ! (maybe I...

Hi, Here's the situation : (- Win 2k - VB6 - MS Word 2k SP3) My vb6 app has to produce reports about vehicles. To do this, it loops x times through a procedure that should insert each vehicle's 'paragraph'. Maybe 'Paragraph' is not the right word : I mean all data related to ONE vehicle. I use...

Hi there ! Need your help : I'm trying to create a stacked column chart in Excel using vb6. I want my chart to look like what you can find in the Help File called 'Example of Chart Styles' of MS Excel 2k. Looks quite like this : ^ | | |...

Hi, I'm looking for a method to import text files into Excel. Here is the way I would like it to work : 1) Execute a SQL query that produces a structured text file containing the data. 2) Import this text file into Excel (without any wizard). 3) Produce charts (in a first time, this could be...

Hi, I produce reports from vb 6 into MS Word 2k. I wrote a loop that inserts the data in the word document : The more it loops, the more its getting slow. Initally, this loop is executed twice / sec... and in the end (looped about 200 times), it takes 11 seconds to do it once !!! In this...

Hi there, VB6 : I'm trying to open a file with appropriate registered windows application. To do this, I use the Shell command this way (found it in the FAQ section) : A = Shell("RUNDLL32.EXE URL.DLL,FileProtocolHandler " & FilePath, vbMaximizedFocus) This works quite well. The problem is...

Hi, I want to embed a file (displayed as an icon) into a Word Document (VB6). I use the WordDocument.Shapes.AddOLEObject method. My problems are : -the file is never really embedded : it always acts as a Link to the file (even if I set the "Link" parameter to False explicitly) -I can't...

Hello, I wrote a Setup package for my application and I want it to create an empty folder (ex: "C:\MyReports"). I guess I have to do something in the "SETUP.lst" file but I don't know how. How can I do that ? Thanks

Hi there, I would like to know how to run current control's Validate Event before performing a treatment. For example, I have to check several textboxes containing dates before clicking on a button that starts a SQL query. The problem is that my "OK" button has its Default property set to True...

Hi there, I would like to know how to copy a table from Word (or Excel) and then paste into a grid (vb6). Is it possible without using VBA ? Any idea welcome... Thanks Lemox

Hi, How can I use the Oracle user's login and password on the Oracle server ? I don't want these information to be stored in a table... (security) Thanks Lemox

Hi, I'm in trouble with OO4O and its OIP errors : I cannot propagate them to the calling procedure. In my Form : ------------ MyObject.Edit 'apply modifications... blabla MyObject.Update Class CMyObject: ----------------- Private rst as oradynaset Public Sub Edit() On error goto Err_Handle...