Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_web_howto thread: MSAccess Reports


Message #1 by "Drew, Ron" <RDrew@B...> on Fri, 12 Apr 2002 08:33:51 -0400
This is a multi-part message in MIME format.

------_=_NextPart_001_01C1E21E.4CF76F87
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I have a site that uses an Access database for add,change and delete
that works fine.  I also have some reports that I have written within
the Access DB which are not fired off from the website.  Is there a way
to execute an Access report from an ASP?

Today I have a form on the Access DB for reports that has buttons firing
off events like the following...

Private Sub Total_Members_Cars_Click()
On Error GoTo Err_Total_Members_Cars_Click

    Dim stDocName As String

    stDocName =3D "Total Members/Cars"
    DoCmd.OpenReport stDocName, acPreview

Exit_Total_Members_Cars_Click:
    Exit Sub

Err_Total_Members_Cars_Click:
    MsgBox Err.Description
    Resume Exit_Total_Members_Cars_Click
 
End Sub


  Return to Index