Forms :: Opening A Word Document Via A Button Control On A Form?
Aug 5, 2015
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?
View Replies
ADVERTISEMENT
Feb 4, 2005
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.
View 7 Replies
View Related
Jan 12, 2005
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.
View 3 Replies
View Related
Feb 15, 2005
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?
View 3 Replies
View Related
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
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
Sep 14, 2006
I've used the Outputto method to archive reports creted in Access to Word in .rtf.
I now want to have an option to view these archives from Access. How?
Thanks,
Richard
View 2 Replies
View Related
Sep 20, 2006
Sorry if this isn't the right place for this, but it didn't seem to fit in anywhere else.
I have a simple database, which pretty much now works as I want it to. The only element I really needs to get working is some way of producing - at the click of a button - a Microsoft Word document, elements of which are populated by fields on whichever record the database user happens to be viewing at the time.
I already have the exact layout and template of the Word document I want, but I need to be able to view any record then click one button to fill that template with the record's fields and print it, and another button to fill the template with the record's fields and save it (again, in .doc format).
Is this possible?
View 13 Replies
View Related
Oct 7, 2013
I have a Word 2010 document linked to an Access 2010 data source. When a user clicks a button in Access, the Word document loads and performs a email merge using the below VBA code:
Private Sub Document_Open()
With ActiveDocument.MailMerge
.Destination = wdSendToEmail
.SuppressBlankLines = True
[Code] ....
However, as the .mailsubject part is not in the loop it is only retrieving the first Return Code. I have tried to integrate in the loop to no avail. Also, how do I add static text to the Subject, I need something like "Your Return Code" + "Return Code"..
View 6 Replies
View Related
Nov 29, 2004
Hi
I have a form (Quotation) and i would like when i press a command box to save it as a word document.
I tried that with a command box and with a macro using OutputTo Action.
I can save the Form But i can not have a proper understandable format.
How this is possible?
My aim is to save it as .rtf for example, and attached to the customer mail.
Please advice me.
View 4 Replies
View Related
Oct 17, 2006
Hi....
I have created an Access Form wherein i have given lots of text box and text areas...
Now i want to create a word document dynamically using the information that has been given by the user via the Access form...
I want to create a Table dynamically in the Word Document using the VB code behind an access form... Also through that code i want to manage the font of Word Document and most if its controls..
Can u plz help me in this or provide me with a document wherein i can get some info in regard to it i.e. to manage the Word using Code...
Thanking you,
with regards,
Kapil Sharma
View 1 Replies
View Related
Jul 9, 2013
I want to have information on a form tab. Is it possible to insert a Word document in the tab? This will consist of a set of instructions for the user.
View 4 Replies
View Related
Oct 17, 2006
Hi....
I have created an Access Form wherein i have given lots of text box and text areas...
Now i want to create a word document dynamically using the information that has been given by the user via the Access form...
I want to create a Table dynamically in the Word Document using the VB code behind an access form... Also through that code i want to manage the font of Word Document and most if its controls..
Can u plz help me in this or provide me with a document wherein i can get some info in regard to it i.e. to manage the Word using Code...
Thanking you,
with regards,
Kapil Sharma
View 1 Replies
View Related
Jan 26, 2015
I need to be able to embed an interactive word document in an access form. The need is to put in text that has underlines and strikethroughs to indicate name changes to policies.
The user creates a new proposed update by designating the policy number but I need a word file attached to this update that can show more punctuation than access can show.
Of course I want to make this as automated as possible so the user doesn't have to work in two different places to get this done.
View 3 Replies
View Related
Aug 5, 2013
I am having the strangest results with my automated mailmerge. Basically it does work, but not all the time. The basic idea is to allow the user to dynamically create a query that produces a result list which fills a temporary table. The use then selects a prebuilt merge template and merge is executed against the temp table. The merge template are of the .doc type, but sme have been converted to .docx; the .doc files tend to work most often, but all of the will eventually get a Table is locked message... However if I run in test mode with code breaks and manually step through the process it always works... here is the heart of the code ...
Err_Pos = 10
Code:
DoCmd.SetWarnings False
' if tmp tbl left over from last run kill it
DoCmd.RunSQL "Drop table Word_Merge_Tmp_TBL"
Err_Pos = 12
[Code].....
There are many error cases in the error catch routine. That I have managed to make Access stop hanging when word has a problem or the table is locked. But I can't get the table to be free consistantly and why does it always work when I manually step through the code.
View 4 Replies
View Related
Oct 30, 2013
I have created a form with 9 cascading combo boxes. There are 59 total results or scenarios (which are based upon the completion of the form and these 9 combo boxes). Currently, upon completion of the form and the 9 combo boxes, a text box displays the singular result/scenario.
Here's my question: Rather than utilizing a text box to display the result/scenario, is it possible to output a PDF or Word document? If so, is there a general VBA code for this that I could manipulate?
View 1 Replies
View Related
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
Aug 2, 2013
I'm trying to add the information from a form and subforms to a report. This would be a medication mar sheet and needs to be in the format of the attached word document. I'm happy to do it in a report and change the formatting if that will work better. The personal info needs to go at the top and the medication needs to be listed on each sheet.
The form is called FrmMarSheet. It basically needs the info from that like the "sample mar sheet.doc". I can only get one medication per page to work at the moment.
View 1 Replies
View Related
Oct 28, 2014
I'm having some trouble opening a group of forms using a combobox. I think I'm really close, but I'm having some errors that prevent me from doing so.
I have a Combobox called "Letter Type" that contains the names of all of the other forms that exist. I want to be able to select a form from the combobox and click on the button "Compose." This should then open that form.
I had some trouble trying to get the Combobox value to work properly so I decided I would just create a hard workaround by using If/Then statements.
This is what I have in the On_Click event of my button.
Private Sub Compose_Click()
If Me.Letter_Type = "Refund Request" Then
strForm = "Refund_Request"
ElseIf Me.Letter_Type = "Request for Records" Then
strForm = "Request_for_Records"
End If
DoCmd.OpenForm strForm, , , Me.[Reference_#] = Forms![Reference_#]
End Sub
The catch is that I want the form to only open with one record and I want that record to be the same record the user was viewing on the previous form. I thought I would tie them together using the "Reference #" since it is unique.
When I click on Compose I get a "type mismatch" on the Reference #, though I'm not sure why.
View 5 Replies
View Related
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
Mar 22, 2013
I made a form pivot chart. When I open it by going to forms and opening, it opens in the pivot chart view. However, I created a button on a switchboard form for easy access to this pivot chart form and when it opens from the button it is in form view and not pivot chart view. How can I get it to open in pivot chart view from this button so that the users don't have to keep switching it to pivot chart view manually?
View 1 Replies
View Related
Jan 16, 2015
I am creating simple db for document control..
DB consist of 3 Tables:
tblCountry
tblState
tblCity
and a Form (frmCity) with cascading combo boxes that allows us to enter new City with existing data.
Combo's are displaying data fine but it don't allow selecting any item.
Shortly, this is what I have done so far:
1. Created cb's: cboContinet, cbo_State and cbo_City
2. Created query's:
a) qryState (added fileds are from tblState- State and Continent)
b) qryCity (fields are from tblCity- City and State)
3. Edit query's: qryState> added criteria for field Continent ([Forms]![FormName]![cboContinet])
I also added criteria in qryCity, field State ([Forms]![FormName]]![cboState])
4. Added VBA on After Update Event:
Private Sub cboDosje_AfterUpdate()
Me.cboGrupa.Requery
Me.cboPredmet.Requery
End Sub
[Code] .....
Macros are enabled in Trust Center and Combo boxes are refreshing fine, but somehow I can't select anything.
Also, I am working with Access 2007 if it matters, I've read something about allowing edits but didn't found how enable them.
View 4 Replies
View Related
Dec 19, 2006
I have documents (mostly Word) stored in an Access table. The table contains two fields. (1) a text field with the document's name and (2) an OLE field that holds the document.
When I press a button with the document's name on it (or it could be a hyperlink or a dropdown) on a form then I would like the document stored in the matching OLE field to open in the appropriate program for that document.
If I could set the permissions of the document to read-only then that would be great too. If I could prompt for read-only or read-write (no password necessary) access upon opening then that would be even better.
I can store documents in the table, but I have no idea how to launch them from a form button (or hyperlink, or dropdown).
Note: This is all within Access. This is not a web page related question.
Thanks in advance,
Andrew
View 3 Replies
View Related
Sep 7, 2005
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.
Any ideas?
Dave Eyley
View 4 Replies
View Related
Sep 2, 2014
i have some command button and some combo box on my form and also a subform. the subform contains some field. the fields used to enter numeric values.
i need to disable my command button on the form based on the subform fields if they r null.
View 1 Replies
View Related
Apr 3, 2014
Access 2010. I have a form pulling from a query to create a "To Do' list of sorts. On this form is a button to open an input form for the corresponding record (I hope). When this button is used I want it to pull certain data for that specific line from the query and input it into the new record opened by the button. I know this is possible as I use another db that does this but I have not been able to figure out how to make it work in the new db.
View 14 Replies
View Related