Hi

use the ReplaceSelectionFormula if it is possible or use the SQL property of the Crystal report control

Regards
Shreekar Joshi

------------- Original Message --------------
"professional vb digest" <pro_vb@p...> wrote:
To:"pro_vb digest recipients" <pro_vb@p...>
From:"professional vb digest" <pro_vb@p...>
Date:Mon, 23 Apr 2001 00:01:30 +0100
Subject: pro_vb digest: April 22, 2001

PRO_VB Digest for Sunday, April 22, 2001.

1. Problem getting VB program to show in taskbar
2. Sorting a field by string length
3. Calling a Crystal Report from VB when the report uses a Crystal Query or a Coded Query

----------------------------------------------------------------------

Subject: Problem getting VB program to show in taskbar
From: Michael_Cagle@T...
Date: Sun, 22 Apr 2001 18:59:13
X-Message-Number: 1

I have a multi-form visual basic program that does not show up on the task 
bar. I have the ShowInTaskbar property set on all the forms. The forms are 
all VBModal except for the first one.

Any ideas ?
----------------------------------------------------------------------

Subject: Sorting a field by string length
From: "Dr Gordon Atherley" <atherley@s...>
Date: Sun, 22 Apr 2001 16:54:32 -0400
X-Message-Number: 2

Good day

Can any one suggest a VB strategy for sorting an Access 2000 text field
by length of string, please?

Thx

-----Original Message-----
From: Marco Straforini [mailto:marco@c...] 
Sent: April 19, 2001 12:24
To: professional vb
Subject: [pro_vb] RE: Using CreateObject to instanciate an object on a
remote computer

Brett,
the dll (and ocx as well) is an inproc server and must run on the same
computer.
You have to create an ActiveX exe to be able to connect remotely

marco straforini

> -----Original Message-----
> From:	Brett Arthur [SMTP:brett@d...]
> Sent:	Thursday, April 19, 2001 7:24 AM
> To:	professional vb
> Subject:	[pro_vb] RE: Using CreateObject to instanciate an object
on
> a remote computer
> 
> I have installed the dll on the remote computer. Would it be better
for me
> 
> to use MTS instead of DCOM?
> 
> 
> > Is the object installed\ registered on the remote computer?
> > 
> > -----Original Message-----
> > From: Brett Arthur [mailto:brett@d...]
> > Sent: Thursday, April 19, 2001 9:12 AM
> > To: professional vb
> > Subject: [pro_vb] Using CreateObject to instanciate an object on a
> > remote computer
> > 
> > 
> > Hi All,
> > 
> > I am trying to instanciate an object on a remote computer. I am able

> to
> > use create object on the remote server directly, but when I try the
same
> > 
> > call across the network I get the 'ActiveX can't create object'
> error.
> > Anything in particular that I should look out for.
> > 
> > COM Object to be created:
> > 
> > Public Property Get ReturnValue() As String
> >   ReturnValue =3D "Pass"
> > End Property
> > 
> > Call to create object:
> > 
> > Dim obj As Object
> > Set obj =3D CreateObject("TestCOM.Interface", "Autechre")
> > Debug.Print obj.returnvalue
> > 
> > Thanks,
> > Brett


----------------------------------------------------------------------

Subject: Calling a Crystal Report from VB when the report uses a Crystal Query or a Coded Query
From: "Graham Meyerowitz" <mail@n...>
Date: Mon, 23 Apr 2001 07:35:06 +1000
X-Message-Number: 3

I am having difficulty with the following query.


I am trying to include this query in a Crystal Report and call the report
from VB code.

The  only way it seems to work in Crystal is when I insert the SQL statement
into a Crystal Query , saved as a Query file, and use the Query in a Crystal
Report. However, this combination is not working when I deploy the VB code
which calls the Query. The Query File location is hard coded with the Query
and needs the same folder structure on the deployment machine.
When running this I get the error "This program has performed an Illegal
operation" .

What is the best way of including a query into VB code behind a Crystal
Report ?

Graham




---

END OF DIGEST



_____________________________________________________
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.com