TRying To Open A Word Doc From Access

Sep 20, 2004

I have a word doc which i can open from Access but i need advice on something i would like to try out.

I have a form with a patients name and i can scroll through the table through here(on the form using nav buttons) as well and see other patients information. What i'm trying to do is according to whoever is on the form when they click on the button to open the word doc i want the patients name to appear on the word doc.

I guess it's like a Mail merge but i want the data to be pulled from the form like the patients name and address and i want this information to go onto the Word Doc. Any ideas on how to do this.

Access 2003 and Word 2003.

Thanks in advance,
Skiball

View Replies


ADVERTISEMENT

How To Open A Word Document From Within Access

Jan 4, 2007

I am creating a database for someone which includes a mail merged document with some data from the database.
Is it possible to allow the user to open the document by clicking on a button that will be on the Switchboard in the database, so that they do not have manually open the document?
Hope this makes sense!

View 5 Replies View Related

Open A Word File Within Access

Jan 11, 2007

I would like to Open a Word file throught Access code.
With the following code I can start Word, but how can I specify the file name I want to Open:

Dim wrdApp As Object
Set wrdApp = CreateObject("Word.application")
wrdApp.Visible = True

Thanks

View 2 Replies View Related

Open Word Window On Access Form

Sep 6, 2005

Hello,
I am a researcher creating critical editions of ancient texts by collating readings from several manuscripts (i.e. different mss all contain minor differences). I create my edition in Word and use footnotes to record the variant readings. I also have a database - created from the word file - in which I can add context to each variant e.g. decisions, history etc. So I have a word file containing the text and its variants uniquely identified with a footnote reference and a database with one table and a record per variant and where the variant records are also unique and share the same number as the footnote. I would very much like to be able to open a window on my variant form which displays the word file at the correct variant (i.e. footnote reference) location. This will make it easier for me to record my assessments of the variant in the dbase while looking at where the variant occurs in the text. Obviously I don't need to see the footnote window as I have this info in the dbase.
I haven't got a clue how to do this and would appreciate any pointers.
Many thanks in advance,
Tim

View 1 Replies View Related

Open Word File Off Access Form

Jul 9, 2012

I have fairly large Access 2003 tables and forms on my job. I am curious if I can open word document off the form by using command button. Very often I need to put info off the form to word and sent it via e-mail to clients so I every time I have to keep a lot open word documents at the same time on my computer 10 or more that is slow pc down. I would like to have like this : on specific form I have command button and when i need to work with word document , click that button that will open specific word doc and when I am done I think I need a second command button to safe and close word document and so that i can attach it to e-mail and sent it out. So every time I need to work with word doc, I can open it off the form and close it also when I am done with it so no word doc would be open unnecessarily.

View 8 Replies View Related

Use Access To Open Word, Create A NEW Document, And Then Edit The Doc

Dec 11, 2004

I want to create a new word doc, do a saveas to a specific path and file name, allow the user to edit the new doc, and then close it and return to the Access app. I can create the doc but Word opens without opening the New Savedas Doc. using this code

Dim oApp As Word.Application
Dim WordDoc As Word.Document
Set oApp = CreateObject("Word.Application")
Set WordDoc = CreateObject("Word.document")
oApp.Visible = True
WordDoc.SaveAs ("TS-" & Me.Scriptnum & ".Doc")

Your help is appreciated.

View 1 Replies View Related

Modules & VBA :: Search To Open Word Document From Access

Oct 27, 2014

I was tasked to create an application where by the user enters keywords into an Access form, and when he clicks the button, it will run the keywords against the file names stored in the table and automatically open the Word document that is the best match.

I have created a table query called Directory, which contains FPath (Z:), FName (Document1.doc) and Directory (Z:Document1.doc).

Code:
Private Sub Command2_Click()
Dim wrdApp As Word.Application
Dim wrdDoc As Word.Document
Dim filepath As String
Dim strSearch As String

If IsNull(Me.txtSearch) Or Me.txtSearch = "" Then
MsgBox "Please type in your search keyword.", vbOKOnly, "Keyword Needed"

[Code] ....

This is the code that I am currently using to search and open the Word documents, however, this code only manages to open Microsoft Word program without loading any documents. Also, there are no error messages when I click the submit button.

View 3 Replies View Related

Forms :: Open Word Document Via Access Command Button

Feb 4, 2014

I am creating a database. I have all my forms, queries, tables, reports just as I need them. However, I would like to have a command button on my switchboard that will pull from a query to feed to a Word document (that's actually a letter on my company letterhead). I know a Macro has to be involved with this, but again, I have little to no knowledge of Macros. Also, I would like to be prompted to enter a client ID number when I click on this command button (because I only want to print a letter for a new client, not all of them).

View 4 Replies View Related

General :: Possible To Insert A Button In Access Form Which Would Open A Word Document

Mar 3, 2013

I have an access form that fills an access table (MS Access 2003). Also, I have a Word (2010) document/template with some template text and empty fields which should be filled with data from access. Is it possible to insert a button in access form which would open a word document and populate appropriate fields with data from that form?

View 4 Replies View Related

Open A Word File From A Form

Jun 5, 2005

Hi all
I need to run a certain file from the form
I create a button as follows
Select in the categories "Applications" then select "Run Ms Word"
I have tested it and it open Word but not even a blank page
I then open the code as seen below and want to insert the filename but do not know where. Can someone please help me?

Private Sub Command35_Click()
On Error GoTo Err_Command35_Click

Dim oApp As Object

Set oApp = CreateObject("Word.Application")
oApp.Visible = True

Exit_Command35_Click:
Exit Sub

Err_Command35_Click:
MsgBox Err.Description
Resume Exit_Command35_Click

End Sub

The file is - D:PanelbeatersPb Manual.doc

View 2 Replies View Related

Open Word Specific Page

Apr 5, 2008

Anyone able to help. Can a command button be coded to open either a Word or PDF file at a specific page number? Any help really appreciated.

View 1 Replies View Related

Open Hyperlinked Word Documents As Read Only

Mar 22, 2014

I have a database with hyperlinks to open word documents on my network. If someone else has that word document open it will ask me if I want to notify or open in read only. However since upgrading to Access 2013, (from Access 2003), this sometimes freezes the database.

I am wandering is there a way to tell Access (or Word) to open the document in read only if there is someone using it already?

View 1 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

User Database From Command To Open Word Document

Mar 6, 2007

In access database, Is there anyone know how use macro to open a word document on a share drive..(example S:safetyRegulation.doc)?.

Here is what I did and it doesn't work.. Runapp command line: C:Program FilesMicrosoftOfficeOfficeWINWORD.EXE //S:safetyRegulation.doc.
Is there any easier way to do this? Please advice..thanks Rob..

View 1 Replies View Related

Reports :: Open Report As A Microsoft Word File

Jun 26, 2014

I want to open a simple report (restricted to the current record) but I need it as a editable MS Word file, (not printed or pdf, etc.)

Quote:

Private Sub MyReport_Click()
Dim stDocName As String
Dim strWhere As String

[code]....

I've tried several combinations of vba..I'm using Microsoft Access 2007

View 3 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

Open "Print Layout" In Word By Code

Jul 16, 2005

In the menu in word there is some option to view the documents
1. Normal
2. Print Layout
3….


I open the word’s document from the access
I insert value from the access into word.

I asked here some question in last week and I helped so much.

My question now is:

In the document in the word I put some bookmarks.
One of the bookmarks is on the header (Title of the document)

And then when I open the document its open in a “Normal” view
I want to open the document in “Print Layout”

Can I open a document in “Print Layout” by code?

The problem code is:
objWord.ActiveDocument.Bookmarks("nivchan").Select
objWord.Selection.Text = Me.M_NIVHAN
Because the Bookmark: “nivchan” is on the header.

Thanks a lot and good week!

View 5 Replies View Related

Access To Word

Jul 9, 2007

Hi,

This is my First post - so please be kind. I'm quite new at coding things and have learnt almost every thing from this forum so far by search old posts but can't find the answer to the below. I know how frustrating it must be to answer the same question over and over again so if this has been answered before please accept my appologies and if you could direct me to the old post I'll pick it up from there.

I have managed to get my DB to output to Excel using the below code:

Set Xl = CreateObject("Excel.Application")
Xl.Visible = True
Xl.Workbooks.Open ("C:TEMPPACLPACL - Blank") ',,True

Xl.range("C8").Value = [Text78]
Xl.range("C9").Value = [tender name]
Xl.range("C10").Value = [Request Number]
Xl.range("F10").Value = [Accepted offer]
Xl.range("C14").Value = [Site Status]
Xl.range("C16").Value = [Accepted offer SPO]
Xl.range("C17").Value = [Type]
Xl.range("C19").Value = [Mpan]
Xl.range("C20").Value = [HH MOP]
Xl.range("C32").Value = [Payment Terms]
Xl.range("C13").Value = [No of sites]
Xl.range("C4").Value = [Text173]
Xl.range("A47").Value = [Additional comments]

I now need to do the same for word;

I have managed:

Dim oApp As Object

Set oApp = CreateObject("Word.Application")
oApp.Visible = True
oApp.Documents.Open ("C:TEMPQuatation") ',,True

but I have no idea how to get the info held in field [tender name] in my database into the Ln 5, col 10 in my word document.

I hope this makes sense, any help will be greatly received as I am very new at this and very eager to learn.

View 4 Replies View Related

Access To Word, Once Again!

May 16, 2005

Okay, m sorry to bring this topic up again!

I have created this command button from tools that output the access report into word file. However, it prints all the record into word file, is there a way that it would print one record or selective record at a time. I mean, lets just say if I am on record 3 after I am done I press the button and I don't want it to output 1 to 3 record just the 3rd one. Is it possible to do it like that or not?

View 14 Replies View Related

Word In Access

Nov 19, 2005

Hey all! :cool:

I have a question to ask you all. This has been killing :( me I have not been able to find an answer. :confused:

Lets say I have a form open. In this form, there are text boxes that have a persons name, address, an account number, and phone number. This part is the easy part.

Now, what I would like to do is some how when you click on the account number, (it doesn't have to be a link) it will open up another form that shows available Word Documents for only that account number.

Different account numbers will have different Word Documents available to them. When this new form opens, then the user can pick a Word Document that is available to them.

Please help! Your help would mean a lot! :)

View 10 Replies View Related

Word To Access

Oct 21, 2004

Hi does anybody know if there is a way to import data from a word

template to fields in an access database? any help will be greatly appreciated!
thanks, Treasa

View 4 Replies View Related

Access And Word

Mar 23, 2005

Is one better than the other to get information into Word Documents

Using access to control word and use mail merge (can I set up the data source for the word document from access...how?)

-or-

Using access, fill in bookmarks created in Word

I have about 30 word documents from a real estate company that they want data from the database merged into the word documents. Too much formating in the word documents to use access report. Any suggestions?

View 3 Replies View Related

Access To Word

May 4, 2006

I have given up on doing this since I am obviously stupid, but I have a word document that has most things static and about 6 fields that are dynamic. I would like to develop a small GUI in access that the user can input the data into the fields and then click the print cmdbutton that I create and it will open the Word doc, fill the fields that need filled, then print the form.

I tried a mail merge, but I really need this to be a seamless process.

If I use a report in Access, will it hold Word formatting?

These are legal documents that are being printed out.

I wanted to do it with some type of web based app, but my web server is Windows and not Unix so I cannot use CGI.

Any ideas on what I should do?

Thanks in advance for your help.

Robb

View 3 Replies View Related

How To Match 4 Character Word Or Number Or Combination By Identical 4 Characters Word

Apr 11, 2013

How to match 4 character word or number or combination by identical 4 characters word or number or combination in one word have 10 or 15 characters.

I have to two separate tables (Table A and Table B). Table A has one column (Tag No) and Table B has about 15 columns with one column name Tag No as below

Table A

Table B

Tag No

Tag No

2009

ZZZ-2030-DC

2010

ZZZ-2010-M9P

[code]....

They're both in MS Access.I am trying to match 2 tables - columns (Tag No) with join query, but not success. I want to match 4 characters in Table-A with 4 similar characters in Table-B (Tag No) cell.What query is suitable to compare two tables.

View 8 Replies View Related

Access And Word' Work Together???

Jul 13, 2005

I have an application on access that export the data to word.

I did a query and the data export to word

my code is:
Dim db, rst
Dim strSQL As String

Set db = CurrentDb
'÷éùåø åôúéçú ååøã, åäöâúå áöåøä îåñøú
Dim objWord 'As Word.Application
'Set word as an application and make it invisible
Set objWord = CreateObject("Word.Application")
objWord.Visible = False 'True is visible

'ùí äîñîê
objWord.Documents.Add ("C:doc3.doc")

strSQL = Me.strSQL
Set rst = db.OpenRecordset(strSQL)
rst.MoveFirst
Dim strString As String
strString = ""
Do While Not rst.EOF
'ID---------------------------------
strString = strString & rst!nameID & vbTab & vbTab & "|"
'name-------------------------------
If Not IsNull(rst!fName) Then
strString = strString & rst!fName & vbTab & vbTab & "|"
End If
'lName---------------------------------
If Not IsNull(rst!lName) Then
strString = strString & rst!lName & vbTab & vbTab & "|"
End If
rst.MoveNext
strString = strString & vbCrLf
Loop
objWord.ActiveDocument.Bookmarks("aaa").Select
objWord.Selection.Text = strString
objWord.Visible = True
my question:

I want to export the data to a table in word.
I attach the file
(to work good put the file "doc3.doc" to "c:/")
how can I do it?
thanks :)

View 4 Replies View Related

Exporting From Word To Access

Nov 7, 2007

Hi,

I'm new to this forum and it's my first post, any help is greatly appreciated.

I have just been given a big project of firstly transferring information we hold in word documents over to Ms Access and then using ASP or .NET I got to make this a searchable, more user friendly web page displaying the information from the database.

I have tried searching on the web but have not found anything that can transfer information from a table in a word document to a table in Ms Access, does anyone know of anything out there that allows this to be done without losing any data in the transfer?

I have tried saving the document as a text file and importing it into Access but it did not transfer the data across correctly.

View 3 Replies View Related







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