B
Bill Kuhn - MCSE
(I hate to cross post but I need to find a solution quickly)
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.
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.