i have a simple program that generates information using MS Access as database. my problem is how to get code in order to preview information from my db. I know how to retrieve from db but i don't know how to plot this into print preview or what components and what code should i do.
The best and most used way is to show your data on a datagrid and then print the grid Only. Attached is a sample that should work. Just change the MS Access database to your own, change the connection code etc. Hope this helps.
This is an add-on for vb6. I still think by using the attachment I've send you will help out easier without fuss.
You can also start experimenting with MS Data Report Designer, which is similar to crystal reports and forms part of your vb6 environment. Select 'Project' from your toolbar, select 'References' and scroll down to 'Microsoft Data Report Designer 6.0(your service pack level)'
For Each ctrl As Control In Me.Controls("pnlMainPanel").Controls
If ctrl.GetType Is GetType(System.Windows.Forms.Panel) Then
For Each subCtrl As Control In ctrl.Controls
If subCtrl.GetType Is GetType(System.Windows.Forms.TextBox) Then
If subCtrl.GetType Is ...