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


Then again I may be able to do it like this


http://groups.google.co.uk/group/microsoft.public.access.modulesdaovba/browse_thread/thread/b58ab771f40c4da6/76d979a1a68945e9?lnk=st&q=ms+access+pass+parameter+from+macro+to+queries&rnum=46&hl=en#76d979a1a68945e9



On Thu, 09 Mar 2006 12:11:08 GMT, skinnybloke
<theoriginalsin73@xxxxxxxxxxx> wrote:

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.





.

Relevant Pages

  • Re: Can I pass parameters from a macro to query?
    ... then runs 3 queries to export 3 excel files. ... Each of the queries now requires 2 parameters when they the run. ... I have to enter each of the dates 3 times - once for each query. ... you might be running action queries where it ...
    (comp.databases.ms-access)
  • Re: Can I pass parameters from a macro to query?
    ... I would put this all in one vba routine. ... Each of the queries now requires 2 parameters when they the run. ... I have to enter each of the dates 3 times - once for each query. ... you might be running action queries where it ...
    (comp.databases.ms-access)
  • Re: Can I pass parameters from a macro to query?
    ... Hi - my knowledge of Access and VBA is very sketchy so please bear ... Each of the queries now requires 2 parameters when they the run. ... I have to enter each of the dates 3 times - once for each query. ... you might be running action queries where it ...
    (comp.databases.ms-access)
  • Re: Can I pass parameters from a macro to query?
    ... from seeing how others would do the whole routine in vba. ... Each of the queries now requires 2 parameters when they the run. ... I have to enter each of the dates 3 times - once for each query. ... you might be running action queries where ...
    (comp.databases.ms-access)
  • RE: Dynamically referencing a recordset?
    ... through that recordset to set the query parameters in VBA. ... to be the one who had to modify 1440 queries if there is a change in the ... different table schema, then you need 3, one for each record type. ... This is a database that tracks the production on records in another ...
    (microsoft.public.access.modulesdaovba)