asked on

Copy Query Parameters (MS-Access-2003) from another Query.

How can I copy Query Parameters from another query?

In the Column where I'm specifying the parameters (within a query) - Can I just point it to look for the parameters show in another query within the same database?

Both Queries have a PPEndDate parameter that reads: Between #10/13/2007# And #6/7/2008#
I want the 2nd Query - to look at the first one and replace it's date parameters with what it sees in the 1st query.

Is there a simple way that I can write this in write into the column?

Please assist... Thanking you for your timely feedback & help, sincerely, Raj.

peter57r

No.

It sounds like you need to create a form for the input of your parameter dates and then you can refer to the form textboxes in any query.

Jim Horn

peter57 nailed it.

SOLUTION

jppinto

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

R B

ASKER

That's not the case scenario here. The 1st Query would have been run as part of a huge array module that executes via a Macro. It's really a convoluted & very complicated set-up scenario.

I can't touch what I mentioned above - but, need to supplement to it - with a new Make-Table-Query that will need to "copy" the parameter that would have saved within Query 1 of that huge array. This is the PPEndDate for which the parameter would be in a format of " Between #mm/dd/yyyy# And #mm/dd/yyyy##.

Can I copy what's there in that column over to this column? Or - Word the SQL to reflect this?
Both Queries exist within the same database.
Here's what's in the Query SQL of the one that needs to be changed referencing the 1st Query named _AUDDatesQry :

SELECT [_dbo_ncv_audit_val_allocs].* INTO [Labor Distribution Output - Value Allocation] IN 'L:\$CA_Prod\Fy2008\AUD\RAJ_AUD_FY2008_MAY.mdb'
FROM _dbo_ncv_audit_val_allocs
WHERE ((([_dbo_ncv_audit__val_allocs].PPEndDate) Between #10/13/2007# And #5/24/2008#));

Please assist... thanks, Raj.

peter57r

'a new Make-Table-Query that will need to "copy" the parameter that would have saved within Query 1 of that huge array'

Unless you have actively saved the parameter values they would have been lost as soon as the query had been run.

R B

ASKER

Yes... The parameter value gets saved in Query 1. If you open the design view, the parameter column reads ' Between #10/13/2007# And #6/7/2008# '. The SQL View of Query 1 show it too. Here it is from Query 1:

SELECT [_dbo_ncv_audit_dates].*
FROM _dbo_ncv_audit_dates
WHERE ((([_dbo_ncv_audit_dates].PPEndDate) Between #10/13/2007# And #6/7/2008#));

So, I just literally need for Query 2 to go and copy what is showing above in Query 1.
Is this possible? perhaps via a VBA Module?

Please assist, thanking you for your time, sincerely, Raj.

ASKER CERTIFIED SOLUTION

peter57r

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

R B

ASKER

Thanks Guys!!!! Your coding to copy the query-parameters worked - helped me greatly!!!
And - the form idea - also - I'll be use in other scnearios.
Thanks a Million!! to both of you.