Re: Getting Criteria for Query from VB

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Steve Schapel (schapel_at_mvps.org.ns)
Date: 10/29/04 

Date: Fri, 29 Oct 2004 20:23:07 +1300

Amanda,

Yes, this is certainly possible, and as you so rightly point out, highly
desirable.

It is not clear from your post what the query criteria are supposed to
be, or where the "Task buttons" are supposed to get the criteria values
from. If you need more specific help, please post back with some more
details, maybe with examples. 

-- 
Steve Schapel, Microsoft Access MVP
Amanda Payton wrote:
> I have a parameter query that I would like to "automate" (if you will) by 
> using VB to pass criteria to a parameter query based on a command button.  
> 
> Basically - when my user clicks one of several buttons, I want a report 
> (based on a parameter query) to open, but I don't want the user to be 
> prompted for criteria, I want VB to supply it at the OnClick event from the 
> command button. 
> 
> The report opens fine, and such, but right now I've got a seperate report 
> and query for each button - and I'm accumulating enough queries and reports 
> that:
> A) it's getting to be obnoxious surfing through the list to find what I want 
> to edit
> B) when I edit the format/layout of 1 report, I have to edit all the others 
> to match
> 
> when I had 3 task buttons, it wasn't so bad... but now I've got 12.... not 
> so fun...
> I know a parameter query/report combo is the way to go - but like I said - I 
> don't want my users to be able to enter just anything for a parameter... 
> Especially after clicking a button that (logically) SHOULD have all 
> parameters defined. 
> 
> Ideas? thoughts?  HELP!  :-)
> 
> -Amanda
>
Quantcast