Output to Macro action

  • Thread starter John via AccessMonster.com
  • Start date
J

John via AccessMonster.com

This is my second attempt to resolve this issue.

I have a DB that runs several differnt queries. I want to create a macro
that allows me to select the query that I want to output (as a .XLS file).
What I'td really like is to be able to Browse the different queries that I
have built and select the one that I would like to output. Either via a drop
down list of the queries or some type of quasi query "Browser."

Is this possible?
 
K

KARL DEWEY

Create a form with you dropdown (Listbox) and After Update run your macro
with conditions. The conditions will be --
[Forms]![YourFormName]![YourLostbox] = "My first query"
[Forms]![YourFormName]![YourLostbox] = "My second query"

The action will be your first query, second query, etc, Close your form.
 
J

John via AccessMonster.com

Where do I put the conditions in?

KARL said:
Create a form with you dropdown (Listbox) and After Update run your macro
with conditions. The conditions will be --
[Forms]![YourFormName]![YourLostbox] = "My first query"
[Forms]![YourFormName]![YourLostbox] = "My second query"

The action will be your first query, second query, etc, Close your form.
This is my second attempt to resolve this issue.
[quoted text clipped - 5 lines]
Is this possible?
 
K

KARL DEWEY

In design view for the macro click on menu VIEW - Conditions. A column for
conditions opens in the grid.

John via AccessMonster.com said:
Where do I put the conditions in?

KARL said:
Create a form with you dropdown (Listbox) and After Update run your macro
with conditions. The conditions will be --
[Forms]![YourFormName]![YourLostbox] = "My first query"
[Forms]![YourFormName]![YourLostbox] = "My second query"

The action will be your first query, second query, etc, Close your form.
This is my second attempt to resolve this issue.
[quoted text clipped - 5 lines]
Is this possible?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top