Access 2000 Send Parameter Date

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Rob_Turner_(Guest)
Posts: 1
Joined: Tue Oct 10, 2017 12:44 pm

Access 2000 Send Parameter Date

Post by Rob_Turner_(Guest) » 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__

Robert_(Guest)
Posts: 12
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Access 2000 Send Parameter Date

Post by Robert_(Guest) » Thu Oct 11, 2007 8:07 pm

All ok..... sorry....____I now realize i have to use__RIPARAM("d1") in a calculate field...to get the result i need.______Regards Robert__

Post Reply