Merging Access Data Into Word 2003
Aug 29, 2007
Hi,
how do i get the current record form access 2003 to merge the data into word 2003 template that I created.
The code I'm using is :-
Private Sub Command313_Click()
Dim oApp As Object
Dim doc As Object
Dim strDocName As String
Set oApp = CreateObject("Word.Application")
oApp.Visible = True
strDocName = "K:Supported Living ServicesdatabaseDB-Personnel.dot"
Set doc = oApp.Documents.Open(strDocName)
doc.FormFields("Title").Result = Forms!Personal!Title
doc.FormFields("fristname").Result = Forms!Personal!firstname
Set doc = oApp.Documents.Add(strDocName)
End Sub
I'm using 2 fields here but will be adding a lot more once I got it working.
Thanks inadvance
ps (only a novice at access)
View Replies
ADVERTISEMENT
Mar 8, 2006
I have an Access spreadsheet that I can't get to merge with a word document. It freezes up every time I try and the only message I get is overflow. Does anyone know how to fix this problem?
View 3 Replies
View Related
May 26, 2006
I am building a database for my job. I am trying to find a way that I can mail merge an Image that store in Access to a Word document. I tried doing it by creating a field in Access for the picture and its field type was set to OLE Object and I placed the merge field in its appropriate area in Word. When I go to merge it, its comes up with a message that says "Long Integer or Binary Number". If anyone has an idea as to how I can make this happen....please let me know, your help would be greatly appreciated.
Thank you
View 1 Replies
View Related
Jun 20, 2007
Hello All,
I need some assistance.
First a little background on the database:
The back end is in AQL the front end is in Access.
The main form is called the "Register", here they enter claim information and if they need to create a printed loss they click on a button called "Loss Notice" This brings up another form which is filtered based on the claim number in the Register. Here they fill in additional information. On this form they have the option to print the Loss Notices by clicking on a button that Opens up Microsoft Word and all the fields are mapped to the Word Template where they need to be.
On my computer when I set this up it works great. I test it all the time and works perfectly.
However when the users try to do this from their computer they are getting a pop up box asking for the claim number. The Loss form is filtered and should only pull that claim number.
Why are they getting this pop up box and I am not?
If you need any additional information I will try and give that to you.
Thanks for trying to help!
View 2 Replies
View Related
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
Aug 22, 2006
I am wanting to do away with access 97 on a few computers here at work but we cant afford to buy everyone office 2003. Before I buy us access 2003 for a computer I need to know if word 97 will do a mail merge with access 2003. Or could I just buy Office 2003 package for the few computers and it will work that way for a bit more money. I think there would be a compatability issue...
View 3 Replies
View Related
Dec 13, 2006
Hi
I have written an application which uses a query for the current record and then opens a Word document, merges this record and shows the merged document for the user.
all works fine using Office 2003 - when i try it on a pc with Office 2002 - it diesn't work. Something is happening - WINWORD.EXE is running on the process list. But the document doesn't open. I have added the Microsoft Office 10 Office Library to the references but still no joy.
It's a killer - all testing was done on Office 2003 and now a key user wants to use the app - on 2002 and it doesn't work
Any ideas?
cheers
View 1 Replies
View Related
Sep 4, 2007
Folks I need your help; just wanted to get your opinions here.
I work in a small engineering group and we have lots of reference documents in word and excel which we typically use for any projects. Currently, all these files are stored in Lotus Notes database. Unfortunately, they are pulling the plug on Notes license starting this fall. Therefore, I have been asked to see if there is a way we can store these files in Access as a repository and query the database whenever we need some information.
In order to avoid the database size getting too big, my thought was to store the .xls/.doc files as an “OLE object” data type, keep the files in local hard drive and create a link in a form to give the user to retrieve the information.
Do any of you have any suggestion on what is the best way to handle this?
Your input is highly appreciated.
Shan.
View 10 Replies
View Related
Jul 18, 2005
Is it possible to populate a word document with the click of a button with records from an access form? If so could you give me some type of example?
View 5 Replies
View Related
Jan 31, 2006
Does anyone know why when i link Microsoft Access with a Microsoft Word document, the merged fields in Word automatically underline?
Is there anyway I can stop the automatic underlining?
View 1 Replies
View Related
Sep 6, 2004
I have created a database of information which contains fields with Yes/No tick boxes. No problems there. When mail merging into Word the ticks are not formatted correctly. All I get instead are random symbols. All the other data merges successfully.
Can anyone help as I need to see ticks in the merged document?
Here's hoping
Gaz T
View 7 Replies
View Related
May 21, 2013
I'm strugling with transferring data from access to word template.
1. transferring single data fields works okay, with bookmarks etc.
2. transferring multiple records (e.g. orderlines) to a WORD template fails. The # of multiple records are variable. So could not be defined upfront how may records i have to transfer.
I tried to transfer the data in a word table both with bookmarks and with merge fields. The result was that all data was placed in de first cell of the table in WORD.Setting up de WORD template combining with the VBA code.
See VBA code:
Private Sub Knop17_Click()
On Error GoTo Err_knop17_Click
Dim sreportname As String
Dim scurrentdir As String
Dim stemplatedir As String
Dim stemplatename As String
Dim ObjWord As Word.Application
Dim ObjDoc As Word.Document
Dim bm As Object
[code]....
View 3 Replies
View Related
Sep 6, 2011
Is there a way to transmit data from an MSWord Form to an Access table?
View 6 Replies
View Related
Oct 11, 2005
I have produced a A2k db for distribution to others. Part of the db is a function that links to some word docs via hyperlinks. The word docs have been set up as mail merge docs to a table in the db.
When used in Office 2000 this function is faultless but when installed on a computer running Office 2003 they sometimes get a problem when they open the doc in that the mail merge toolbar is greyed out. It seems as if the doc can't find the db. Has anyone else experienced this problem and know of any fix that can be applied.
I have searched the MS Knowledge base and this forum to no avail, although the MS KB did have references to similar problems (not a direct comparison of the problem) that required a service pack download to fix.
Before I tell someone to download a service pack I need to eliminate any other problem that may be causing it.
Thanks :confused:
View 2 Replies
View Related
Jan 15, 2007
When I try to import from a spreadsheet, Access crashes. No errors, no error log entry. At first I thought it was because my file was password protected, so I tried a new file with no password, but it still crashes Access.:confused:
View 2 Replies
View Related
Dec 12, 2005
I was just converted from 97 to 2003 this weekend. I have a query set up that links a field to a form to get the date entered in the form into the query. For example if I enter 12/31/04 on the form and run my query it is put in the field 12/31/04. But in 2003 it is just blank. The formula I used in 97 is
StartDate: [Forms]![Cash Flow]![Start Date]
Is there something new I should be using to get that to pull in?
View 1 Replies
View Related
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
Sep 27, 2012
I have a table in MS Access 2010 with a Date field and 3 Memo fields. I wish to append data to the Access table from a MS Word doc that has a date field and 3 memo fields. My wish is to have a command button on the MS Word doc which appends the data to my Access Table.I am aware that a web page can append data to an Access table.
View 2 Replies
View Related
Mar 9, 2014
I often create contract using mail merge. I have an access file that I want to use as data source for word file. But it does not automatically.
Please see the attached file !
If there are 1 customer and 1 property, I do not need to do anything. Conversely, if there are many customers and many properties, I take time to manipulate.
Firstly, I open the word file. I have to copy and paste paragraphs that I want. Highlight of the original paragraphs is blue.
Secondly, I click 'Insert Word Field' -> select 'Next Record'.
In short, I want to use VBA in access file to automatically perform the steps that I have outlined.
View 1 Replies
View Related
Sep 14, 2005
Hi,
My database consists of some personal data and a photo of each person.
I am trying to include these photos when I browse the database via ADP.
I have found instructions how to do so at Microsoft website (article ID: 285820)
Link for it: http://support.microsoft.com/?kbid=285820
The problem is I cannot make it !!!!!!!!
Where exactly should I paste the VBscript in the page code to execute displaying of the photos???????
I am happy to send you the head portion of my page code if anybody knows where to paste it.....
Please help,
Jimmy
View 1 Replies
View Related
Nov 26, 2012
A textbox on a form is displaying the numeric ID value that is linked to the ID in another table (which has another field which holds the text value that I want). How do I show the actual text value that the ID relates to?
View 3 Replies
View Related
Feb 5, 2014
when i import data from excel into access 2003.i give nothing means not import data and no error seen like process finished but nothing happend.
View 2 Replies
View Related
Dec 2, 2014
For a text box in a Report, I am trying to use the "SumOf([UnboundTextBox])" as the Control Source in the Report Footer to add the unbound text box in the Details section. I know it works with a bound text box, but does it not work with an unbound text box?
View 10 Replies
View Related
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
Dec 7, 2007
Hi All,
I have an MS Access table that currently links into word as a mail merge. Great!
Sample data as follows:
Tutor Student
Mr A Donald Duck
Mr A Mickey Mouse
Mr A Minnie Mouse
Mrs B Joe Bloggs
I want to produce a mail document that allows me to address each tutor separately, along with the respective student names in a grid.
Now I've setup the document, but when I view each document it produces the list of all students for each tutor.
e.g.
Dear Mr A
Your students are:
Donald Duck
Mickey Mouse
Minnie Mouse
-------------------
Dear Mrs B
Your Students are:
Joe Bloggs
Is this at all possible?
Thanks:)
View 1 Replies
View Related
May 19, 2014
I have a table with 715K records. Each record is an inventory product, and the sixth field of each record is a short description. The tenth field is a single-letter category designation, and is currently blank. What I want to do is search through the description field of every line, and where the word "Paint" is contained, enter a letter "P" in the category field.
View 2 Replies
View Related