Passing a Parameter its works and it doesn't work 
Author Message
 Passing a Parameter its works and it doesn't work

Hi
I'm using cr7, vb6, a2K (Acess 2000)

On the developing machine....i pass parameters and it works fine....

I installed the application  on the users machine my parameters didn't
work....
What i tried is to open just the report without passing any parameters
on the users machine...that worked fine

here is my code:

Private Sub cmdClProd_Click()

Dim stTSA As String

'This is the parameter i'm passing its a string
stTSA = txtClientInfo(12).Text

rpt.ReportFileName = "C:\Program Files\report.rpt

rpt.DiscardSavedData = False

rpt.ParameterFields(0) = "NoClient; " & stTSA & "; true"

rpt.PrintReport

End Sub

Could any one help me on this



Sat, 18 Jan 2003 03:00:00 GMT  
 Passing a Parameter its works and it doesn't work
Hi Luigi, what type of value are you trying to pass?  Is it a number or a
string parameter?  Try taking the space out after the first semi-colon..

HTH, Paul
--
Paul Little
San Diego, CA


Quote:
> Hi
> I'm using cr7, vb6, a2K (Acess 2000)

> On the developing machine....i pass parameters and it works fine....

> I installed the application  on the users machine my parameters didn't
> work....
> What i tried is to open just the report without passing any parameters
> on the users machine...that worked fine

> here is my code:

> Private Sub cmdClProd_Click()

> Dim stTSA As String

> 'This is the parameter i'm passing its a string
> stTSA = txtClientInfo(12).Text

> rpt.ReportFileName = "C:\Program Files\report.rpt

> rpt.DiscardSavedData = False

> rpt.ParameterFields(0) = "NoClient; " & stTSA & "; true"

> rpt.PrintReport

> End Sub

> Could any one help me on this



Sat, 18 Jan 2003 03:00:00 GMT  
 Passing a Parameter its works and it doesn't work
Hi Paul...thank u
took out the space but it doesn't work....i'm passing a string...the
parameter i'm actually taking straight from the testbox object...

Louie



Quote:
>Hi Luigi, what type of value are you trying to pass?  Is it a number or a
>string parameter?  Try taking the space out after the first semi-colon..

>HTH, Paul

Hi
I'm using cr7, vb6, a2K (Acess 2000)

On the developing machine....i pass parameters and it works fine....

I installed the application  on the users machine my parameters didn't
work....
What i tried is to open just the report without passing any parameters
on the users machine...that worked fine

here is my code:

Private Sub cmdClProd_Click()

Dim stTSA As String

'This is the parameter i'm passing its a string
stTSA = txtClientInfo(12).Text

rpt.ReportFileName = "C:\Program Files\report.rpt

rpt.DiscardSavedData = False

rpt.ParameterFields(0) = "NoClient; " & stTSA & "; true"

rpt.PrintReport

End Sub

Could any one help me on this



Sun, 19 Jan 2003 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. WebBrowser Control PostData parameter doesn't seem to work

2. Windows Service Calling VB6 dll doesn't work but works with VB6

3. Query criteria >50 doesn't work if passed from form..;(

4. IE3 doesn't work after working with webbrowser control

5. passing by references doesn't work

6. Why LoadPicture() works on local pathes and doesn't work on the URLS

7. Work Around doesn't work for RichTextBox

8. Works/Doesn't Work

9. ActiveX-Exe: .Value=True doesn't work while direct click on button works

10. Passing binary data as a (unicode) string to API is converted and doesn't work

11. fRefreshLinks Doesn't work if path doesn't exist

12. Can't work out passing parameter..please help

 

 
Powered by phpBB® Forum Software