Change Query Parameters

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 397,752 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,548 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS Access and FileMaker Pro advertiser:

Thread Tools Display Modes

Views: 6044 | Replies: 0

•

Join Date: Mar 2005

Location: Israel

Posts: 1

Reputation: motid7 is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

motid7

Offline

Newbie Poster

Change Query Parameters

Mar 14th, 2005

I change query parameters in my code.

i want the query to change her Sql property to new sql with new parameters.

Set QueryDef = CurrentDb.QueryDefs("q_QueryName")

QueryDef.Parameters("[Param_1]") = stringvalue_1
QueryDef.Parameters("[Param_2]") = stringvalue_2
QueryDef.Parameters("[Param_3]") = stringvalue_3
QueryDef.Parameters("[Param_4]") = "#" & Format(timevalue_1, "HH:mm") & "#"
QueryDef.Parameters("[Param_5]") = "#" & Format(timevalue_1, "HH:mm") & "#"

QueryDef.Parameters.Refresh

'QueryDef.Sql

DoCmd.OpenReport "r_ReportName", acViewPreview

The report "r_ReportName" need to run with new Query and new parameters.
But, actually the Query.Sql didn't change at all.
and microsoft JET still ask me for enter parameters ??