Very Computer

Hey everyone... I was wondering if someone could help me
with a little problem I've encountered.  I was wondering
if anyone knows how to print an Access report from Visual
Basic 6 and set the filter property on that report.  I
can't seem to find any information on it.  Preferably I'd
like to avoid using Crystal Reports if at all possible.

Thanks a million!
~Todd

Hi Todd,

Quote:> I was wondering
> if anyone knows how to print an Access report from Visual
> Basic 6 and set the filter property on that report.

Best place to ask this kind of question is an ACCESS
newsgroup. Yes, I believe it can be done, by using
OLE-Automation of Access (your app opens the Access database
and sends the commands to deal with the report). You need to
look at the Access VBA Object model (yes, there is one,
besides the DAO part).

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister
http://www.mvps.org/word
http://go.compuserve.com/MSOfficeForum

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)

You could go to www.componentone.com   They used to be Videosoft, which had
a tool to run/print Access reports from VB

Anthony

Quote:> Hi Todd,

> > I was wondering
> > if anyone knows how to print an Access report from Visual
> > Basic 6 and set the filter property on that report.

> Best place to ask this kind of question is an ACCESS
> newsgroup. Yes, I believe it can be done, by using
> OLE-Automation of Access (your app opens the Access database
> and sends the commands to deal with the report). You need to
> look at the Access VBA Object model (yes, there is one,
> besides the DAO part).

> Cindy Meister
> INTER-Solutions, Switzerland
> http://homepage.swissonline.ch/cindymeister
> http://www.mvps.org/word
> http://go.compuserve.com/MSOfficeForum

> This reply is posted in the Newsgroup; please post any
> follow question or reply in the newsgroup and not by e-mail
> :-)