Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Form Macros, Form Output to DB
Word 2003, OS XP.
I'm hoping someone can steer me in the right direction on these questions. 1. I would like to make a macro in a Word form that will do something like the following: If a user selects California from a drop-down menu, the following zip code drop-down menu will populate with California zip codes. I know about the "Run Macro Before/After" features, but can a macro that does this be recorded through the Word interface or must I write the macro myself in VB (which I'm not very good at). 2. Word can output form results into a text file (i.e., "last name", "first name", "DOB", etc.) which, according to the documentation, can be "easily inserted into a DB." But how is this done efficiently? Copy/paste from the text file? Please advise anyone with thanx! Erik |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Form Macros, Form Output to DB
In answer to your first question, the macro recorder cannot do that.
See the Cascading Listboxes section of the following page on fellow MVP Greg Maxey's website: http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm For the second question, see the last of the following series of articles: http://www.mousetrax.com/techpage.html#autoforms Please Fill Out This Form Part 1: Create professional looking forms in Word http://www.computorcompanion.com/LPMArticle.asp?ID=22 Part 2: Adding Automation to your Word forms. http://www.computorcompanion.com/LPMArticle.asp?ID=46 Part 3: Learn more VBA (macros) to automate your forms. http://www.computorcompanion.com/LPMArticle.asp?ID=119 Part 4: Use custom dialog boxes in your Word forms http://www.computorcompanion.com/LPMArticle.asp?ID=127 Part 5: Connect your AutoForm to a database to save input time and keep better records! http://www.computorcompanion.com/LPMArticle.asp?ID=136 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "erik_gregory" wrote in message ... Word 2003, OS XP. I'm hoping someone can steer me in the right direction on these questions. 1. I would like to make a macro in a Word form that will do something like the following: If a user selects California from a drop-down menu, the following zip code drop-down menu will populate with California zip codes. I know about the "Run Macro Before/After" features, but can a macro that does this be recorded through the Word interface or must I write the macro myself in VB (which I'm not very good at). 2. Word can output form results into a text file (i.e., "last name", "first name", "DOB", etc.) which, according to the documentation, can be "easily inserted into a DB." But how is this done efficiently? Copy/paste from the text file? Please advise anyone with thanx! Erik |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Form loses macros when downloaded | Microsoft Word Help | |||
Distributing a form with no macros | Microsoft Word Help | |||
Automate a form by saving macros in the form template...? | Microsoft Word Help | |||
Form Field Macros | Microsoft Word Help | |||
Macros in a protected form | Microsoft Word Help |