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.
|
|
|
|
|
![]() |
||
Printing single record from Access via Report in Web Page
|
||
| Notices |
![]() |
|
|
LinkBack | Thread Tools |
|
|||
|
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. |
|
|
![]() |
| Tags |
| access, report |
| Thread Tools | |
|
|
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 |