whats new ¦  programming tips ¦  indy articles ¦  intraweb articles ¦  informations ¦  links ¦  interviews
 misc ¦  tutorials ¦  Add&Win Game

Tips (1547)

Database (90)
Files (137)
Forms (107)
Graphic (115)
IDE (21)
Indy (5)
Internet / LAN (131)
IntraWeb (0)
Math (76)
Misc (127)
Multimedia (45)
Objects/
ActiveX (51)

OpenTools API (3)
Printing (35)
Strings (83)
System (268)
VCL (243)

Top15

Tips sort by
component


Search Tip

Add new Tip

Add&Win Game

Advertising

29 Visitors Online


 
...print/preview MS Access reports?
Autor: Mike Shkolnik
Homepage: http://www.scalabium.com
[ Print tip ]  

Tip Rating (4):  
     


uses ComObj;

procedure TForm1.Button1Click(Sender: TObject);
var
  
Access: Variant;
begin
  
{open the Access application}
  
try
    
Access := GetActiveOleObject('Access.Application');
  except
    
Access := CreateOleObject('Access.Application');
  end;
  Access.Visible := True;

  { open the database 
   The second parameter specifies whether you want to open the
   database in Exclusive mode}
  
Access.OpenCurrentDatabase('C:\test.mdb', True);

  { open the report 
   The value for the second parameter should be one of
   acViewDesign, acViewNormal, or acViewPreview. acViewNormal, which is the
   default, prints the report immediately. If you are not using the type
   library, you can define these values like this: 

  const 
    acViewNormal = $00000000; 
    acViewDesign = $00000001;
    acViewPreview = $00000002; 

  The third parameter is for the name of a query in the current 
  database. The fourth parameter is for a SQL WHERE clause - the string must
  be valid SQL, minus the WHERE.}
  
Access.DoCmd.OpenReport('A Report name', 2, EmptyParam, EmptyParam);

  {close the database}
  
Access.CloseCurrentDatabase;

  {close the Access application}
  {const
    acQuitPrompt = $00000000; 
    acQuitSaveAll = $00000001;
    acQuitSaveNone = $00000002;}
  
Access.Quit(1);
end;

 

Rate this tip:

poor
very good


Copyright © by SwissDelphiCenter.ch
All trademarks are the sole property of their respective owners