database

[gmahendru]

Dear ALL,

My name is Gautam and i m new here... i have a specific query regardin
my project.

I want to make a template in word where my product (ie engine) i
selected from the drop down menus and all information pertaining t
that is filled in the lines below.

EG. If i selected engine "A" then its parameters ie bore, stroke
piston speed etc.. should be filled automatically in the templat
below...

I have done this successfully in EXCEL by data validation and VLOOKU
but dont know for WORD.

Please help

Thanks in advance

Gauta

 

[Jezebel]

What sort of help do you want? In essence, the method is to open the
database (ie using DAO or ADO), run SQL statements to retrieve data, then
make the data available to your VBA app. That answer is obviously too
general to be helpful, but without more details, there's nothing much more
to offer.

 

[gmahendru]

Thanks JEZEBEL for the reply.

Actually i know very little programming. With beginners leve
understanding can u suggest some procedure to make my project.

I made the same thing in EXCEL and is working fine but i want in WOR
because then i can make a standard template of my project.

In WORD I used mail merge option but i dont want user to keep o
clicking the records.... Instead it should be drop down sort of thin
where once engine model is selected all parameters pertaining to tha
should fill-in automatically.


I hope i made u understand my case

Thanks in advance

Gauta

 

[Jezebel]

So what do you want from the forum? Someone to write your code for you?

 

[gmahendru]

I dont want that... But yes if some one can tell me the way then i ca
try myself

OR

refer me some help files then i can read and try


Thank

 

[Anne Troy]

Hi. Perhaps you could use something like this instead? It would take named
ranges from your Excel file, which is already developed, and drop them into
your Word file:
http://vbaexpress.com/kb/getarticle.php?kb_id=381
It's perfect for people who keep individual files for each quote or order.
************
Anne Troy
www.OfficeArticles.com

 

[gmahendru]

Thanks Anne.


Regards

Gautam Mahendr