Printing Invoices 2

[robman70]

I wanted to get some opinions because i dont really know where to start. I need to have my program generate printable invoices, the data will come from a sql server so the invoice will need to be created on the fly at run time. I just wanted to know if anyone has had to do something like this and if so, what route you chose. I tried just putting the info on a form and printing that but the formatting isnt that great. Any comments appreciated.

 

[JeffTullin]

Quick & Dirty:
Write the front end as an Access MDE.

The built-in report writer is more than capable of creating reasonable looking invoices from a query.


There are many report writing tools you can buy in to use with VB, but this comes 'free' as long as your user has Access installed.

 

[Swi]

VB's DataReport should suffice in your case.

Swi

 

[Swi]

Here is a tutorial if you have never used a DataReport before:

http://www.abstractvb.com/code.asp?F=48&P=2&A=708

Swi

 

[robman70]

Thanks for the quick replies, I think I'm going to familiarize myself with datareport, thanks the tutorial link Swi