Wrox Programmer Forums
BOOK: Access 2003 VBA Programmer's Reference
This is the forum to discuss the Wrox book Access 2003 VBA Programmer's Reference by Patricia Cardoza, Teresa Hennig, Graham Seach, Armen Stein; ISBN: 9780764559037
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Access 2003 VBA Programmer's Reference section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old June 13th, 2006, 03:40 PM
Registered User
Join Date: Jun 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default this Newbie has adp / stored query problems -

I converted a .mdb project to an adp. I have a form that has a stored parameter query as it's source. It works fine when I load the form first. However, when I use the button"Change client" to prompt me for another client number, I get error "applyfilter action contains a filter name that cannot be applied ". The event for this command button is : =OpenForms("edit client"), which in turn is supposed to run a parametized query.

When I right-click on the "change client" button I see the property 'remove filter/sort'. When I click on that, I then get my prompt. I can't leave the project like that. How do I get it to prompt me for the client number without having to click on that property? I know very little about how this is supposed to work. Is this working this way because it's an ADP ? thanks for any suggestions you may have.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Running stored procedure from .adp module mantle51 Access VBA 1 August 13th, 2007 12:17 PM
adp- stored query problem LeoTiger1 Access 0 June 13th, 2006 04:11 PM
ADP Update Stored Procedure ashg657 Access 0 June 2nd, 2006 05:29 AM
Stored procedure as the rowsource for Report (ADP) Tero Access 1 May 12th, 2004 08:22 PM
Use of "IF" in a ADP Stored Procedure Mickey123 Access 0 December 5th, 2003 01:53 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.