[AccessD] Try this one again

John Clark John.Clark at niagaracounty.com
Thu Dec 17 12:46:49 CST 2009


OK...about a month ago, I asked for help on this, and I did get some...one that seemed really promising...but nothing worked. It has to be easy...something common. I was pulled away from this project, but now, w/the end of the year coming, they want it quick, so I've got a couple of days to finish it. I've already got an idea of how to avoid the problem all together, but it won't be the "proper" way to do it, IMHO. So, I'd like to complete it, how I want to do it.
 
How do I get information from a query, into my form, and thus, if necessary, into my table?
 
I've got a query, which I got help on, from you guys, that works great...as a query. Enter a date and you will get the single value for that date. The SQL for the query is:
 
SELECT TOP 1 tblMileageRate.datDate, tblMileageRate.curMRate
FROM tblMileageRate
WHERE (((tblMileageRate.datDate)<[Date Entered]))
ORDER BY tblMileageRate.datDate DESC;
 
But, I've tried so many ways to do this right from the form, and I cannot get it to work. I looked into A.D.'s example, and I think it has gotten me close...I tried a statement like Me.curMRate.Value = "qryMileageByDate" but this isn't quite right either...says I can't assign a value to this object. 
 
I've already started whipping up a substitute program that avoids any of this stuff, but it is not what I wanted. I want the user to be able to lookup a record and the rates for the date of that record will always be in there.
 
Here is the really dumb thing about it...I've done this before. I wrote a program that did pretty much exactly what I am trying to do. But, that was 4-5 years ago, and I really haven't done much coding in that time.
 
To put the question simply, how do I send a date to a query, from a form, and get back a rate based on that date...this would be the latest entry as of the entered date...basically what the code above does, but via the form?
 
Thank you very much for all the help so far, by the way!
 
John Clark



More information about the AccessD mailing list