Can anybody please help me... i really need to be able to do the following
two things but i am at a total loss at to how to do it or where to find out.
I am using VB5.

1) I need to be able to create a Crystal Reports report using the current
recordset, then view the report from within VB5.

2) I need to be able to view an Access 97 report from within VB5.

If anybody can help, i will be extremely thankful.

1) Crystal Reports V8.0 will produce a report from an ADO recorodset.  I
don't think the free version packaged with VB5 has that capibility.
2) I was able to run an Access97 report via VB.  I abandoned the effort
because Access needed to be installed on the client machine.  Simply
ncluding the Access library ref. was not sufficient.
Here's the code:
' run Access report for current SensRef
Public Sub RunRpt()
  Dim oAccess As New Access.Application
  Dim strSensRef As String, strWhere As String
  oAccess.OpenCurrentDatabase mstrDataBase                 ' module level,
.MDB path & name
  strSensRef = oRSet![tblSensor.SensRef]                          ' module
level ADO recordset object
  strWhere = "tblSensor.SensRef = '" & strSensRef & "'"     ' watch single
quotes
  ' qrySensor is Access Select query, rptSensor is Access report built on
qrySensor
  oAccess.DoCmd.OpenReport "rptSensor", acViewNormal, "qrySensor", strWhere
  oAccess.CloseCurrentDatabase
  oAccess.Quit acQuitSaveNone
  Set oAccess = Nothing
End Sub
--
John Goodfellow
irtf'nm
use 'microtouch' in address to email