crystal 7.0 VB6 and Access97 
Author Message
 crystal 7.0 VB6 and Access97

I have been having a heck of a time trying to send date parameters to a
Crystal Report7.0 from VB6 and an Access97 database on the local machine
only, not on a network.

I am using two different calander controls to send the dates to text boxes.
This allows the user to pick their dates for the report.
The problem is that I don't know what property to use in code so the report
can pick up the two dates.  I have tried this code:

crReport.SQLQuery = "SELECT Table1.Date, Table1.Site From Table1 WHERE
(((Table1.Date) Between (txtDate1) And (txtDate2))ORDER BY Table1.Date;"

I get an error with this code that says unable to open SQL Server.  I am not
on a network, is this why I get this error?

I have also tried this code:
crReport.SelectionFormula = "SELECT Table1.Date, Table1.Site From Table1
WHERE (((Table1.Date) Between (txtDate1) And (txtDate2))ORDER BY

I get an error that says the remaining text does not appear to be part of
the formula.  There is no other text besides the sql string.

I have built the report already and use crReport.ReportFileName =
"report1.rpt" property

How can I pass the parameters from the two text boxes to the previously
built report so the user can get only the information between the two dates
they desire.

This has been a real headache and any help is greatly appreciated.


Sandy MacDonald

Thu, 18 Jul 2002 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. vb6 and crystal report 7.0

2. vb6.0 and crystal report 7.0

3. Distribute VB6 with Crystal 7.0

4. VB6.0 and Crystal 7.0 Problems

5. Crystal 7.0 & MSS 7.0 stored procedures

6. Crystal 5.0 vs Crystal 7.0

7. Converting from Access 7.0 to Access97

8. Using Access 7.0 Modules in Crystal Report 3.0

9. Crystal Report 7.0 Probleme:(((

10. Crystal Reports 7.0

11. Crystal 7.0 and backwards compatibility

12. VB 4.0 & Access 7.0 Crystal Reports


Powered by phpBB® Forum Software