Generating A report in Access

[chris lynch]

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

Dim AppAccess As Access.Application
 
    Set AppAccess = New Access.Application
    AppAccess.Visible = True
    
    With AppAccess
        .OpenCurrentDatabase "D:\Documents and Settings\christopher.lynch\Desktop\Manual Time And attendance\\Manualrecords.mdb"
        .RunCommand acCmdWindowHide
        .RunCommand acCmdAppMaximize
        .DoCmd.OpenReport "Manual", acViewPreview
       
        
    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

[Malim]

Basically what you did was invoke the Access Application through VB code. You can return the recordset to a windows form or use Crystal Reports instead of Access. There is plenty of help on the internet and on this forum for you to figure this out. MSDN is a good place to start. Ultimately, the report has a record source which is a either a query, a table or a sql statement.