Printing single record from Access via Report in Web Page

This is a discussion on "Printing single record from Access via Report in Web Page" within the JavaScript Forum section. This forum, and the thread "Printing single record from Access via Report in Web Page are both part of the Program Your Website category.



Go Back   Webforumz.com > Main Forums > Program Your Website > JavaScript Forum

Notices


Reply
 
LinkBack Thread Tools
  #1 (permalink)  
Old Jun 18th, 2007, 15:20
New Member
Join Date: Jun 2007
Location: UK
Age: 31
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Printing single record from Access via Report in Web Page

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.

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.
Reply With Quote

Reply

Tags
access, report

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] My Web Page Speed Report. Feedback wanted Oak Search Engine Optimization (SEO) 2 Dec 30th, 2007 18:13
E-mailing a report based on current record on form easydoesit Databases 0 Aug 27th, 2007 23:07
Opening a specific report by matching user input to report ame autoIT Databases 2 Apr 26th, 2007 17:32
Access date field - update as record is updated matrixbrawl Databases 0 Jan 10th, 2007 09:58
printing out a record set backwards riotman Classic ASP 4 Feb 20th, 2006 13:13


All times are GMT. The time now is 09:55.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC8
© 2003-2008 Webforumz.com : All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43