General discussion
-
Topic
-
Save filter as query, MSAccess 97
LockedI need to know how to save a filter as query programatically, without having to prompt the user for a query name and whether they want to save over an existing query of the same name.
The situation is a search-engine type form where the user selects the criteria for the search from a form (thus creating the filter – filter by form). To print the search results, a need to save the filter as a query named “Print”, which has a report based on it. At the moment I have to ask the user to name the query and to OK copying over the existing query.
Is there a way to do this with VBA?M.R.Chambers
All Comments
Viewing 3 reply threads