Access 97 versus 2002? +

[ctuna02]

I notice that the FindLast method is missing when I type in type in the dot after rst but if I try to type in DAO before I type in recordset to select DAO.recordset that is also missing , DAO that is as a choice. How do you call up these functions or is it possible?
Do you have to call up the DAO Library someway first?

What I am trying to accomplish is to pick a field value out of the last instance of a record that has a field labeled hardware number and a Date time field , then grab the value and put in another field in the new record . This field is a number and will be added to the new input value in the new record. I already have a query that will pick out all the max dates for each hardware type I am using in a report. I don't have much expierence using querys in vba or with recordsets.

 

[FoFa]

If you are pulling the last date, why not just add the other field. It seems the last date would be the last record. One thing you must remember, records stored in a database are not always in the order input/inserted. If you want the last record sorted on some field, then Max or Min will work also, and is usually faster than finding through a record set.

 

[ctuna02]

First of All thank you for your reply
I realize the record sets can be resorted which means the last record won't always be the one with the highest date. I usually protect against this by locking out the ability of the user to add anything but a new record which should always be the highest record in an ascinding sort.
I suppose using the Date query is more correct. I havent' tried using querys inside VBA yet but I think I'll try it.