Hello,

I have some questions regarding Reports. I'm currently working on a
little project in VB 4.0. Data is stored in an access database and it
is necessary for the project to generate reports.

Since I'm more accustomed to working with Access (7.0) than Crystal
Reports I was wondering if it is possible to print reports - made in
access - from code, preferably without having to open Access.

Anyone have any ideas on this?
Is it true that one can make nicer reports with Access than with CR?

Please respond by email (too) since the news server at work doesn't
get much messages and if it does they're delayed.

Thanks in advance,
Michiel Magne

You can access reports from Access, but you must do it via OLE.  I was
going to use this method, but found having access and vb loaded at the same
time used up too much ram.  Also, by the time I was done, I had pretty much
written an access program.  For example, after you create an instance of
access (which takes a long time to load), you must tell access to open the
database, open the report, etc.  My program had no vb command in it.

Crystal Reports is a lot smaller and you can do some really nice things
with it.  I usually end up writing a small vb program to create a temporary
database, then use crystal to do a crosstab, or just print the information.
 This way has worked pretty good.

Let me know if you want to see how to access Access' forms/reports from vb.