Question ACCESS reports and printing with VB

[warbreed]

I have created a VB frontend to deal with my Access database. It sends and recieves info like it is suppose to ... however.. I have a Report that i need to be able to print througha button on my VB.net app. My question ...What is the process or code I would use for this and how do I get the stored procedure that puts the info I need on that report before print previewing and then actually printing?

Any help would be great.. I am dieing trying to get this done and would be forever greatful!!!!!!

Thanks
Warbreed

 

[acidflash]

I asked a similiar question but no replies yet, One way of doing it (i figure out later on) is to make a datagrid, make it invisible, load the data onto the datagrid, select the columns you want to print, then go about printing them. What you need to keep in mind is you must make the datagrid viewable when you go to print it, so you can do a

yourdatagrid.visible = true
printform()
yourdatagrid.visible = false

and then life goes on as normal. Thats one way, if anyone informs me of a method to directly print from the access database, ill let you know my friend.

acidflash.