No not a quer, its a report. I solved it i had no AppAccess.Visible = True so this is my code now and it shows the report

VB Code:
  1. Dim AppAccess As Access.Application

  2.  
  3.     Set AppAccess = New Access.Application

  4.     AppAccess.Visible = True

  5.     

  6.     With AppAccess

  7.         .OpenCurrentDatabase "D:\Documents and Settings\christopher.lynch\Desktop\Manual Time And attendance\\Manualrecords.mdb"

  8.         .RunCommand acCmdWindowHide

  9.         .RunCommand acCmdAppMaximize

  10.         .DoCmd.OpenReport "Manual", acViewPreview

  11.        

  12.         

  13.     End With

How can i only show the report and not the access background and is it possible to send the report to a printer aswell