From: Abuse@SpamBusters.com   
      
   Nicola schreef:   
   > Hi Everyone,   
   >   
   > I am new to programming and would like to know how to   
   > open an access Report from within vb 6. I am trying to write a program   
   > to organise cross stitch threads. I have found out how to use a database   
   > table   
   > but all I want to do now is to click a command button to display this access   
   > report.   
   >   
   > Any suggestions please ?????   
   >   
   > Thank you in advance   
   >   
   >   
   You'll have to have a variable pointing to the Access application (No   
   DAO or ADO here, reference access in your project and ask for a new   
   Access.Application object, or use the createObject function. With that   
   reference you can open a database and give the command to open the report:   
      
   set objDatabaseApplication=new Access.Application   
   (open a database. without trying, I think it is done with the   
   SetCurrentDatabase method)   
   objDatabaseApplication.DoCmd.OpenReport    
      
   Hope this helps   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)