Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Access 2007 runtime doesn't prompt for parameter

Access 2007 runtime doesn't prompt for parameter

Access 2007 runtime doesn't prompt for 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.

Any suggestions on how to make this work in runtime?


Bill Kuhn - MCSE
The Kuhn Group, Inc.

RE: Access 2007 runtime doesn't prompt for parameter


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
The Kuhn Group, Inc.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close