Hy everyone.

I have to develop a simple appl that allows the user to pick some data on a

single form, and builds an offer with a standard heading and footer.The data

on the form are to be chosen in different combo boxes. There are no

relationships between the three tables used to build the rowsource for the

combos.The data the user selects are used on the same form to show the

result of different calc.. ehm operations, since the final prices depend on

different parameters which are to be inserted in some text boxes on the

form.(Apologize for being too long, just trying to be ACAP ).I'm thinking to

use VBA to add the values selected on the form to a temp table, until the

user decides to print out the offer. I'm afraid of Word's Object world, and

have "quite" chosen to print an Access rpt, created each time on the temp

tbl.

Wondering.....i'm in the right direction?



my compliments for the newsgroup ...always so interesting

thanks in advance

Vladimiro,



Using Word's object to create letters can be intimidating, but is good

to know.  There are two programs at Microsoft's knowledgebase website

that you can download and install that provide excellent examples.



Go to http://search.support.microsoft.com/kb/c.asp?fr=0&SD=GN&LN=EN-US

and enter Article ID Number Q167223 if you want only the program for

Access97.  It's called Auto97.exe.  For all Office versions from 97 thru

XP, enter Article ID Number Q253338.



Now to answer your question.  The process that you have decided to use

to generate the offer for your customers is fine and should work well.  





John Ruff - The Eternal Optimist :-)







-----Original Message-----

From: Vladimiro Cerni [mailto:vladimiro.cerni@t...] 

Sent: Tuesday, November 20, 2001 3:31 AM

To: Access

Subject: [access] Office automation:access rpt vs Word





Hy everyone.

I have to develop a simple appl that allows the user to pick some data

on a single form, and builds an offer with a standard heading and

footer.The data on the form are to be chosen in different combo boxes.

There are no relationships between the three tables used to build the

rowsource for the combos.The data the user selects are used on the same

form to show the result of different calc.. ehm operations, since the

final prices depend on different parameters which are to be inserted in

some text boxes on the form.(Apologize for being too long, just trying

to be ACAP ).I'm thinking to use VBA to add the values selected on the

form to a temp table, until the user decides to print out the offer. I'm

afraid of Word's Object world, and have "quite" chosen to print an

Access rpt, created each time on the temp tbl. Wondering.....i'm in the

right direction?



my compliments for the newsgroup ...always so interesting thanks in

advance





---

You are currently subscribed to access as: papparuff@c... To

unsubscribe send a blank email to $subst('Email.Unsub')