I know you can run queries stored in Access with code like:
Set rsRecordset = Db.OpenRecordset(Name:="Query1", Type:=dbOpenSnapshot)
With Worksheets("Sheet1").Range("A1")
.CurrentRegion.Clear
.CopyFromRecordset Rs1
End With
but, is there a way to run a stored Access report?
This message was edited by Zzyzzyth on 2002-02-21 09:06
Set rsRecordset = Db.OpenRecordset(Name:="Query1", Type:=dbOpenSnapshot)
With Worksheets("Sheet1").Range("A1")
.CurrentRegion.Clear
.CopyFromRecordset Rs1
End With
but, is there a way to run a stored Access report?
This message was edited by Zzyzzyth on 2002-02-21 09:06