Previewing a report Using Crystal XI in Access 2003

[dick3425]

I used register the crystl32.ocx then put the active X control (Crystal Report Control) on the form name it Report1 and write the following code assigned to a button:

Private Sub cmdPrint_Click()
With Report1
.WindowShowRefreshBtn=True
.ReportFileName = "C:\SomeReport.rpt"
.Action=1
End With
End Sub

Now I get an error on .Action=1

Does anyone know if the code has changed for Access 2003 or is it that Crystal XI doesn't work with Access 2003?

[ADezii]

I used register the crystl32.ocx then put the active X control (Crystal Report Control) on the form name it Report1 and write the following code assigned to a button:

Private Sub cmdPrint_Click()
With Report1
.WindowShowRefreshBtn=True
.ReportFileName = "C:\SomeReport.rpt"
.Action=1
End With
End Sub

Now I get an error on .Action=1

Does anyone know if the code has changed for Access 2003 or is it that Crystal XI doesn't work with Access 2003?

I am a little fuzzy in this area but I thought that the Crystal ActiveX Report Control was used primarily within a Visual Basic Application in order to provide limited Reporting capabilities. Why would you use this functionality when the Rerporting capabilities within Access are superior?

[dick3425]

I am a little fuzzy in this area but I thought that the Crystal ActiveX Report Control was used primarily within a Visual Basic Application in order to provide limited Reporting capabilities. Why would you use this functionality when the Rerporting capabilities within Access are superior?

Actually, Crystal Reports is far superior to Access. There is no need to build queries in access to run your reports it is all done in Crystal. There is a lot more flexibility in Crystal.. You are partially right in that a version of Crystal was made for VB.net. I have been using this in Access for years. The user does not need a license only the runtime files. The code I use is the same code used in VB 6.0. Can you help?

Thanks