matt_fennell
asked on
Printing reports which are stored in Access
What is the code to print reports, which are stored in Access, from VB? Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you want to print reports that are into an Access database, you need to have Access already installed onto your PC. The DataControl can only read the data from the Access database.
ASKER
Access is already installed. And I have my tables, queries, reports etc saved and linked to my VB program. But for some reason that code you have given me attempts to install Access when it is already installed.
Other than of course "report name" which I changed to the report name in my Access db, what other info needs to be changed from your code? You'll have to forgive my incompetence, I am only a beginner - novice programmer.
Other than of course "report name" which I changed to the report name in my Access db, what other info needs to be changed from your code? You'll have to forgive my incompetence, I am only a beginner - novice programmer.
>>And I have my tables, queries, reports etc saved and linked to my VB program
Reports cannot be "linked" to a VB program. A VB program using DAO/ADO/RDO can only use tables and queries.
>> attempts to install Access when it is already installed
Insert your CD and let it go. It may install a feature that wasn't installed initially.
Reports cannot be "linked" to a VB program. A VB program using DAO/ADO/RDO can only use tables and queries.
>> attempts to install Access when it is already installed
Insert your CD and let it go. It may install a feature that wasn't installed initially.
ASKER
Thank you. Reports are printing.
ASKER