Hi Guys,
I have more than 13 years of experience in VBA and also using Ms Access Databases as backends. Recently decided to utilize the VSTO Word Document features to create rich reports (Ms Access Reporting Tools are very limited when comes to formatting). What's the Challenge then?

With Ms Access everything is simple:
Just declare a recordset.
Load it
and Use it.

But so far in my exploration with VB.Net:
There are 4 things are being created and involved:
Dataset
TableAdapter
TableAdpater Manager
and Binding Source.

My Exact Current requirements:
There should be a Macro-Enabled VSTO word document (*.docm)
which on opening has to print the last record of a Bill (Query Name is Bills)

Other features:
Feature No.1:
I have a sales form inside an Ms Access Database. Upon the clicking on a button the VSTO word Document has to open and print the last bill and quit.
Feature No.2:
The above feature has to be done invisibly but if I open the word Document, it has to have action pane having a Navigator in it settling on the last bill number by default but I want the navigator control to also have the general navigation features like: "|<< < > >>| >*" with a print Button to print the navigated bill using that control.

I know its a bit long post but I wanted to explain in details as much as I can. Thanks. Please reply and Provide Support.

With Hope,
Prabhakaran

 

Initially I was trying the mail merge feature only. But the problem is you cannot suppress the query dialog box before the document gets merged.

Why VSTO?
Evolution!

Let me explain, How VSTO makes things easier here. No:1 Lot of code saving thus less code and faster result.

Next, I want to understand the Database concepts (especially read-only Binding) in VB.Net i.e. from Fetching the data from a table to display it on a control. I want to understand both the sides Design time and Runtime to achieve the same result. I strongly believe that atleast single person must have mastered it here. Either this post has to reach him/her or the Person has to read this post. I have strong hope. Lets wait and see...