Using a command button in MS Access to open Seagate Crystal Reports
Posted on 2002-03-21
I am using Crystal as a query tool to access client information from our mainframe. I would like to launch a Crystal report from Access so the user would not have to use both applications (Access and Crystal) in a disjuncted manner. The effort here is to use a command button to open a pre-established Crystal report that would look up all of the personal information on one of our clients based on policy number. The query results from Crystal would then populate in a table in the Access database. The database used here will track complaints for our company. Instead of having to type all of the client information manually (and avaoiding data integrity errors) we would like to use the protocol described above. Do you know if this can be done? Please let me know if you need more information. Thanks!