Help me please to retrieve data to VB form..???

Dear Experts,

I am trying to make a VBA program (dont worry about the VBA since the concept is the same) from a "word document" that can collect information/data from Ms Access database...my question is:

There are : Item Code , Descriptions, Qty, Unit Price and Total (all as TextBoxs except Item Code as a drop down menu)...what I am trying to do is, when I select Item Code from the drop down menu, it will collect all information (Description, Qty, Unit Price) and write into each TextBoxs and also it will calculate automatically for Total and write the total into the TextBox...

Anyone could help me please..please..???

Herewith, I attached a sample/dummy as a ZIP file for your reviews...and for my self learning...dont worry about other codes (such as how to write into the word documents, how to pop up, etc)....what I am trying to do is just how to make those codes run well....

Thank you very much for your kind attention and helps.

Best Regards,

Jennifer :)

Ah, I see we have no starting code :)

I would recommend using ADO to connect to the database, to do this go to "Tools"->"References", and tick 'Microsoft ActiveX Data Objects'.

The next step is to write some code to connect & get data, a good example is in the 'ADO Tutorial' link in my signature. Have a go with that, and let us know if you get stuck.

Hi,

Would you please help writing a code on my (zip) file please..???... Because I already tried by following instructions on the ADO tutorial that you gave to me but it always failed to run since that codes have not been tested yet by the author....Additionally, I am really really new to learn about this...so, it is easier for to learn from the sample attached on the file I ZIPPED to you...

I need your helps please...

Thanks for your kind helps and assistance,

Jennifer ;)

Try this sample. It opens the Northwind DB and loads it into a ListView

http://vbforums.com/attachment.php?attachmentid=36094