I too need to run reports from VB, but I've got another twist to the... challenge. The app in question WAS running as an Access application, checking a database table every ten minutes for new records. Upon existence of such records, the app either a: ran a report which it faxed to the recipient, or b: sent an email, depending on the recipient's preference. Now, running Access in production is rather precarious, so I thought I'd port the thing to VB. The emailing business was a piece of cake - I even improved it using code I got from this very forum. Faxing proves more difficult - I use FaxNow!5, which has an API - it works fine from within Access: I initialise the API, then OpenReport and the fax is on its way. In the VB app I also initialise the API (I simply copied the code...), but since I'm not inside Access I do a CreateObject("Access.Application.8"
, then a DoCmd.OpenReport etc. The report runs and everything and the report does print to the Fax printer, but the fields in the Fax API are lost (fax number etc). It seems like the Access object and the FaxNow object are isolated from one another, but I'm not entirely sure as to how ActiveX works... I'll be very happy and grateful for ANY tips or clues...
/Cy
, then a DoCmd.OpenReport etc. The report runs and everything and the report does print to the Fax printer, but the fields in the Fax API are lost (fax number etc). It seems like the Access object and the FaxNow object are isolated from one another, but I'm not entirely sure as to how ActiveX works... I'll be very happy and grateful for ANY tips or clues.../Cy
