Item cannot be found in the collection corresponding to the requested name or ordinal

Ok guys i cant work out why i keepp getting this message, i have check the debug.print out putin access and it works with no problems, and i have checked to make sure that this information is in the database and all the spelling is correct and it is, i guess if it wasnt it wouldnt be working in access the out put i am getting in the debug windows is

ms access uses the US format for "storing/recognizing" the dates.
for display in another format, you need to format the date value as needed, in access query that could be the Formatdatetime() function:

Your code snippet is incomplete, so it is difficult to tell what code is elsewhere with regards to the database connection. However, while you declare the sql string, there is no declaration to actually populate the rs recordset with the result of this query?

Code should be something like attached (I presume the bits I've added at the front you already have).

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Flash (http://en.wikipedia.org/wiki/Adobe_Flash) has evolved over the years to where it has become a masterful tool for displaying content screen. It has excellent layout placement, UI precision as well as rendering capabilities. This, along with t…

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…

This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…