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.
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.