One of my new clients it getting a rather strange issue using the AcitveX calendar control (within an Access 2003 database). I have the control embedded into a form, for scheduling call-backs etc. However, this client is having issues where they set the required call-back date (on the ActiveX control), but it ends up storing the value as today’s date. This is an intermittent issue, which none of my other clients have seen/reported in the seven years that it has been shipped (around 1000 units to date on over 20 different sites).
I've taken a look at the code over the past couple of weeks (which is basic to say the least), I've added delays, DoEvents, Refresh etc - but the problem has still not been resolved. My next port of call (after this), is possibly to get a Third party calendar (something like eXCalendar by eXontrol).
Has anyone ever seen this/similar issue, or have any useful suggestions - I really need to get it resolved (even if it isn't our software).
Thanks as always