Visual Basic, Crystal Report, Access?

Question

I'm trying to print thru a crystal report object, which calls data from an access db, and then clear the database after its done. the problem i have is that before the crystal report object can load and print, the lines of code that execute the clear are implemented and so when the report prints it's blank.
what can i do to fix this issue?
heres the process:
1) insert into db
2) load crystal report
3) print from crystal report (via destination printer)
4) clear database ( via rs.delete)

I need to do this without using the crystal report window. This is a process where the use will be scanning in multiple requests and then have them being printed in a for loop.

I need to do this without using the crystal report window. This is a process where the user will be scanning in multiple requests and then have them being printed in a for loop.

Answer 1

This is the way I did and it works for me
1. Connect vb to access
2. Insert crystal report control to form
3. Write the code
eg.
CrystalReport1.ReportFileName = "c:\cmr\marks.rpt"
CrystalReport1.SelectionFormula = "{stud_marks_2001.pin}='" & txtROLL.Text & "'"
CrystalReport1.Action = 1

4. Now as the Crystal reports open there will be a print button on the reports.
5.Click on it the report gets printed.
6.Close the reports
7. Close the application