I need (in my SQL) to select records from my Access DB where a paticular Month matches the one in the Date field.
So I pull out all records for one paticular month.
I tryed:(September select example)
"SELECT * FROM tblStats ORDER BY Date WHERE Date=#10/%/%#"
But this doesn't work...
I've just changed to Jet to connect to my DB, im running a NT 4 server with IIS 1 or 2 I think.
I've dealt with a lot of errors in the past, however this one mystifies me
" error '80004005' Unspecified error "
nice one Microsoft.
It refers to the line after the last line in an include...
Im using Access2000
UltraDev...Sorry
And it works fine inserting elsewhere...
This meesage has come up before for, me. It is when I am Inserting a new record, and there is a many-to-one relational numeric field in there. It pulls up the Column Header type mismatch error, yet my headers are all...
I have a cute little page that Pulls stories from a DB, and well, its uses a querystring to pull certain ID numbered records from the DB. I didn't use the POST method, as I wanted to be able to link to the news page with a specific story in mind. Well, I can only pass a query string to just the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.