launch a word template

  • Thread starter Thread starter ron
  • Start date Start date
R

ron

I've got a little access database that I have built and
would like to make it do something. I have a field that
has a list of drop down choices. I'd like to set the "on
update" characteristic of this field to test whether the
entry is "3. address"; if so, launch a MS Word template
file that the user can fill out and then e-mail to one of
our staff; if the dropdown choice is anything else, it
would merely continue to the next field of the form. Can
Access do this file launch routine?
 
yes, it can. I would probably place some button on the form to launch the
word template.

I just think that selecting a combo box and WHAM...a word doc loads is rude
to the end users, and is a rotten user interface. A new user would NEVER be
able to figure out how that feature exists, unless being told so. Place a
nice button with some bubble help that explains what is/will happen when you
press the button.

Anyway, if you must torture your uses, you can use the after update event of
the combo box.

if me.myCombo = "3. Address" then
' word merge code goes here
MergeSingleWord
endif


The above is only an example. However, my sample word merge code will
actually create a template by adding the above "one line" of code:

MergeSingleWord.

You can give the word sample code I have a try also. Check out:

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html
 
When you create any field, or button, if you hold your cursor over the
field, then the text you specify for the text box, button for whatever will
display.

So, when you use Word, Excel, ms-access etc and hold your cursor over a
control/button, you will see some "text" displayed. This is commonly
referred to bubble help.

You can specify this text to display for any control/text box you place on a
form. You find this setting in the "other" tab for any contorl on the screen
(it is called ControlTip Text).

You can even stuff multi-line text into that property.
 
Back
Top