SELECT by date...

[adamsoderqvist]

I'm trying to retrieve posts in Access by todays date (as in a guestbook).But it won't work.

This what i have:

SELECT PostDate, Subject, Message FROM tblMessages WHERE PostDate=#" & Date()& "#"

I get an error msg sayin that "...EOF or BOF true or..." -something else, yet when I retrieve by "Message" it's no problem!

HELP!

//thanx!

 

[GingerR]

what is exact error message?

could be problem with date() function? meaning problem with References. If error = 'cant find library' or something like that check
faq181-936

 

[adamsoderqvist]

No it´s not that. The Date function works just fine in other aspects...

This is the msg:

"ADODB.Recordset error '800a0bcd'

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record."

- Yet there is a record and, as I said, it works when I retrieve by other parameters such as the actual Message body or by subject!