PC Review


Reply
Thread Tools Rate Thread

Auto Print from multiple tables

 
 
Krefty
Guest
Posts: n/a
 
      14th Sep 2003
Thanks for looking at my problem...I am wondering how to
set up a Print button on a Form that will referance 3-
specific Text box/table contents...and then export the
contents of the selected student on the form to print a
word certificate.....Any ideas?

Thanks, Krefty
 
Reply With Quote
 
 
 
 
Tim Ferguson
Guest
Posts: n/a
 
      14th Sep 2003
"Krefty" <(E-Mail Removed)> wrote in
news:042901c37a79$ea8e6d60$(E-Mail Removed):

> Thanks for looking at my problem...I am wondering how to
> set up a Print button on a Form that will referance 3-
> specific Text box/table contents...and then export the
> contents of the selected student on the form to print a
> word certificate.....Any ideas?
>


Probably something along the lines of this: hugely oversimplified so you
can see what is meant to be happenning.

dim appWord as New Word.Application
Dim docWord as Word.Document
Dim bmkCurrent as Word.Bookmark

Set docWord = appWord.Documents.Add("StudentReportTemplate")

Set bmkCurrent = appWord.BookMarks("FullName")
bmkCurrent.Text = Me!txtFullName

Set bmkCurrent = appWord.BookMarks("ClassTitle")
bmkCurrent.Text = Me!txtClassTitle

Set bmkCurrent = appWord.Bookmarks("TeachersNotes")
bmkCurrent.Text = Me!memoNotes

docWord.PrintOut(wdCurrentPage) ' can't remember arguments

docWord.Close wdNoSave
appWord.Quite


Hope that gives you something to start on.
Best wishes


Tim F

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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 Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto table feature in excel doesnt work on multiple tables =?Utf-8?B?Q2hyaXMgTGFtcGFyZA==?= Microsoft Excel Worksheet Functions 0 26th May 2006 01:18 PM
Re: Can I update tables from a form using query with multiple tables? John Vinson Microsoft Access 0 8th Sep 2004 11:45 PM
How to create data adapter for multiple tables (joint tables)? Nguyen Microsoft ADO .NET 1 16th Jun 2004 08:38 PM
How do I create a spreadsheet from print tables/pivot tables =?Utf-8?B?SGFycnk=?= Microsoft Excel Misc 3 10th Dec 2003 02:40 AM
Default Print Style for IMAP messages changes to Tables when printing multiple items at once. Richard Maier Microsoft Outlook Interoperability 0 18th Nov 2003 07:34 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:01 AM.