Re: [MS_AccessPros] Automation Access 2013/Word 2013-Error has occurred: The database has been placed in a state by user 'Admin'.....locked

 

Norbert

You can avoid a separate database if you choose to export the merge data to a csv file and then merge the csv with your word template.

Here is a dropbox link to a sample file with the code that accomplishes this. The zip contains a access db and a word template file. Please unzip both in the same directory.

The code for exporting to csv and then merging it is beneath the button "Merge" on the opening form.

The form is crude but the code should give you an idea of how to do this.

  https://www.dropbox.com/s/p2o75iw60rd4vsf/trial.zip?dl=0  

regards

Rajiv

On Tue, Jan 6, 2015 at 12:10 AM, drnorbert@msn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

 

Rajiv,

Thanks makes sense, I was trying to avoid a separate database.

About linking the word document with SQL 2012 table?

Norbert

__._,_.___

---

Posted by: Rajiv <torajiv@gmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (6)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___