Computer Programming Tutorials - Wordpress Theme - Buy WoW Gold - WoW Gold - Loans

PDA

View Full Version : Printing single record from Access via Report in Web Page


Neotekk
Jun 18th 2007, 8:24 am
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.