I am newbie..pls help me for word VBA & database

[Jennifer]

Dear All Experts,

I am a newbie in VBA Words...I really need your helps and learn from you
all...

I am trying to create an Invoice, using Word Document template integrated
with Ms Access database...the shymptoms like these:

When I open the Invoice template (word document template), there will be a
pop up form appear contains of "Item Code" (drop down menu), "Description"
(TextBox), "Qty" (TextBox), "Unit Price" (TextBox) and "Total (TextBox)"...

When users select the item code from the drop down menu, it will write on
each TextBoxes for "Description" and "Unit Price"...When users put the "Qty"
in...then when they do "Tab" it will automatically calculate its "Total"...

After all finish then users click on "Next" button...and all information on
the TextBoxes and its drop down menu will write on its bookmark on the
template...and also it will erase all text in the form and it will create new
row on word document ready for next information...and so on...

Anyone can help me for this please...???

Thank you for your kind helps...

Jennifer

 

[Doug Robbins - Word MVP]

I would suggest that you use a report in Access, rather than a Word
document.

However, for some information on forms in Word, see:

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

 

[Jennifer]

Hi,

Thanks very much for your reply and helps...

I am reading that now...I will ask you more if I have further questions...

Additionally, how much for vba word consultation? would you please provide
me further information?

Thank you for your kind helps.

Jennifer

 

[Doug Robbins - Word MVP]

Hi Jennifer,

Send me an email (remove the REMOVETHIS from my address) letting me know
what it is that you would want me to do and I will give you a price.

--
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