Access 2007 runtime doesn't prompt for parameter

[BillKuhn]

As I continue to try to salvage an ADP project in Access 2007 (and the light
at the end of the tunnel has pretty much gone out due to Access 2007 bugs), my latest probable dead end is..

I have a parameterized function called
"Walmart_by_completion_info_parameterized" defined as..

SELECT DISTINCT TOP 100 PERCENT dbo.[WM-TRACKING].TrackingNum, dbo.[WM-Stores].StoreNum, dbo.[WM-Stores].City, dbo.[WM-Stores].State, dbo.[WM-TRACKING].CMPLTD_DATE, dbo.[WM-TRACKING].[CMPLTD SIGNATURE], dbo.ServiceProviders.Providers FROM dbo.[WM-Stores] INNER JOIN dbo.ServiceProviders INNER JOIN
dbo.[WM-TRACKING] ON dbo.ServiceProviders.ID =
dbo.[WM-TRACKING].SERVICE_BY ON dbo.[WM-Stores].StoreNum = dbo.[WM-TRACKING].StoreNum WHERE (dbo.[WM-TRACKING].RecvdCmpltdDate >= @Enter_RecvdCmpltdDate)
ORDER BY dbo.[WM-TRACKING].TrackingNum, dbo.ServiceProviders.Providers

.. which when used as the recordsource for a form in Access2007 prompts me for @Enter_RecvdCmpltdDate. Works fine (surprising for Access2007).

Now I make my .accdr version and run on an XP machine with only Access2007 Runtime - Now I get error "Parameters were not supplied for the function 'dbo.Walmart_by_completion_info_parameterized'." In runtime is is not prompting for the parameter.

Even more fun is that if I run the accdr using Access2007 Runtime on a machine that has Access 2007 installed the form works fine.

Nice consistant behaviour between runtime, full version, and runtime where full version is available.

This also happens on a report that uses a similar parameterized function as the recordsource. On a report the error is a little different - "The record source 'dbo.qryWalmartCountByState' specified on this form or report does not exist".

Again the recordsource expects a parameter. Again it works fine in full access 2007. It works fine in accdr using Access 2007 runtime on a machine that also has Access 2007. It gives me the error on machines that only have runtime 2007. It does not prompt for the parameter.

Any suggestions on how to make this work in runtime?




Bill Kuhn - MCSE
bkuhn@kuhngroup.com
The Kuhn Group, Inc.

http://www.kuhngroup.com

 

[joejack0330]

I had similar problem with .adp's and runtimes.

http://www.awomantoldme.com/women/how-to/31487484/error-in-runtime-bad-que.aspx

 

[BillKuhn]

Thanks!

I finally wound up making seperate forms for parameter input and had them call my original forms passing parameters in the OpenArgs parameter (multiple parameters had to be parsed). I removed the parameterized queries and dynamically built a select statement in the Load event of the original forms using the parameters passed in OpenArgs. It works in full and runtime versions.

Best I can tell, Access 2007 is a steaming pile. This is my first and last Access project.

Bill Kuhn - MCSE
bkuhn@kuhngroup.com
The Kuhn Group, Inc.

http://www.kuhngroup.com