Access 2000 Send Parameter Date
Posted: Thu Oct 11, 2007 6:57 pm
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__