ADP - DoCmd.OpenReport
Posted on 2004-11-27
DoCmd.OpenReport "rptShipping", acViewPreview, , "dbo.orders.or_id = " &
"The column prefix does not match with a
table name or alias used in the query"
It really does though, Something with this being a ADP for sure
I was trying this, until I found there was no Open() method:
Dim r As New Access.Report
r.Name = "rptShippingReportSuppliment_Receipts"
r.FilterOn = True
r.ServerFilter = "dbo.orders.or_id = " & CStr(or_id)
Access 2003 - ADP - SQL Server 2000 SP3a