ADP OpenReport()

ginoitalo · November 26th, 2004, 05:52 PM

DoCmd.OpenReport "rptShipping", acViewPreview, , "dbo.orders.or_id = " & CStr(or_id)

Error:
"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

Code:

   
Dim r As New Access.Report
r.Name = "rptShippingReportSuppliment_Receipts"
r.FilterOn = True
r.ServerFilter = "dbo.orders.or_id = " & CStr(or_id)

Any Workarounds ?

jemacc · November 26th, 2004, 08:05 PM

is this line really as it appears

Code:

DoCmd.OpenReport "rptShipping", acViewPreview, , "dbo.orders.or_id = " & CStr(or_id)

check the double comma

Code:

DoCmd.OpenReport "rptShipping", acViewPreview, "dbo.orders.or_id = " & CStr(or_id)

Jaime E. Maccou
Applications Analyst

jemacc · November 26th, 2004, 08:11 PM

sorry the comma belongs there

Try

Code:

Dim strDocName As String

strDocName = "rptShippingReportSuppliment_Receipts"
DoCmd.OpenReport strDocName, acViewPreview, , "Orders.or_ID = " + CStr(Me.Or_ID)

Jaime E. Maccou
Applications Analyst

ginoitalo · November 27th, 2004, 03:31 PM

Same problem, can the input paramaters be of any help ?

jemacc · November 27th, 2004, 06:44 PM

Yes, Please post your entire code.

Jaime E. Maccou
Applications Analyst

ginoitalo · November 29th, 2004, 04:15 PM

I don't have any using input parameters yet,,,

Still with the column prefix dbo.orders does not match a table in your query
BUT IT DOES ! argh

jemacc · November 29th, 2004, 04:58 PM

What version of access are you using? Make sure you have the latest Microsoft Jet 4.0 Database Engine.

Jaime E. Maccou
Applications Analyst

ginoitalo · November 29th, 2004, 05:37 PM

Access 2003 ADP - All Updated

The frustrating thing is that the report works perfectly on it's own, just not with the OpenReport() where clause

jemacc · November 29th, 2004, 09:10 PM

Test this

Create a command button on your form using the wizard for printing a report.

Then look at the code generated and see it it works that way

Jaime E. Maccou
Applications Analyst