Access Query

[elibb]

hi... i have a vb6.0 application and im trying to make a report from an Access database, i created my query in access as query, its like this:
"Select name from Table where id=[?]"

when i run the query in access, it askes for the value of id i want. how can i send the value from my program??

thank You very much

Eli

 

[rogar]

I don't know if CR can see Access query parameters the way it does SQL Server Stored Procedure parameters or CR SQL Designer parameters. You can create a parameter in CR design view and use it in a record selection formula. The data access penalty with an Access database should not be excessive. Then just use tables or an unparametered query as your data source.

 

[poconoski]

First create and ODBC connection.
Then in Crystal start a new report using the expert.
Select Databases
ADO make new connection , Uses ODBC connect for ADO
Click ADD and select Query Name
OK
Close
NEXT, Select Fields