database

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

--
gmahendr
-----------------------------------------------------------------------
gmahendru's Profile: http://www.highdots.com/forums/m108
View this thread: http://www.highdots.com/forums/t305111

Jezebel
Wed Oct 26 05:24:00 CDT 2005

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" <gmahendru.1xi1y0@no-mx.forums.yourdomain.com.au> wrote in
message news:gmahendru.1xi1y0@no-mx.forums.yourdomain.com.au...
>
> Dear ALL,
>
> My name is Gautam and i m new here... i have a specific query regarding
> my project.
>
> I want to make a template in word where my product (ie engine) is
> selected from the drop down menus and all information pertaining to
> 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 template
> below...
>
> I have done this successfully in EXCEL by data validation and VLOOKUP
> but dont know for WORD.
>
> Please help
>
> Thanks in advance
>
> Gautam
>
>
> --
> gmahendru
> ------------------------------------------------------------------------
> gmahendru's Profile: http://www.highdots.com/forums/m1086
> View this thread: http://www.highdots.com/forums/t3051117
>

gmahendru
Wed Oct 26 23:03:57 CDT 2005


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

--
gmahendr
-----------------------------------------------------------------------
gmahendru's Profile: http://www.highdots.com/forums/m108
View this thread: http://www.highdots.com/forums/t305111

Jezebel
Thu Oct 27 04:24:02 CDT 2005

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


"gmahendru" <gmahendru.1xjlhz@no-mx.forums.yourdomain.com.au> wrote in
message news:gmahendru.1xjlhz@no-mx.forums.yourdomain.com.au...
>
> Thanks JEZEBEL for the reply.
>
> Actually i know very little programming. With beginners level
> 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 WORD
> 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 on
> clicking the records.... Instead it should be drop down sort of thing
> where once engine model is selected all parameters pertaining to that
> should fill-in automatically.
>
>
> I hope i made u understand my case
>
> Thanks in advance
>
> Gautam
>
>
> --
> gmahendru
> ------------------------------------------------------------------------
> gmahendru's Profile: http://www.highdots.com/forums/m1086
> View this thread: http://www.highdots.com/forums/t3051117
>

gmahendru
Thu Oct 27 09:04:00 CDT 2005


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

--
gmahendr
-----------------------------------------------------------------------
gmahendru's Profile: http://www.highdots.com/forums/m108
View this thread: http://www.highdots.com/forums/t305111

Anne
Thu Oct 27 10:32:02 CDT 2005

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" <gmahendru.1xkd9z@no-mx.forums.yourdomain.com.au> wrote in
message news:gmahendru.1xkd9z@no-mx.forums.yourdomain.com.au...
>
> I dont want that... But yes if some one can tell me the way then i can
> try myself
>
> OR
>
> refer me some help files then i can read and try
>
>
> Thanks
>
>
> --
> gmahendru
> ------------------------------------------------------------------------
> gmahendru's Profile: http://www.highdots.com/forums/m1086
> View this thread: http://www.highdots.com/forums/t3051117
>

gmahendru
Thu Oct 27 23:04:50 CDT 2005


Thanks Anne.


Regards

Gautam Mahendr

--
gmahendr
-----------------------------------------------------------------------
gmahendru's Profile: http://www.highdots.com/forums/m108
View this thread: http://www.highdots.com/forums/t305111