Access 2000 and Crystal Reports 8.5

CVitanza · #1 Jul 21, 2004, 06:20 AM

I am in the process of developing an application using Access 2000. I have not been able to find anything on what I want to do. My question is I have setup a switchboard to access reports and forms, I want to have a botton which would do the following items (behind the scenes)

1) execute a predefined Crystal Report which will
prompt the user for a date range of the items
which need to be selected
2) Take the data from the report and do an export
to a text file
3) Import the text file into a access database and
add the records into the database (I already
have setup Import/Export Specs), I also need to
know how to make sure that the data show up
as fixed width so that my specs will work.

LoveToCode · Aug 20, 2004, 01:24 PM

Silly question, why call CR from Access, it has decent reporting built in. You can do what your talking to, how much coding do you want to do?



At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to: Get free answers from experts in any of our 300+ topics. Accept money for answers that you provide. Communicate privately with other members (PM). See fewer ads. Sign Up!