Re: Can I pass parameters from a macro to query?

I would put this all in one vba routine. This is a fairly short bit of
code, so if you let us know the parameters (e.g. is it start and end dates)
I could show you an idea of how to do it - sometime this afternoon.



"skinnybloke" <theoriginalsin73@xxxxxxxxxxx> wrote in message
news:lj6012tskg39aidashunt7fagbhn7r5ue1@xxxxxxxxxx
Hi - my knowledge of Access and VBA is very sketchy so please bear
with me.

The way that I have set this up is via a switchboard. You click on an
option and it runs code to delete 3 files if they already exist and
then runs 3 queries to export 3 excel files.

This was fine until the parameters were required as an additional
requirement.


On Thu, 9 Mar 2006 12:02:38 +0000 (UTC), "Anthony England"
<aengland@xxxxxxxxxx> wrote:

"skinnybloke" <theoriginalsin73@xxxxxxxxxxx> wrote in message
news:9i501295s5p499pi8ae8on7al0sg28iq07@xxxxxxxxxx
Hi - I have 3 access queries which I run via 1 macro.

Each of the queries now requires 2 parameters when they the run. The
parameters are start and end dates.

I have built the parameters into the queries but on running the macro
I have to enter each of the dates 3 times - once for each query.

Is there an easy way to ask for the parameters once and for these to
be passed onto each query?

TIA



The standard way to do this is to have a form open with controls on it to
hold the values. For example, if you had txtStartDate and txtEndDate as
textboxes on a form, then the query could take as parameters:
Forms!MyOpenForm.txtStartDate and Forms!MyOpenForm.txtEndDate

Of course, there may be a better way to do what you are doing, but we
don't
have any details. After all, you might be running action queries where it
would be more appropriate to do the whole thing in vba code with the three
actions all wrapped in a transaction.







.