Open a report : DoCmd « Application « VBA / Excel / Access / Word






Open a report

 

Sub dsub()
    DoCmd.OpenReport "reportName", acViewPreview
End Sub

 








Related examples in the same category

1.Save changes to the client record
2.Undo changes made to the current record
3.Closes the window of an Access object: DoCmd.Close([ObjectType][, ObjectName][, Save])
4.Copies a database object into the same or another database: DoCmd.CopyObject([DestinationDatabase][, NewName][, SourceObjectType][, SourceObjectName])
5.Deletes a database object:DoCmd.DeleteObject([ObjectType][, ObjectName])
6.Using the DoCmd Object to Programmatically Add Sections to Reports at Runtime
7.Use DoCmd.OpenForm to open a form
8.Use DoCmd to close a form
9.Setting a Focus
10.Finding a Record
11.Validating a Record
12.Use DoCmd to open a form
13.Makes a sound using the computer's built-in speaker.
14.Using the DoCmd Object to Run Commands
15.Sending Mail
16.Calling the Report from VBA
17.DoCmd.Echo