Click to See Complete Forum and Search --> : Need to print an Access Report via Visual Basic application


dbradley
August 30th, 2001, 04:25 PM
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

KIK
September 3rd, 2001, 09:09 AM
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