Perhaps I am pushing my luck to far but some time ago I did ask this question and did not found a solution. Since you have been great until now, I am submittin a sample zip file of my db so that you can better understand what is my project.
Data from my access forms are normally exported to word templates. Once I click on a cmdbutton, the data is exported using bookmarks and opens the word file. Users then can choose if to save it and where to save it.
I would like to avoid this step. I would like to place a second cmd button which directly exports data the word file and saves it into a specific folder (let's say it could be C:\myforms\myname
Can anyone help with this? I believe the procedure will need some input box so that users can assign the name to the file (as they are templates) before saving it. Thanks.