Printing single record from Access via Report in Web Page

Discussion in 'JavaScript' started by Neotekk, Jun 18, 2007.

0
  1. #1
    Hi

    Am totally new here, so please help me! I have created an Access database, all is fine there. Created a Form, all is fine there. Created a HTML page of the form, so far so good! :)

    I ever created a button on the Web page to open an already created Access Report and print! The trouble is that my button prints out all the records in the database and I only want it to print out the record showing. :mad:

    This is the JavaScript I have put in for my button:

    <SCRIPT language=vbscript event=onclick for=Print_Letter>

    Set objAccess = CreateObject("Access.Application")
    objAccess.OpenCurrentDatabase "D:\Detentions\Detentions.mdb"
    'objAccess.Visible = True
    Set objCommand = objAccess.DoCmd

    objCommand.OpenReport "Letter"

    objAccess.CloseCurrentDatabase
    </SCRIPT>

    So I'd love to me able to amend this to print just the Record showing. Can anyone please help? Thank you.
     
    Neotekk, Jun 18, 2007 IP