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 Replies


ADVERTISEMENT

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

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

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

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 :: 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 2 Replies View Related

Populate A Word Document With A Button?

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

Opening Up A Word Document From A Button

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

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

Modules & VBA :: Import Excel Document Via Command Button

Mar 4, 2014

I have managed to export the data that I want into a spreadsheet using a command button.

Once my colleagues have completed the spreadsheet, I need a command button on a form with a file search dialogue box which will allow them to transfer the spreadsheet back into the database - updating the relevant records rather that over writing them.

Is there a VB code/Macro I can use which will allow me to do this?

View 2 Replies View Related

Forms :: Open A Specific PDF File Per Record With A Command Button

Apr 18, 2013

I need to open a specific pdf file per record by using a command button. The pdf files will all reside in a specific folder in a partition on my hard drive. Each pdf file will have a unique four digit file name e.g 1234.pdf.The file name will match a unique number allocated to each record. This number is generated by adding 1000 to the record ID.Record 10 will therefore have an associated pdf file name of 1010.pdf.I have created a text box field , named 'TestReportID', to capture the unique four digit number per record that I assume is needed to be referred to when setting up the code to find and display the correct related pdf file.

I have set up a command button on the records form and as simple test using the hyperlink address to the folder where the pdf files reside, I can open a pdf file by clicking on the command button but it does not matter what record is open when I click the command button, it will always open the same pdf file.If I don't identify a specific file name in the hyperlink address, when I click on the button it will display a file open dialog which lists all the relevant pdf files and I can then select and open the required file.I would like to cut out that step and get the correct file to open when I click the button.

View 2 Replies View Related

Forms :: Command Button To Open Datasheet Of Contact Names

Dec 5, 2013

I am trying to add a command button to my main menu to open the contact names as a datasheet, I have changed the properties on the contact names form to datasheet as well as changing the properties on the button to the below:

Private Sub Command48_Click()
DoCmd.OpenForm "Contact Names", acFormDS
End Sub

at first after I saved it, the button did nothing. Now after a bit of playing around (probably not a good idea) I have a new message that states:"The expression On Click you entered as the event property setting produced the following error: Ambiguous name detected: Contacts_Click.To add some additional information, in the vba sheet above the code i wrote above it says:

Option Compare Database
Private Sub Contacts_Click()
DoCmd.OpenForm "Contact Names", acFormDS
End Sub

Private Sub Contacts_Click()
DoCmd.OpenForm "Contact Names", acFormDS
End Sub

should I delete this?

View 5 Replies View Related

Modules & VBA :: Word Document Load When User Click Button And Perform Email Merge

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

Forms :: Unable To Create Command Button To Open Folder On Desktop

Feb 19, 2015

I am simply trying to create a command button to open a folder on my desktop

Cannot seem to find this code

This is the path to the folder I want to open

C:UsersJONATHANDesktopCMS FILES

View 4 Replies View Related

Opening A Word Document Within Access

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

Calling A Word Document From Access

Aug 26, 2004

When I click a button, I am creating a table for a mailmerge and then calling the document that merge is in so I can write letters.

Everything works properly except the line for calling a document. I've messed with it in several ways but right now it tells me I need an equal sign. Can someone who actually knows VB (I'm just pretending! ) look at this and tell me what might be wrong?

Shell("C:Program FilesMicrosoft OfficeOffice10WINWORD.EXE", "\documentsOfficesJudicial & Court ServicesJudicial CollegeShared Project FoldersTemplatesLetters & AccessoriesConf Letter Mail Merge.doc")

Thanks!

View 14 Replies View Related

Merging Word Document With Access Query

Feb 7, 2006

Apologies ... but I am quite new to Access. My database contains about 1000 peoples' addresses.

The problem I have is that I need to merge, say, 20 of these addresses into a word document. In the word document I can select records using the "Surname" field but it will not give me the option to select more than 6.
I am sure there must be a way that I can select more than 6: I have tried separating the surnames with a "," or "or" but nothing seems to work!

Help, please!

Thank you,

Emma

View 3 Replies View Related

Creation Of A Word Document From The Access Form

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

Export Access Report To Word Document

Jan 11, 2014

I want to insert access report in a word document, for this, I use this code:

DoCmd.OutputTo acReport, "rptName", acFormatRTF, "C:ReportFileName.rtf"

But, when that output word file is empty, don't have any chart that was in access report.

View 6 Replies View Related

Dynamic Creation Of A Word Document Using Access Form

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

Opening Word Document With Info From Access Form

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

General :: Link Access Query To Word Document

Sep 26, 2012

Is it possible to link a field in Access to a footer in Word?

I have a field in Access that would look like the following;

G10E-PRO-001RevA

Additional data in access would have the document name, and revision, matching 2 lines of text in Word. I would like the footer in the document to be the above sample, which I assume could be a query that need to run to match the 2 fields of information.... not really sure if this is even possible?

View 2 Replies View Related

Embed Interactive Word Document In Access Form

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

Modules & VBA :: Word Doc With Command Button - Edit Mode

Oct 2, 2014

I have a Word Doc with a Command Button.

The Command Button loads a form.

How do I find the form in "Edit Mode"

Alt-F11 opens the VBA editor but I don't seem to be able to locate the form there.

View 1 Replies View Related

Modules & VBA :: Automating Mailmerge From Access Form To Word Document

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







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