ADO

[Lorna]

I have a simple Form with an ADO control on it that references an Access table. Now - on the screen I can just navigate through the records. How can I print all the records in the table?

Thanks
Lorna

[Cakkie]

Well, there are several options, you can devid them into two categories:

1) the do-it-yourself category
This is using the printer object, saying by code where which piece of data belongs on the paper, but this involves a lot of things like making sure everything is aligned properly. I would say NI to this.

2) the let-something-do-it-for-me category
This is by making use of reports, creatable by several third-party controls. I think the most famous is Crystal Reports, and the Microsoft report designer. If it's just a report from 1 table, the latter will do, if you need a report with subreports and stuff, you should go for Chrystal reports.
Both allow you to design your reports in about the same way you can do this with Access. I would greatly advice you to use one of these.

Tom Cannaerts
slisse@planetinternet.be

Programming today is a race between software engineers striving to build bigger and better idot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook