i have a word doc that is built by code. at the end, after the doc is completely built, i save the doc and kill my word object. what i want to do is be able to launch the doc automatically for the user, but still be able to kill the code object used to create the doc. what i currently have, which obviously doesn't open the doc, is as follows:
Code:wrd.ActiveDocument.SaveAs sOutputDir & sHeader & ".doc"wrd.ActiveDocument.Closewrd.QuitSet wrd = Nothing
i can't figure out how to get word to open with my doc. i'm sure i'm overlooking something simple, but does anyone have ideas for me on this?
As a basic user and relatively new user of Access, I have designed a database which holds the data for several word documents that I use for mailmerges. I want to be able from the "switchboard" link the word documents so that users can easily access the letter/form required and print them. Ive tried many things - just not working!!!! Time to shout for help!
How is it possible to open a form letter word docment from an Access form in which information on the form (such as name and address) is used in the letter?
Is it possible to open a Microsoft Word FILE using a macro(or even a query??)? I know how to open Word itself using a Macro by Selecting the Run App Command and typing in my Word address e.g C:Word.exe . I have tried opening a word file using C:filename.doc but no success, the address is correct as I've successfully opened it using Start, Run
Sorry but I'm really new to Access and trying to make sense of all the useful advice on here!
I'm trying to programme a button in one of my forms to open up a word document as read-only. I've written the code to open up the Word application (before I found the button which did it for me! :( ) but I think I need to add one or two more lines so that word knows where the document is I want and opens it up - any ideas what these lines are?
Real sorry for the trouble - any help would be most appreciated! Thanks guys and girls.
I have searched this topic but can't find exactly what I'm looking for so I hope someone help.
I have a directory full of doc files which are constantly being updated. I would want to be able to browse the directory from Access and click on the relevant file to open it directly.
So there's no storing the pathnames in a table etc...just open the doc to view.
I have a form with various details on clients. I have 6 different letters that need to pull off different fields from the client form. Is it possible to have a button (for each letter) that when when clicked will open up the word document for the specific client with the fields on their poulated, such as name, ammount owed etc.
Mail merge does not do the trick as it brings back all the clients in the database and not the specific one.
I have completed a form that I am ready to put into production. I want to include a couple help documents with the database. There are two word documents that are stored as OLE objects in a table. I normally wouldn't include OLE objects like this because I would want to keep the DB size down, but there should only be 2-3 small word documents What needs to happen: click a button on a form and have the correct word document open.
The tbl they are stored in is called tblAddins. Two columns thus far, named: ID (autonumber primary key) file (OLE)
The only thing that the wizard (wish i didn't need to use it) gives me for Word is to open the application itself.
Thanks in advance to the great minds of this forum for any help.
I would like to open a Word document using a button control on a form to a file path listed in a field on the form. I use the following code when I want to open a single specific document...
Dim wdApp As Word.Application, wdDoc As Word.Document On Error Resume Next Set wdApp = GetObject(, "Word.Application") If Err.Number <> 0 Then 'Word isn't already running Set wdApp = CreateObject("Word.Application") End If On Error GoTo 0 Set wdDoc = wdApp.Documents.Open(File path here) wdApp.Visible = True
...but in this case the file path I want to use will be designated by a field on the form. I know I could just use a hyperlink but I don't like the way it looks on the form. I would rather hide that field and have code pull that path when I hit the button.
So how would I change my code to make it so the value in the file path field on the form goes in where it says "File path here" in my code above?
I am very close to completing a DB Program.... How can I create a desktop Icon that will Launch my Program without Loading Microsoft Access along with it???
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:
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?
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.
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?
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.
I have a database (.mdb file) which includes a table, forms and VB code. I intend on putting it onto a CD and then opening the form on another computer which may not have Access. Is this possible? Can I convert the file or can I attach some type of reader to the disk? I have seen some software for download on the internet which allows you to open the tables however the Form is the most important thing in this case (but I take it whatever I use, it will need to be able to view the VB, subforms and tables as well since the Form depends on them?).
...also can I install an auto-run to the file for when the disk is inserted? (this is not a major issue though).
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.
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 :)
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.
Hi there, I am doing a project for my A level computing, and for my mum's financial advising.
I am to assume no knowledge of computing on her part, and so i cannot make it up to the end user to know how to mailmerge. I was wondering if you could help. I can have it in a query, form or table form, whichever is best for this, but i need to be able to make a button which exports a record into a MS word mailmerge. This is just to make a simple letterhead. I need a button that says " Write to client ", and once it is clicked it needs to open a letter addressed to them. This is my problem. I have noticed when the data is in a report, there is an export to MS Word button, which is very close to what i want as i could use that and get a good enough mailmerge, but is there a way to run this from a macro or using VB? I did VB last year for my computing project and so i understand a fair amount of it. I want to just make one word document, which will open as mailmerged with the clients data. Please help if you can, I am sure it is possible as i can see you can mailmerge from access, and there is even a button to do it.... kind of, i just need to be able to make my own. Thankyou so much for your help. Steve ( Microsoft Access 2003 )
I have an Access 2007 Database, containing Dues records for a Membership type application. Each Month I produce a Newsletter vis Publisher 2007, which ends up in PDF format. e-mail Address information is in Outlook 2007, snail mail adress info is in Access.
I want to be able to send an e-mail (Merge ??) to all those who have e-mail, with the Newsletter as an attachment, and with the Dues data in the body of individual e-mails (Merge ??). As the data resides in a number of applications, can someone point me in the direction I should take to achieve this.
