Selecting a Query from a drop down box

  • Thread starter Thread starter d3cyph3r
  • Start date Start date
D

d3cyph3r

Hi, I'm using access2000 and instead of reporting i export my queries
in to excel so the feild guys can work from the info given.
At present i right chick the query, edit the dates then export it to
excel and was wondering if there was a way to list the queries in a
dropdown box and then be able to amend the dates and export the query
from form.
The main reason for wanting to do this is the other people who use the
database are less familiar with access so manually editing the filters
in the design view can lead to problems. Thus i'm trying to simplify
the process so they don't change what they are not supposed to.

I can make reports appear in the combo boxes but can't seem to get the
queries to. I haev also sorted the ability to filter the dates but
what i am stuck on is getting the queries to show up.

can anyoen help?
 
When I want this functionality, I generally create a table that contains the
query (or report name), and a description of the query or report.

I then use that table to populate a list (displaying only the description to
the user). Depending on which query/report is selected (use the lists Click)
event, I display text boxes (or in some instances combos) for the appropriate
parameters to the right of the list. Then I have a Print or Export button
that, when clicked will either print the results (I usually do this to
PrintPreview) or Export (Output) the results to a file. You might also want
to include a "Send To" option that would actually send the output as an
attachment to an email rather than saving it to your hard drive.

HTH
 
Back
Top