Dear VBA experts,
I have created a word template that loads a userform with multiple input boxes that then gets transferred to bookmarks.
The template is used to quickly draw up a budget proposal for a wedding (for a wedding coordinator). The form has fields for event name, couple details etc, as well as a form for budget figures.
What I want to do is to link this information to a database instead of typing in the information every time. What I want to know is:
1. How do I make the template automatically invoke the database (Access 2003)?
2. Is it possible to link the document to an offsite database on a ftp server?
3. Can I update the database from the userforms in word, rather than forms in Access?
PS: If I need to use some other type of database such as a SQL database that would be fine.
Cheers!