Need to print an Access Report via Visual Basic application
I am in need of some help. My problem...I have a Visual Basic application connected to a SQL server database. I have to print a report that was built using Microsoft Access. The Access report has text fields bound to the SQL server Database.
When I print the report through Access everything prints however, when I print the report via my Visual Basic the text fields that were bound to the SQL database do not print. I have tried EVERYTHING I can think of and NOTHING has worked any suggestions would be GREATLY appreciated!!!
Dawn Bradley
Re: Need to print an Access Report via Visual Basic application
read the data from oracle into a recordset in vb, then create a access-instance and in this instance create or /import a report.
Fill the report with the datas.
Or: Requery/fill the textboxes in the PageHeader_Format- Event in the Access-Report. (!!!)
KIK