Formula Error - URGENT, PLEASE HELP..... 
Author Message
 Formula Error - URGENT, PLEASE HELP.....

Hi,

There are two USRE INPUT fields as FromID, ToID (an inquiry for
Employees' IDs in a certain range. ie From: 1234 To: 1550)

I have this code in VB5.0 for CR6.0 Pro.

Dim FromID as string    'List IDs From
Dim ToID as string      'List IDs up to
Dim IDStr as string

FromID = Str(ReportQuery.Text1.Text)
IDStr = "{EmpID.ID} >= " & FromID
IDStr = IDStr & " AND "
ToID = Str(RptQuery.Text2.Text)
IDStr = IDStr & "{EmpID.ID} <= " & ToID
.
.
.
CrystalsReport1.DataFiles(0) = "C:\BUDGET\BUDGET.MDB"
CrystalsReport1.SelectionFormula = IDStr
.
.
.
THEN I GOT THE FOLLOWING MESSAGE:
ERROR IN FORMULA < Record_Selection>
'{EmpID.ID} >= 1234 AND {EmpID.ID <= 1550'
A string is required here

MANY THANKS!

Oga



Tue, 21 Nov 2000 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Formula Error - URGENT, PLEASE HELP....

2. Formula Error...URGENT, HELP HELP HELP... PLEASE

3. Formula Error - URGNET, PLEASE HELP.....

4. PLEASE HELP, PLEASE HELP, PLEASE HELP, PLEASE HELP, PLEASE HELP, PLEASE HELP, PLEASE HELP,

5. URGENT HELP PLEASE PLEASE PLEASE???

6. Please help ...... urgent .strange error

7. URGENT HELP Please: Error 3041 VB4 / Access2.0 / DAO3.0

8. Run Time Error 20504 - URGENT Please help

9. Urgent, please help. Automation Error -2147417851

10. An Urgent Question Please , Please help me

11. Urgent Help Help Help please

12. Can anyone HELP me PLEASE PLEASE PLEASE PLEASE PLEASE PLEASE PLEASE PLEASE PLEASE

 

 
Powered by phpBB® Forum Software