i built this event....
Private Sub Command39_Click()
Dim x As String
x = "All Current PC and Server"
DoCmd.OutputTo acOutputQuery, "x", acFormatXLS, "All Current PC and Server.xls", True
End Sub
Of course , that is not correct.
can anyone tell me how can i correct this and compile it...