Go Premium for a chance to win a PS4. Enter to Win

x
?

Populating a Word document with VBA, getting data from Access via ADO and SQL

Posted on 2017-11-14
6
Medium Priority
?
36 Views
Last Modified: 2017-11-24
I had this question after viewing Populating a Microsoft Word Document from Microsoft Access VBA.

Hi. I have a similar challenge as in that thread. May I also take a look at the example that you have please?
0
Comment
Question by:hindersaliva
  • 4
4 Comments
 
LVL 40

Expert Comment

by:PatHartman
ID: 42368128
I sent it to your email.  Good luck.
0
 
LVL 40

Expert Comment

by:PatHartman
ID: 42369895
Rob, in the message hindersaliva referenced, I offered a sample database.  I couldn't upload it because it was too large even compacted and zipped so I offered to email it to people if they wanted it.
0
 
LVL 40

Expert Comment

by:PatHartman
I would have uploaded the database to the site but your size limit prevented it.   I removed some of the data and moved the sample docs out of the archive file.
SampleWordAutomation160714mdbNoDocs.zip
SampleLetter1.doc
SampleLetter1.docx
0
 
LVL 40

Expert Comment

by:PatHartman
Forgot to press the object button
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Join & Write a Comment

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
This Micro Tutorial well show you how to find and replace special characters in Microsoft Word. This is similar to carriage returns to convert columns of values from Microsoft Excel into comma separated lists.
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question