Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / May 2007

Tip: Looking for answers? Try searching our database.

Inserting data from an ACCESS form into a bookmark in WORD

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Doctorjones_md - 18 May 2007 16:56 GMT
I have the following code (which opens a NEW Word document and prints the
data from my ACCESS form) -- I need code that will open a specified WORD
template and insert the ACCESS data into a specific bookmark.  I'm sure this
is a simple process, but I'm somewhat frazzled (at this point) and have
settled on this option over several previous suggestions.  Here's the code I
need to modify:
==================================
'The following code outputs the Print Detail data to a NEW Word document

'On Error GoTo Err_Command83_Click

   'Dim stDocName As String
   'Dim MyForm As Form

   'stDocName = "PrintDetails"
   'Set MyForm = Screen.ActiveForm
   'DoCmd.SelectObject acForm, stDocName, True
   'DoCmd.PrintOut
   'DoCmd.SelectObject acForm, MyForm.Name, False

'Exit_Command83_Click:
   'Exit Sub

'Err_Command83_Click:
   'MsgBox Err.Description
   'Resume Exit_Command83_Click
Ken Sheridan - 18 May 2007 17:58 GMT
You can download a file from the link below which includes examples of
various Access to Word automation operations including inserting data into
bookmarks in a Word document:

http://community.netscape.com/n/pfx/forum.aspx?msg=23781.1&nav=messages&webtag=w
s-msdevapps


Ken Sheridan
Stafford, England

> I have the following code (which opens a NEW Word document and prints the
> data from my ACCESS form) -- I need code that will open a specified WORD
[quoted text clipped - 22 lines]
>     'MsgBox Err.Description
>     'Resume Exit_Command83_Click
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.