adding a new record and saving it, moving to next, previous recordusing a form in Access 2007

#11

On 6/30/2010 9:00 PM, David W. Fenton wrote:

Quote:

g<g_1@g.com> wrote in news:9WJWn.378$Zp1.278 (AT) newsfe15 (DOT) iad:

1. Is there a way in Access 2007 where instead of creating another
6 query objects I can create a single query object which can
contain the 6 different queries and run query 1 when button 1 is
clicked, run query 2 when button 2 is clicked and so on.

2. If there is no such way, can I alleviate the issue of having
multiple query objects by running a macro when the button is
clicked which runs a query based on which button is clicked and
produces the results. How difficult would this be to do?
Currently, all I have to do is create a query object and add some
SQL to it so that it produces the desired result.

You could try a listbox that lists the queries, and a command button
that runs the query selected in the listbox. There are complexities
in that that are not amenable to solution with macros, but it's not
insurmountable.

Thanks for the advice. I appreciate it. Sorry for the late acknowledgement.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

adding a new record and saving it, moving to next, previous recordusing a form in Access 2007

comp.databases.ms-access comp.databases.ms-access

Re: Running different queries contained in a single query objectfrom a form - 07-03-2010 , 10:17 PM