Hello again all,
My database has an address book feature which our office uses for just about everything.
This probably goes a bit beyond your normal Access VB question, and it might get a bit lengthy, but allow me to describe what's going on.
I have a button on the Access address book form which allows a user to begin a letter to the selected contact using one of four different letterheads.
The way it works is this:
- User finds the address book entry they want
- They click a button on the form which copies the appropriate fields to the clipboard
- Next, a letterhead selection form is opened (by code) where they choose one of four options.
- depending on the selection, one of four macros is executed in which the command line includes switches to start a new document in Word based on a specified template, then start a Word macro which copies the information previously pasted to the clipboard into the document.
The process works great on my machine. The problem is that the macros on the Word side are all in the Normal.dot template. We would like to be able to put the macros into the letterhead templates because of problems which arise from time to time with Normal.dot. We don't want to have to go around to everyone's workstation and modify their Normal.dot either.
Can anyone share how I might change the way things work, either on the Access side or the Word side, to get this thing working more securley?
Many thanks in advance.
TechieJr
My database has an address book feature which our office uses for just about everything.
This probably goes a bit beyond your normal Access VB question, and it might get a bit lengthy, but allow me to describe what's going on.
I have a button on the Access address book form which allows a user to begin a letter to the selected contact using one of four different letterheads.
The way it works is this:
- User finds the address book entry they want
- They click a button on the form which copies the appropriate fields to the clipboard
- Next, a letterhead selection form is opened (by code) where they choose one of four options.
- depending on the selection, one of four macros is executed in which the command line includes switches to start a new document in Word based on a specified template, then start a Word macro which copies the information previously pasted to the clipboard into the document.
The process works great on my machine. The problem is that the macros on the Word side are all in the Normal.dot template. We would like to be able to put the macros into the letterhead templates because of problems which arise from time to time with Normal.dot. We don't want to have to go around to everyone's workstation and modify their Normal.dot either.
Can anyone share how I might change the way things work, either on the Access side or the Word side, to get this thing working more securley?
Many thanks in advance.
TechieJr
