Board index » delphi » A dream : Can I access MS-ACCESS 97 Reports using D3 ?

A dream : Can I access MS-ACCESS 97 Reports using D3 ?

I have a dream : access a MS-ACCESS 97 report using Delphi 3.0 . Does
anyone know how I come true my dream ?

--------------------------
Jucimar Junior
Analista de Sistema FUCAPI
jjun...@fucapi.br

 

Re:A dream : Can I access MS-ACCESS 97 Reports using D3 ?


On 19 Mar 1998 13:48:46 GMT, "Jucimar Maia da Silva Junior"

Quote
<jucimar_jun...@hotmail.com> wrote:

>I have a dream : access a MS-ACCESS 97 report using Delphi 3.0 . Does
>anyone know how I come true my dream ?

Check your mail!

Re:A dream : Can I access MS-ACCESS 97 Reports using D3 ?


I have the same dream. Any advice for me?

Thanks!

On Thu, 19 Mar 1998 14:48:06 GMT, HnFaerber-NoSp...@Cis.com (Heinz

Quote
Faerber) wrote:
>On 19 Mar 1998 13:48:46 GMT, "Jucimar Maia da Silva Junior"
><jucimar_jun...@hotmail.com> wrote:

>>I have a dream : access a MS-ACCESS 97 report using Delphi 3.0 . Does
>>anyone know how I come true my dream ?

>Check your mail!

Re:A dream : Can I access MS-ACCESS 97 Reports using D3 ?


Heinz Faerber (Thank's !) gives me this code :

procedure TForm1.Report1Click(Sender: TObject);
Var
  msa     : Variant;
  vString : Variant;
begin
    { use MSACCESS as an OLE Controler  }
     msa := CreateOleObject('Access.Application.8');

     { path to database }
     vString := c:\reports\report.MDB' ;

     { open database }
     msa.OpenCurrentDatabase( vString );

     { report to print }
     vString:='CusomerReport'];

     { print the report, no preview }
     msa.DoCmd.OpenReport( ReportName:=vString, View:=0);
     msa.Quit(Option:=2);

end;

By Heinz Faerber

Other Threads