Want help to create ADO report thru code...

[jeba]

Hi there!
I just want tips or any help from u regarding the creation of ADO reports through code. Please help me.
I am using MS-Access as the back end.
thanks in advance.

[fhussain]

Are you using MS data environment to create the command object? Or are you calling in the Acces reports from the VB app?

If you are using the VB Data Environment you can use the Command object in your code just like you use the ADODB coomad object in your code.

A simple example would be

with dataenvironment1.rscmdyourcommand
.open
.Fileter="NightLight"
.close
End With

Datareport.show

to get more info visit this site

http://msdn.microsoft.com/library/devprods/vs6/vbasic/vbcon98/vbconusingmicrosoftdatareportdesigner.htm