Form Data To MS Word & Protecting The Form Template

Dec 18, 2006

Thanks to some of the threads here, I have managed to automate inputting form data from a record into bookmarks in a word document template (a letter). What I am trying to do is to lock the letter allowing modification only to the form fields in that template. If the original template is locked (allowing entry only in the fields), the data does not flow through. So I was trying to accomplish this through the "ProtectedForForms" property. However, it does not work. The letter gets locked before the information flows through. Here's the code I am trying to use (borrowed from one of the users here):

Private Sub cmd_letWarn_Click()

' Check for empty fields and unsaved record.
If IsNull(occupant) Then
MsgBox "Occupant Name cannot be empty"
Me.occupant.SetFocus
Exit Sub
End If

If IsNull(propad_no) Then
MsgBox "Building Number cannot be empty"
Me.propad_no.SetFocus
Exit Sub
End If


If IsNull(prop_ZIP) Then
MsgBox "ZIP Code cannot be empty"
Me.prop_ZIP.SetFocus
Exit Sub
End If

If Me.Dirty Then
If MsgBox("Record has not been saved. " & Chr(13) & _
"Do you want to save it?", vbInformation + vbOKCancel) = vbOK Then
DoCmd.RunCommand acCmdSaveRecord
Else
Exit Sub
End If
End If

' Create a Word document from template.
Dim WordApp As Word.Application
Dim strTemplateLocation As String

' Specify location of template
strTemplateLocation = "T:PlanningPlanningEnforcementLogsuppfiles emp warn.dot"


On Error Resume Next
Set WordApp = GetObject(, "Word.Application")
If Err.Number <> 0 Then
Set WordApp = CreateObject("Word.Application")
End If
On Error GoTo ErrHandler


WordApp.Visible = True
WordApp.WindowState = wdWindowStateMaximize
WordApp.Documents.Add Template:=strTemplateLocation, NewTemplate:=False

' Replace each bookmark with field contents.
With WordApp.Selection


.Goto what:=wdGoToBookmark, Name:="ownername"
.TypeText [occupant]

.Goto what:=wdGoToBookmark, Name:="bnum"
.TypeText [propad_no]

.Goto what:=wdGoToBookmark, Name:="stname"
.TypeText [propad_street]

.Goto what:=wdGoToBookmark, Name:="zipcode"
.TypeText [prop_ZIP]

.Goto what:=wdGoToBookmark, Name:="pbnum"
.TypeText [propad_no]

.Goto what:=wdGoToBookmark, Name:="pstname"
.TypeText [propad_street]

.Goto what:=wdGoToBookmark, Name:="ppn"
.TypeText [parcel_no]

.Goto what:=wdGoToBookmark, Name:="ordinance"
.TypeText [code_sections]

.Goto what:=wdGoToBookmark, Name:="orddesc"
.TypeText [complaint_typ]

.Goto what:=wdGoToBookmark, Name:="ownername2"
.TypeText [occupant]

.Goto what:=wdGoToBookmark, Name:="officer"
.TypeText [officer_name]


End With

DoEvents
WordApp.Activate
WordApp.ActiveDocument.ProtectedForForms = True


Set WordApp = Nothing
Exit Sub

ErrHandler:
Set WordApp = Nothing

End Sub

Thanks in adavance for any help.

View Replies


ADVERTISEMENT

Populating Word Template From Form In Access

Mar 7, 2013

I am creating a db for my work place that records incidents that take place. I am a novice at Access but I have made different tables, queries, forms and reports and they all work.

I was wondering if there was a way to extract data that a user enters into a form and then use that to populate a word template *without* coding using VBA? I am really a beginner and not confident with VBA at all. I have read the forum and that seems to be an option (but would rather something else if possible!)

View 3 Replies View Related

Modules & VBA :: Send Form Fields To Word Template?

Jul 2, 2015

I have a form with fields that contain the address/postcode etc of the person in question, and I also have a template letter that needs to have said persons address/postcode etc at the sending stage after a button is clicked.

View 9 Replies View Related

Reports :: Exporting Data To Word Template

Apr 7, 2014

I have a Word template that I require my data to be exported to. Is there a way to import a .docx into a report design?

View 1 Replies View Related

Modules & VBA :: How To Insert Data From Access To Word Template

Jul 28, 2013

I'm doing a project for my work. I created a few reports in Access. Some of these reports are simple graphic bars. How can I insert these reports into a word document template?

View 2 Replies View Related

General :: Create A Button On Form To Convert Data To Text File Template

Jul 14, 2015

I'm currently working on a project within access which will allow users to select/input information in a form which will then save to the database.

What I need is to create a button on the form which will allow you to convert the data collected from the form to a custom text file template.

(Or maybe the last row added to the database. - although this may cause errors. Example: the form information doesn't save which will in turn create a text file with the data collected from the previous job)

The custom text file template should have a sentence description followed by the value recorded from the form.

Example:

1 configuration type: (data from form)

2 model type: (data from form)

3 Poc: (data from form)

And so on.

So in summary - I would be to use the form to collect the desired information which will save to the database.

Once actioned, a custom text file should be populated with the collected information (with specific data placement as per the example above)....

View 1 Replies View Related

I Have A Template In Word

Jul 11, 2005

and I want to write in some places


I know to open the word
and write in to the word


to write in to word:

Dim objWord As Word.Application

Set objWord = CreateObject("Word.Application")
objWord.Visible = False 'True is visible
objWord.Documents.Add ("C:DocumentsTest.dot")
objWord.ActiveDocument.Bookmarks("bmCusDetails").Select
objWord.Selection.Text = Forms![a]![b]


objWord.Visible = True


but how am I write in a special place?

thanks alot, and sorry on my english

View 1 Replies View Related

Link To A Word Template

Jan 23, 2008

Hi I have a database and I want to basically use table fields to load into a Word template and I want this done via code, i.e a button....any help very much appreciated!

View 1 Replies View Related

Modules & VBA :: Import Word Form Data

Nov 26, 2013

I am using the follow code to import data from a Word form into my MS Access 2010 DB:

Code:
Set dbs = CurrentDb
Set rst = dbs.OpenRecordset("tmpSIRs", dbOpenDynaset)
With rst
.AddNew

[code]...

On the Word Form, these two fields are drop-downs with three options: blank, No, and Yes. If the users leaves them blank, then Access ignores them--which is what I want. However, if the user says yes or no, Access puts a "-1" in the database. Both the Word form and Access field are text.

View 2 Replies View Related

Linking Access To A Word Template

Feb 16, 2006

i have a form and was wondering if it was possible to take some of the fields and drop them into a template word document from inside access. so as to create a button that when clicked opens up the template and transferes the wanted form data.

any idears how to automate this process would be greatly appreciated

thanks in advance john

View 2 Replies View Related

Push Data From Current Record In Form Into A New Excel File, Using Excel Template

Sep 10, 2007

I searched the archive and didn't find quite what I was looking for, so..

I have an Excel 2003 spreadsheet work-in-progress being used as a template (developed by others) to prepare project cost estimates in a complex regulatory environment. We are 'modelling on the fly' for a number of projects until we are comfortable with the estimate model, after which time I intend to incorporate our 'stable' estimate methodology into Access. Meanwhile, I am 'stuck' with the Excel spreadsheet.

I have a project tracking database (Access 2003), and I want to be able to track my estimates. I do NOT want to embed my spreadsheets into the db, just a filelink. There can be more than 1 estimate per project.

Ideally, the user should be able to define a project in the Access db (or select one already defined) and click a 'make estimate' button, which would generate a new Excel file in a predefined directory (based on the present version of the .xlt file), give it an appropriate filename (based on the Access ProjectID and estimate sequence number for that project if there were others already), open up that workbook in Excel, and then autopopulate some cells based on information showing on the original form in Access!

A separate button for 'Open existing estimate' will eventually be required, but I think I could do that if I can get someone to walk me through the steps required above.

I am somewhat familiar with vba in Access, but am an absolute rookie when it comes to excel.

Edit: I left out that I would also add an appropriate record to a table like tblEstimate which would contain the link(s) to the estimate(s). This table will obviously contain a FK to tblProject

View 1 Replies View Related

Password Protecting A Form

Aug 30, 2005

Hi

I've got a button on a form that opens another form - nothing unusual, but it would be preferable if this second form was password protected i.e. the user clicks the button to open the form and is immediately prompted to enter a password. I've looked at user-level security wizards but that confused me even more.

The database is networked and is used by 25+ people by the way.

Any ideas?

Thanks for any help!

View 2 Replies View Related

Using A Form Button To Open And Insert Data Into A Word Doc

May 12, 2006

Hi all,
Not sure if this is in the right section but heres my question.

How can i gett a button to open a word document and put in specific information. for example. to send a client a letter, the button would open a word doc with the specfic client data in it.

Also a button to start a mail merge with all client records held on the db.

Thanks for any help

View 2 Replies View Related

Modules & VBA :: How To Save Word Template As HTML

Apr 29, 2014

I'm using the below to merge an access form into a word template (it's a starter for 10).

That works fine. What I need to do is save the word template as HTML so I can then upload it to my website.

Dim wordApp1 As Word.Application
Dim docPath1 As String
Dim fileName1 As String
Dim PageName As String
PageName = Forms!Frm_Page_Create![Page]
docPath1 = Application.CurrentProject.Path & "Merges"

[code]....

View 1 Replies View Related

Create A Custom Word Form Letterdoc From Access Data

May 13, 2005

For keeping record of provient fund, I have made a access/(or excel) database with many fields like ID, Name,contribution for months eg March, April,..to..,Feb,etc.It contains 50 records.

Now I have to print the provident fund statements of my 50 friends. This statement consists of some text language and some data(It is a word form letter document).The statement also shows some data which has to be calculated from the data of database eg grand total, cumulative total, interests etc.

Now I want to print the statement for all or selected no of people. What I want is to make the statement proforma in another excel sheet and then merge and print the statements for selected no of persons eg for ID 1 to 20, 50 to 70 etc. I do not want to make statement in MS word and do not want to merge it there, but I want to do it in excel just as we do in MS word mail merge.

Pl help me how can I do it in access/Excel? Can i calculate in word or should I calculate before hand in access before merging data?

View 1 Replies View Related

Modules & VBA :: Get Data From Microsoft Word Document And Paste It Into Form

Jun 14, 2014

copying all the contents/text from word document and pasted that in the Memo Field, I have a Recruitment database where I have 02 fields on is CV Path (Text Field) that stores the CV Path (Word Document Path) and another text box content (Memo Field) where I would like to copy all the data from the word document to the Content text box (Memo) field.

I have put a Command button on the form...the code to "Copy the content/text" from [CV Path] word document and add it to the "Memo" field.

View 1 Replies View Related

Modules & VBA :: Export Single Record To MS Word Template

May 25, 2015

I am working in Access 2013.I'll be performing a series of inspections at a number of intersections for a small community. The data being captured is consistent from site to site and lends itself to a database application, and what I would like to do is the following:Use forms to capture the data.Generate a report to preview the output for a single record. I may ultimately decide to set the report datasource to a query.Attach a macro to a button that exports fields from that record to a template based in MS Word.The first two bullet items I can handle with my limited Access capability. Each file has to be individually reviewed and saved, and each file will ultimately contain an electronic signature.

View 2 Replies View Related

Forms :: Populating And Protecting Fields On A Form

Oct 15, 2014

I am displaying records from a table on a form line after line like a spreadsheet/data sheet.

I want to do 2 things.

When the user clicks anywhere on a new row to add data I want to populate that row with some data from the row above.

I also want to protect certain fields on each line (but not all lines!)

So basically if the user is presented with

old model number.....new model number..Added by.....date

123456...................77777777................. Fred..........15/10/2014 10:11:12
77777777..................8888.................... .John..........16/10/2014 12:12:12
8888..........................6767................ .....Jack..........16/10/2014 14:11:12
6767..........................4321................ ......Joe..........17/10/2014 10:11:12

I want to protect all of the 1st 3 rows and the old model number in the last row.

When they tab or click into the new row I want the old model number populated with the new model number.

View 14 Replies View Related

Problem With Make Table Query And Merge To Word Template

May 23, 2005

Hi guys!

I have my word template set up such that some data is copied from the open form into the document and some data is taken from a table which is created from a query based on the content of the form (the record number). This works well HOWEVER (there's always a however isn't there :rolleyes: ) where two users click on the button at exactly the same time or within a very short space of time the query only runs once and either the database crashes (bad) or the document is created for the second person with the wrong data (very bad).

How can I make it so that only one person can run the query at a time (ideally build in a delay in processing so that the query will run for them when the first person has finished...failing that a message to say please try again later)? They will always be working with a different record.

I'm a bit stuck as to what to search for in the forum for an answer to this so haven't really searched.....sorry :(

Many thanks
Jo

View 2 Replies View Related

Modules & VBA :: Change Check Box Values Of -1 To YES And Then Fill Word Template

Jul 26, 2013

I have the following VBA code that auto populates a word template:

Private Sub Command24_Click()
On Error GoTo ErrorHandler:
ErrorHandler:

[Code].....

The code executes flawlessy but there are three values that are based off check boxes set as YES/NO (EMPLOYEDATREGISTRATION, EMPLOYED and FRINGEBENEFITS). These values show up as -1 for YES and 0 for NO.

Is there anyway to add code to mine that would allow me to change these values before they are sent to the Word template?

View 10 Replies View Related

Reports :: Filling Report Based On Specific Word Template

Jan 13, 2014

I was thinking today if it is possible to fill Access reports based on a specific Word template? I don't want to populate a Word file with Access data as users of my app might not all have Word. Or is there another solution using a WYSIWYG editor where users can format everything according to their needs? That would be fantastic.

View 2 Replies View Related

General :: Open Word Document With Corresponding Data Filled From Text Field Of A Form

Jul 10, 2013

I am trying to open a word document with corresponding data filled from the text field of a form. I managed to get the word document but I don't know how to give a variable in word document.

View 2 Replies View Related

Password Protecting A Form - Microsoft Tutorial Error

Jul 22, 2005

I was using this form tutorial to password protect my administrative tools. When I went to run it I received this:

"User defined type not defined" and the line Dim rs As DAO.Recordset was highlighted.

I have little experience with VB and I was wondering if someone here had any idea if it was their code that was wrong, or if it was something I did...

View 7 Replies View Related

Forms :: Unhide - Always Show Form From Template

Jan 11, 2014

I downloaded a time clock template the other day and Ive been tweaking it for a while now. There is one thing I can't figure out:

There is a form called frmClockOut, which is a subform on frmClockIn.

This subform appears after the ClockIn button is clicked. The problem is, if I close the database for any reason, and leave someone clocked in, the ClockOut button does not appear until after you re-click ClockIn.

The developer has put in a safety so that it does not "double-punch" someone in or out so its ok there. Id just rather keep this subform open or always showing and cannot figure out where its done on here.

I will upload the blank template that I tweaked.

View 3 Replies View Related

Protecting Crucial Data

Aug 12, 2007

I have a single user DAO .MDE database application
where the calculations rely on data defined
by an external authority and it must not be altered.

To protect the data from accidental alteration,
it is my intention to imbed the data as text lines
in a module.

When the database is opened, a procedure empties
the data table and appends the contents of the text
in the module into the table.

There data consists of 62 records (rows) of 23 columns.
The data changes very rarely, and change would
involve simple text editing.

I am sure that others have come upon a similar
challenge, and my question is if there are other
methods to protect crucial data.

Thanks for any suggestions

View 2 Replies View Related

Modules & VBA :: Static Webpage Form - Export To HTML Using Template

Mar 12, 2014

In my DB I have a query that I need to create a static webpage from, now in excel I can do the record button and bingo, but access is a lot more confusing.

I have a template named doc_tplt.html that when I do the export from the query it creates the webpage using this template.

I want to have a form with a selection of command buttons on it to export to html using the template for various queries and tables.

What is the VBA code to export the query (qry_docs) and apply the template (doc_tplt.html) and save to the same directory as the DB itself.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved