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

Perfect ! Stars for both of you.. Thx a lot !! Lemox

Public Sub Init(ByVal Result As OO4ORecordset) Result.MoveFirst While not Result.EOF Me.lstResult.ListItems.Add , , Result.Display Result.MoveNext Wend End Sub (Result.Display returns a string)

Thx for replying. I already tried to change to lvwReport : now my list doesn't display any item. (I checked the .ListItems.Count property : 200 items) Is there any other property to set when using it as 'Report' ?

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

Oooooooops... Ok : I guess I could buy the CR9 Report Creation API. But I have to be absolutely sure ! http://internationalstore.businessobjects.com/product.html?sessionid=177706129&random=88596e98bf5eda9e8618e545dac1521b&productid=512811 Could you tell me if this is the right upgrade ? Many...

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

Dave, FYI : I never used LogOnServer. I just put this line of code : Report.Database.Tables(1).ConnectionProperties.item("Password") = "wordpass". And I don't like so much putting passwords in my VB code so it would be really nice to make this line disappear ;-) Lemox

Dave, Thanks : useful document... But there's still sthg I can't figure out with the SetLogOnInfo : I don't use a ServerName. My app has one parameter giving the TNSName of the Oracle db so I can make the app run on different servers. But this is not the name of the server which lies in the...

Well, the problem only happens if I generate the report in VB environnement : making an exe solves the problem (session deleted). Don't understand but most important is that it works with my exe...

I'm using CR9 with Oracle so maybe different but I do it like that : - create the param with "Value Type" set to "String" - use it between quotes in the query of the subreport : (...) AND CD.CD_ID = '{?MainID}' Lemox

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

Dave, '.DiscardSavedData' worked like a charm ! I spent so much time on this one ! Thanks a lot !!! Lemox

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

Sorry : gives 3, not 5 ! ;-)

Yes, I meant the var q According to MSDN : ---------- DatePart "Returns a Variant (Integer) containing the specified part of a given date." ---------- Try this : Dim q As Long q = DatePart("q", Date) q = q - 1 'Gives 5 -> No probem Now, try that : Dim q As String q = DatePart("q", Date) q...

Hi TallOne, Found the problem : I used the Datepart function this way : q = DatePart("q", Date) ... but declaring q this way : Dim q as Date -> result was : 03/01/1900 Much better by declaring q as Long. Thanx for your help.Lemox