Page 1 of 1

Access 2000 Send Parameter Date

Posted: Thu Oct 11, 2007 6:57 pm
by Rob_Turner_(Guest)
I seem to be having a problem in sending a date parameter to a reportworks report... i thought i did get it going with the following code, but it does not now seem to work..____I have a rr parameter field which prompts the user for a fromto date__it in in Date format....I need to send a from and a to date from my access 2000 program which alters the default dates in the report parameter selections...____ WDir = "c: rdebtorsfor164.rsw"__ Report1.ReportName = WDir__ Report1.Destination = 1__ Report1.Parameters(0) = "D1=01/09/2007"__ Report1.Parameters(1) = "D2=01/09/2007"__ Report1.Action = 1____This code does not alter the rr parameters fields when i run the report____Appreciate any help____Robert__

=> RE: Access 2000 Send Parameter Date

Posted: Thu Oct 11, 2007 8:07 pm
by Robert_(Guest)
All ok..... sorry....____I now realize i have to use__RIPARAM("d1") in a calculate field...to get the result i need.______Regards Robert__