Planboard problem with dates

[dummy1]

I ve downloaded a database planboard what i integrated in my Database planning. Now i ve got a problem with tht form Hourgrid. I m not able to add timeschedules from 1 to 11 day of each month. I suppose it has to do something with dd,mm,yyyy or mm,dd,yyyy date format. After 3 days of search and changing stuff, i am realy stucked in to this problem.

Some one have maybe a solution?

I uploaded the mdb, maybe someone can find the problem

Greets

Dummy

 

[missinglinq]

You have, I suspect, already identified the culprit here! Allen Browne, the "Wonder from Down Under" has an excellent page explaining the problem and giving workarounds:

http://www.allenbrowne.com/ser-36.html

 

[dummy1]

Hello All,

Still not 100 % working grid.

Date Problem i ve solved with the solutions above sujested.

But still have problems with my Grid, it actualy not working well, and also when i use the calendar form to an earlier day, the grid is using the second raw... It has to do something with the Vba Code but i still struggling with that, has someone idea 's

Wish someone had a helping hand for me on this topic, because i am struggling way to long with this grid controll. I just hoped it was a bit easier.