Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / October 2005

Tip: Looking for answers? Try searching our database.

database

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
gmahendru - 26 Oct 2005 07:32 GMT
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
Jezebel - 26 Oct 2005 11:24 GMT
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.

> Dear ALL,
>
[quoted text clipped - 17 lines]
>
> Gautam
gmahendru - 27 Oct 2005 04:42 GMT
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
Jezebel - 27 Oct 2005 10:24 GMT
So what do you want from the forum? Someone to write your code for you?

> Thanks JEZEBEL for the reply.
>
[quoted text clipped - 14 lines]
>
> Gautam
gmahendru - 27 Oct 2005 13:05 GMT
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
Anne Troy - 27 Oct 2005 16:32 GMT
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

> I dont want that... But yes if some one can tell me the way then i can
> try myself
[quoted text clipped - 4 lines]
>
> Thanks
gmahendru - 28 Oct 2005 04:37 GMT
Thanks Anne.

Regards

Gautam Mahendr

--
gmahendr
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.