Open file in VB from database?!

[cjmcfg]

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.

[Hack]

Welcome to the forums.

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

[cjmcfg]

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

[amrita]

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.

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

(CrystalReports1 is the control name)

[cjmcfg]

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

[amrita]

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