Open file in VB from database?!

I'm fairly new to access, VB, and Crystal reports. I have a button that i click in access that generates a table that is read in crystal. I want the .rpt file to lauch automatically after a build button is clicked that exists. I simply dont know what the code is to open a file rather than an application.

Welcome to the forums. :wave:

I'm bit confused over the question. Do you want Crystal Reports to open the .rpt file or VB?

sorry i was unclear,

when a button is clicked in access i want it to launch a crystal reports file (.rpt)

So the VB in Access needs to accomodate the opening of the file

Place The crystal report control on the form,(Common\Tools\VB\Crystl32.exe)
connect it to the report file name.Place these code on button click.

Code:

---

CrystalReports1.ReportFilename="C:\Folder\Report1.rpt"
CrystalReports1.Action=1

---

(CrystalReports1 is the control name)

I dont know what you mean or where to find "The crystal report control" and how to put it on a form? Also, I have no Common option from the menu bar nor a VB selection inside tools

Check this site
http://www.vbexplorer.com/VBExplorer...al_reports.asp

Go to project components and browse for Common\Tools\VB\Crystl32.exe to add CR control to your project