Search Result

charles07 · May 4 '12, 04:23 AM

how can i get records by the latest date. ie. select last inserted records. mysql db structure below

Code:

timestamp  method  id comment
2009-01-10 getThud 16 "....."
2009-01-10 getFoo  12 "....."
2009-01-10 getBar  12 "....."
2009-01-11 getFoo  12 "....."
2009-01-11 getBar  12 "....."

desired results

Code:

timestamp  method  id comment

...

internetintern · Oct 1 '09, 11:59 AM

hello,

I have a code like:

Code:

Private sub button1_Click()
DoCmd.FindRecord Me.fieldname.Value, acStart, , acSearchAll, , , False
end sub

but the problem is that the command stops searching at the last record. so the records before the current record are not searched. I thought with acSearchAll it should search the entire record list.

I need some help here.

Search Result

select records by latest date

DoCmd.FindRecord ends at last record