Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.40K
~87 People Reached
About Me
Developer
- Interests
- Computers
Favorite Forums
Databases
x
1
Favorite Tags
microsoft-access
x
1
|
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") & … |